| Recovery statement in standard Oracle backup Script ?? [message #388876] |
Thu, 26 February 2009 08:15  |
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 #388887 is a reply to message #388881] |
Thu, 26 February 2009 09:05  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
