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.
I am an IT professional with 10 years of professional experience,I have good proficiency on Oracle technologies, and at last 2 years of my career to study Real Application Clusters,data guard and participate actively on Oracle community ,If you want to hire me on Contract or to quote on project basis contact me at khurrampc@hotmail.com.
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