RMAN>list backup summary C:\>dir *.bus Volume in drive C is khurram Volume Serial Number is F49D-FF2B Directory of C:\ File Not Found C:\>dir *.arc Volume in drive C is khurram Volume Serial Number is F49D-FF2B Directory of C:\ File Not Found RMAN> crosscheck backup 2> ; using channel ORA_DISK_1 RMAN> list backup summary 2> ; RMAN> show retention policy 2> ; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default RMAN> run { 2> allocate channel ch0 type disk; 3> backup as compressed backupset database format 4> 'c:\rman_%s_%d_%T.bus' 5> plus archivelog format 'c:\arch_%s_%d_%T.arc'; 6> release channel ch0; 7> allocate channel ch1 device type disk format 'c:\arch_%s_%d_%T.arc'; 8> release channel ch1; 9> delete force noprompt obsolete; 10> allocate channel ch2 device type disk format 'c:\rman_%s_%d_%T.bus'; 11> release channel ch2; 12> delete force noprompt obsolete; 13> } released channel: ORA_DISK_1 allocated channel: ch0 channel ch0: sid=146 devtype=DISK Starting backup at 15-APR-08 current log archived channel ch0: starting compressed archive log backupset channel ch0: specifying archive log(s) in backup set input archive log thread=1 sequence=24 recid=79 stamp=652108461 input archive log thread=1 sequence=25 recid=80 stamp=652112650 channel ch0: starting piece 1 at 15-APR-08 channel ch0: finished piece 1 at 15-APR-08 piece handle=C:\ARCH_130_ORCL1_20080415.ARC comment=NONE channel ch0: backup set complete, elapsed time: 00:00:05 Finished backup at 15-APR-08 Starting backup at 15-APR-08 channel ch0: starting compressed full datafile backupset channel ch0: specifying datafile(s) in backupset input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\SYSTEM01.DB F input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\SYSAUX01.DB F input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\USERS01.DBF input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\UNDOTBS01.D BF channel ch0: starting piece 1 at 15-APR-08 channel ch0: finished piece 1 at 15-APR-08 piece handle=C:\RMAN_131_ORCL1_20080415.BUS comment=NONE channel ch0: backup set complete, elapsed time: 00:00:45 Finished backup at 15-APR-08 Starting backup at 15-APR-08 current log archived channel ch0: starting compressed archive log backupset channel ch0: specifying archive log(s) in backup set input archive log thread=1 sequence=26 recid=81 stamp=652112703 channel ch0: starting piece 1 at 15-APR-08 channel ch0: finished piece 1 at 15-APR-08 piece handle=C:\ARCH_132_ORCL1_20080415.ARC comment=NONE channel ch0: backup set complete, elapsed time: 00:00:02 Finished backup at 15-APR-08 Starting Control File and SPFILE Autobackup at 15-APR-08 piece handle=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL1\AUTOBACKUP\2008_ 04_15\O1_MF_S_652112718_408X3ZVJ_.BKP comment=NONE Finished Control File and SPFILE Autobackup at 15-APR-08 released channel: ch0 allocated channel: ch1 channel ch1: sid=146 devtype=DISK released channel: ch1 RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=146 devtype=DISK Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 128 15-APR-08 Backup Piece 128 15-APR-08 C:\ARCH_130_ORCL1_20080415.ARC Archive Log 79 15-APR-08 C:\ORACLE\PRODUCT\10.1.0\FLASH_RE COVERY_AREA\ORCL1\ARCHIVELOG\2008_04_15\O1_MF_1_24_408RYXDF_.ARC Archive Log 80 15-APR-08 C:\ORACLE\PRODUCT\10.1.0\FLASH_RE COVERY_AREA\ORCL1\ARCHIVELOG\2008_04_15\O1_MF_1_25_408X1SCR_.ARC deleted backup piece backup piece handle=C:\ARCH_130_ORCL1_20080415.ARC recid=128 stamp=652112652 deleted archive log archive log filename=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL1\ARCHIVEL OG\2008_04_15\O1_MF_1_24_408RYXDF_.ARC recid=79 stamp=652108461 deleted archive log archive log filename=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL1\ARCHIVEL OG\2008_04_15\O1_MF_1_25_408X1SCR_.ARC recid=80 stamp=652112650 Deleted 3 objects released channel: ORA_DISK_1 allocated channel: ch2 channel ch2: sid=146 devtype=DISK released channel: ch2 RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=146 devtype=DISK no obsolete backups found RMAN> C:\>dir *.bus Volume in drive C is khurram Volume Serial Number is F49D-FF2B Directory of C:\ 04/15/2008 02:24 PM 96,813,056 RMAN_131_ORCL1_20080415.BUS 1 File(s) 96,813,056 bytes 0 Dir(s) 61,960,724,480 bytes free C:\>dir *.arc Volume in drive C is khurram Volume Serial Number is F49D-FF2B Directory of C:\ 04/15/2008 02:25 PM 56,832 ARCH_132_ORCL1_20080415.ARC 1 File(s) 56,832 bytes 0 Dir(s) 61,960,724,480 bytes free C:\> RMAN> run { 2> allocate channel ch0 type disk; 3> backup as compressed backupset database format 4> 'c:\rman_%s_%d_%T.bus' 5> plus archivelog format 'c:\arch_%s_%d_%T.arc'; 6> release channel ch0; 7> } released channel: ORA_DISK_1 allocated channel: ch0 channel ch0: sid=146 devtype=DISK Starting backup at 15-APR-08 current log archived channel ch0: starting compressed archive log backupset channel ch0: specifying archive log(s) in backup set input archive log thread=1 sequence=26 recid=81 stamp=652112703 input archive log thread=1 sequence=27 recid=82 stamp=652112873 channel ch0: starting piece 1 at 15-APR-08 channel ch0: finished piece 1 at 15-APR-08 piece handle=C:\ARCH_134_ORCL1_20080415.ARC comment=NONE channel ch0: backup set complete, elapsed time: 00:00:02 Finished backup at 15-APR-08 Starting backup at 15-APR-08 channel ch0: starting compressed full datafile backupset channel ch0: specifying datafile(s) in backupset input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\SYSTEM01.DB F input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\SYSAUX01.DB F input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\USERS01.DBF input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL1\UNDOTBS01.D BF channel ch0: starting piece 1 at 15-APR-08 channel ch0: finished piece 1 at 15-APR-08 piece handle=C:\RMAN_135_ORCL1_20080415.BUS comment=NONE channel ch0: backup set complete, elapsed time: 00:00:45 Finished backup at 15-APR-08 Starting backup at 15-APR-08 current log archived channel ch0: starting compressed archive log backupset channel ch0: specifying archive log(s) in backup set input archive log thread=1 sequence=28 recid=83 stamp=652112925 channel ch0: starting piece 1 at 15-APR-08 channel ch0: finished piece 1 at 15-APR-08 piece handle=C:\ARCH_136_ORCL1_20080415.ARC comment=NONE channel ch0: backup set complete, elapsed time: 00:00:02 Finished backup at 15-APR-08 Starting Control File and SPFILE Autobackup at 15-APR-08 piece handle=C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL1\AUTOBACKUP\2008_ 04_15\O1_MF_S_652112928_408XBKCZ_.BKP comment=NONE Finished Control File and SPFILE Autobackup at 15-APR-08 released channel: ch0 RMAN> report obsolete 2> ; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of obsolete backups and copies Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 129 15-APR-08 Backup Piece 129 15-APR-08 C:\RMAN_131_ORCL1_20080415.BUS Backup Set 130 15-APR-08 Backup Piece 130 15-APR-08 C:\ARCH_132_ORCL1_20080415.ARC Backup Set 131 15-APR-08 Backup Piece 131 15-APR-08 C:\ORACLE\PRODUCT\10.1.0\FLASH_RE COVERY_AREA\ORCL1\AUTOBACKUP\2008_04_15\O1_MF_S_652112718_408X3ZVJ_.BKP Backup Set 132 15-APR-08 Backup Piece 132 15-APR-08 C:\ARCH_134_ORCL1_20080415.ARC Archive Log 81 15-APR-08 C:\ORACLE\PRODUCT\10.1.0\FLASH_RE COVERY_AREA\ORCL1\ARCHIVELOG\2008_04_15\O1_MF_1_26_408X3HRP_.ARC Archive Log 82 15-APR-08 C:\ORACLE\PRODUCT\10.1.0\FLASH_RE COVERY_AREA\ORCL1\ARCHIVELOG\2008_04_15\O1_MF_1_27_408X8RXN_.ARC RMAN> i have archivelog which is at FRA ,it also apply there and as well yours own defined backupsets path.
Tuesday, April 15, 2008
can i use the retention policy without using the Flash Recovery area?
can i use the retention policy without using the Flash Recovery area?
yes
Lets see here..
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment