Home » RDBMS Server » Backup & Recovery » Recovery statement in standard Oracle backup Script ?? (10.1.0.5.0 Windows)
Recovery statement in standard Oracle backup Script ?? [message #388876] Thu, 26 February 2009 08:15 Go to next message
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
Junior Member
Can someone please explain the "recover copy of database..." statement below?

This is the standard database copy RMAN script created by OEM, I'm struggling to understand what the purpose of that statement is.

Thanks for you help

Script:

run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA\$OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
}
Re: Recovery statement in standard Oracle backup Script ?? [message #388881 is a reply to message #388876] Thu, 26 February 2009 08:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-BAC

Regards
Michel
Re: Recovery statement in standard Oracle backup Script ?? [message #388887 is a reply to message #388881] Thu, 26 February 2009 09:05 Go to previous messageGo to next message
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
Junior Member
Thanks Mike, but I've already been through the documentation, that is why this post is here. Sorry if this appears to be a stupid question to you, perhaps one day these concepts will come as easy to me as they do to you.

The output of the script is below, the portion of the recover command. Everything about the recover command refers to "applying to one or more restored datafile". This appears to be backing up the datafile (new dates and times on those files) to the \datafile directory, but all the backup scripts I'm been through don't mention this statement for backups.

Thanks for any help on the concept.

RMAN>
allocated channel: oem_disk_backup
channel oem_disk_backup: sid=140 devtype=DISK
Starting recover at 25-FEB-09
channel oem_disk_backup: starting incremental datafile backupset restore
channel oem_disk_backup: specifying datafile copies to recover
recovering datafilecopy fno=00001 name=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\NJRRISKN\DATAFILE\O1_MF_SYSTEM_35S8QCLB_.DBF
recovering datafilecopy fno=00002 name=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\NJRRISKN\DATAFILE\O1_MF_UNDOTBS1_35S8SFSP_.DBF
recovering datafilecopy fno=00003 name=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\NJRRISKN\DATAFILE\O1_MF_SYSAUX_35S8R5HW_.DBF
recovering datafilecopy fno=00004 name=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\NJRRISKN\DATAFILE\O1_MF_USERS_35S8SW1S_.DBF
recovering datafilecopy fno=00005 name=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\NJRRISKN\DATAFILE\O1_MF_EXAMPLE_35S8RZ28_.DBF
recovering datafilecopy fno=00006 name=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\NJRRISKN\DATAFILE\O1_MF_RNJE_TBL_35S8P8GC_.DBF
recovering datafilecopy fno=00007 name=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\NJRRISKN\DATAFILE\O1_MF_RNJE_IND_35S8MMBV_.DBF
recovering datafilecopy fno=00008 name=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\NJRRISKN\DATAFILE\O1_MF_RNJE_LOB_35S8SNX4_.DBF
channel oem_disk_backup: restored backup piece 1
piece handle=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\NJRRISKN\BACKUPSET\2009_02_24\O1_MF_NNND1_TAG20090224T170043_4T8VJFHB_.BKP tag=TAG20090224T170043
channel oem_disk_backup: restore complete
Finished recover at 25-FEB-09
Re: Recovery statement in standard Oracle backup Script ?? [message #388894 is a reply to message #388887] Thu, 26 February 2009 09:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>but all the backup scripts I'm been through don't mention this statement for backups.
Unless my eyes are deceiving me, it is right there
>>backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database

Re: Recovery statement in standard Oracle backup Script ?? [message #388959 is a reply to message #388876] Thu, 26 February 2009 15:22 Go to previous messageGo to next message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
Here's an article on Oracle Technology Network that describes this very accurately.

http://www.oracle.com/technology/deploy/availability/pdf/rman_10g_twp.pdf
Re: Recovery statement in standard Oracle backup Script ?? [message #389153 is a reply to message #388959] Fri, 27 February 2009 07:22 Go to previous message
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
Junior Member

Thanks, that document did the trick.
Previous Topic: Script for Schedule Backup.
Next Topic: BACKING UP DATABASE WITH RMAN
Goto Forum:
  


Current Time: Tue Dec 06 02:25:32 CST 2016

Total time taken to generate the page: 0.08750 seconds