OraFAQ Forum: Backup & Recovery » Cloning Error:

Home » RDBMS Server » Backup & Recovery » Cloning Error: - RMAN-06758 (11.2.0.2, Redhat 5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cloning Error: - RMAN-06758 [message #531388]

Tue, 15 November 2011 13:29

sahadba
Messages: 59
Registered: September 2009
Location: Pune

Member

Hi Experts,

I am new to RMAN, while executing a clone script i got the below error : -

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/15/2011 20:07:34
RMAN-12010: automatic channel allocation initialization failed
RMAN-06758: DB_UNIQUE_NAME is not unique in the recovery catalog

Here i understand that RMAN couldn't find which SPFILE to use to restore the target DB.

How do i check for the DB_UNIQUE_NAME in recovery catalog?

The proposed solution that i found was

Use the FOR DB_UNIQUE_NAME option to specify the name of the instance whose parameter file you want to restore

Can anyone please explain me this as i fail to understand how to implement this in my clone script?

Thank you

Report message to a moderator

Re: Cloning Error: - RMAN-06758 [message #531389 is a reply to message #531388]

Tue, 15 November 2011 13:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>how to implement this in my clone script?
Please post your "clone" script.
Is this a dataguard implementation?

Report message to a moderator

Re: Cloning Error: - RMAN-06758 [message #531402 is a reply to message #531389]

Tue, 15 November 2011 15:40

sahadba
Messages: 59
Registered: September 2009
Location: Pune

Member

1) The same script works fine for other databases.
2) No it is not a Dataguard implementation

Report message to a moderator

Re: Cloning Error: - RMAN-06758 [message #531542 is a reply to message #531388]

Wed, 16 November 2011 12:45

sahadba
Messages: 59
Registered: September 2009
Location: Pune

Member

Hi,

I checked the Recovery Catalog database and found this : -

SQL> select * from rc_database where name like '%LUU%';

    DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS_TIME
---------- ---------- ---------- -------- ----------------- -------------------
  14663342   14663343 2901056869 LUU                      1 24.02.2009-15:00:53
  25597660   25718191 3444043551 URLUU           5.5208E+12 07.06.2011-13:10:10

Here database URLUU no longer exists in the Filesystem, therefore I thought it is best to unregister this database.

RMAN> set DBID 3444043551;

executing command: SET DBID
database name is "URLUU" and DBID is 3444043551

RMAN> unregister database;

database name is "URLUU" and DBID is 3444043551

Do you really want to unregister the database (enter YES or NO)? YES
database unregistered from the recovery catalog

RMAN> exit

Checked the Recovery Catalog : -

SQL>  select * from rc_database where name like '%LUU%';

    DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS_TIME
---------- ---------- ---------- -------- ----------------- -------------------
  14663342   14663343 2901056869 LUU                      1 24.02.2009-15:00:53

But on running the Clone Script I still get the same Error

RMAN-06758: DB_UNIQUE_NAME is not unique in the recovery catalog

Report message to a moderator

Re: Cloning Error: - RMAN-06758 [message #531543 is a reply to message #531542]

Wed, 16 November 2011 12:59

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Again,
unless you post the asked information (scripts, initfiles used etc), I really cannot help.
Guessing will not always work for me.

restore spfile for db_unique_name is supposed to be used only in dataguard configuraitons.

Report message to a moderator

Re: Cloning Error: - RMAN-06758 [message #531545 is a reply to message #531542]

Wed, 16 November 2011 13:16

sahadba
Messages: 59
Registered: September 2009
Location: Pune

Member

Hi,

I checked the db_unique_name of database from RMAN

RMAN> list db_unique_name of database;


List of Databases
DB Key  DB Name  DB ID            Database Role    Db_unique_name
------- ------- ----------------- ---------------  ------------------
14663342 LUU      2901056869       PRIMARY          LUU
14663342 LUU      2901056869       STANDBY          URLUU

I think if I UNREGISTER Db_unique_name URLUU, it should solve the issue

RMAN>  UNREGISTER DB_UNIQUE_NAME URLUU;

Please provide me with your inputs.

Thank You

[Updated on: Wed, 16 November 2011 13:16]

Report message to a moderator

Re: Cloning Error: - RMAN-06758 [message #531546 is a reply to message #531545]

Wed, 16 November 2011 13:23

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Quoting you from your previous post
>> 2) No it is not a Dataguard implementation

Quoting you again.
Quote:

RMAN> list db_unique_name of database;

List of Databases
DB Key DB Name DB ID Database Role Db_unique_name
------- ------- ----------------- --------------- ------------------
14663342 LUU 2901056869 PRIMARY LUU
14663342 LUU 2901056869 STANDBY URLUU

Which one of 'em is true?

As said earlier

restore spfile for db_unique_Name <yourDBUniquenameThatyouwant>

[Updated on: Wed, 16 November 2011 13:32]

Report message to a moderator

Re: Cloning Error: - RMAN-06758 [message #531547 is a reply to message #531546]

Wed, 16 November 2011 13:36

sahadba
Messages: 59
Registered: September 2009
Location: Pune

Member

Thank You Mahesh,

I think i am not well informed here.

I will get back with more specific info and if needed will post the script as well

Thanks again

Report message to a moderator

Previous Topic:	getting rman error!!
Next Topic:	restore issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 29 22:07:22 CDT 2023