Home » RDBMS Server » Backup & Recovery » RMAN Duplicate database (9.2.0.8 + Linux 64)
RMAN Duplicate database [message #435331] Tue, 15 December 2009 11:35 Go to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

In RMAN Duplicate database facing some issues. In my catalog database having only December backup details. But I want create duplicate database from Nov 8-13 backup.

In Oracle 10g having CATALOG BACKUPPIECE command to register backup but in 9i tried CATALOG DATAFILECOPY, ARCHIVELOG but it seems not working. Please let me know is there any way to register old backup details in catalog database.

- Babu


RMAN> run
2> {
3> set until time="TO_DATE('11/13/2009 15:30:00', 'MM/DD/YYYY HH24:MI:SS')";
4> Allocate auxiliary channel ch1 type disk;
5> Allocate auxiliary channel ch2 type disk;
6> Allocate auxiliary channel ch3 type disk;
7> DUPLICATE TARGET DATABASE TO UAT;
8> release channel ch1;9
9> release channel ch2;
10> release channel ch3;
11> }

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 15-DEC-09

released channel: ch1
released channel: ch2
released channel: ch3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/15/2009 11:09:54
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 57 found to restore
RMAN-06023: no backup or copy of datafile 56 found to restore
RMAN-06023: no backup or copy of datafile 55 found to restore
RMAN-06023: no backup or copy of datafile 54 found to restore
RMAN-06023: no backup or copy of datafile 53 found to restore
RMAN-06023: no backup or copy of datafile 52 found to restore
RMAN-06023: no backup or copy of datafile 51 found to restore
RMAN-06023: no backup or copy of datafile 50 found to restore
RMAN-06023: no backup or copy of datafile 49 found to restore
RMAN-06023: no backup or copy of datafile 48 found to restore
RMAN-06023: no backup or copy of datafile 47 found to restore


RMAN> catalog DATAFILECOPY '/u02/backup/UAT/UAT_LVL0_200912130300_mkl0p4fn_s724_p5' LEVEL 0;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 12/15/2009 12:47:53
ORA-19563: datafile copy header validation failed for file /u02/backup/UAT/UAT_LVL0_200912130300_mkl0p4fn_s724_p5

[Updated on: Tue, 15 December 2009 11:38]

Report message to a moderator

Re: RMAN Duplicate database [message #435334 is a reply to message #435331] Tue, 15 December 2009 11:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Instead of duplicate restore the backup in the target server.
First restore the last control file of this period as it should contain the appropriate backup list.

Regards
Michel
Re: RMAN Duplicate database [message #435336 is a reply to message #435331] Tue, 15 December 2009 11:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Why Not just restore?

Edit:
Michel was faster

[Updated on: Tue, 15 December 2009 11:54]

Report message to a moderator

Re: RMAN Duplicate database [message #435347 is a reply to message #435336] Tue, 15 December 2009 13:31 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Hello Mr Mic & Mahesh,

Thanks for your response.

>>First restore the last control file of this period as it should contain the appropriate backup list.

I tried the same but in my target server all the mount points are different & also got some space issue.

Note: In my pfile/spfile already configured DB_FILE_NAME_CONVERT & LOG_FILE_NAME_CONVERT but still this parameter not considering. Could you please confirm me. If i fire RESTORE DATABASE rman will consider this two parameter?

- Babu
Re: RMAN Duplicate database [message #435349 is a reply to message #435347] Tue, 15 December 2009 13:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> In my pfile/spfile already configured DB_FILE_NAME_CONVERT & LOG_FILE_NAME_CONVERT but still this parameter not considering

Using OMF?
If DB_FILE_NAME_CONVERT is not working, use the good old
"SET NEWNAME ...".

Re: RMAN Duplicate database [message #435350 is a reply to message #435347] Tue, 15 December 2009 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With RESTORE these parameters are not used (as far as I know). You have to rename the files.
You can restore the control file where you want using RESTORE CONTROLFILE TO 'file'.

Regards
Michel
Re: RMAN Duplicate database [message #435351 is a reply to message #435350] Tue, 15 December 2009 14:00 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>If DB_FILE_NAME_CONVERT is not working, use the good old

Thanks a lot Mr Michel. Let me try this & get back to you.

- Babu
Re: RMAN Duplicate database [message #435477 is a reply to message #435351] Wed, 16 December 2009 07:10 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

As i told you having RMAN backup from Nov 8th to 13th. We don't have hot backup.

As per you if i try to re-create controlflie getting this error.

Note: Looks we don't have physical file. Please let me know is there any other alternative way?


SQL> @controlfile.sql
CREATE CONTROLFILE REUSE DATABASE "PRD" RESETLOGS FORCE LOGGING ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'/u01/data/PRD/PRD_system01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Re: RMAN Duplicate database [message #435488 is a reply to message #435477] Wed, 16 December 2009 07:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not sure what you mean.
>>As per you if i try to re-create controlflie getting this error.
Michel asked to restore. Not to re-create.
Re: RMAN Duplicate database [message #435493 is a reply to message #435477] Wed, 16 December 2009 07:58 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Modify the script to fit your directories.

Regards
Michel
Previous Topic: backup/recovery
Next Topic: RMAN recover from full backup followed by interupted arch logs
Goto Forum:
  


Current Time: Fri Apr 19 04:31:29 CDT 2024