Home » RDBMS Server » Backup & Recovery » Cloning Error: - RMAN-06758 (11.2.0.2, Redhat 5.5)
Cloning Error: - RMAN-06758 [message #531388] Tue, 15 November 2011 13:29 Go to next message
sahadba
Messages: 54
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
Re: Cloning Error: - RMAN-06758 [message #531389 is a reply to message #531388] Tue, 15 November 2011 13:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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?
Re: Cloning Error: - RMAN-06758 [message #531402 is a reply to message #531389] Tue, 15 November 2011 15:40 Go to previous messageGo to next message
sahadba
Messages: 54
Registered: September 2009
Location: Pune
Member

1) The same script works fine for other databases.
2) No it is not a Dataguard implementation
Re: Cloning Error: - RMAN-06758 [message #531542 is a reply to message #531388] Wed, 16 November 2011 12:45 Go to previous messageGo to next message
sahadba
Messages: 54
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



Re: Cloning Error: - RMAN-06758 [message #531543 is a reply to message #531542] Wed, 16 November 2011 12:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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.
Re: Cloning Error: - RMAN-06758 [message #531545 is a reply to message #531542] Wed, 16 November 2011 13:16 Go to previous messageGo to next message
sahadba
Messages: 54
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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 Go to previous message
sahadba
Messages: 54
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
Previous Topic: getting rman error!!
Next Topic: restore issue
Goto Forum:
  


Current Time: Fri Aug 22 13:19:42 CDT 2014

Total time taken to generate the page: 0.08838 seconds