RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 1 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DATABASE\SNCFNE
W1.ORA'; # default
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=148 devtype=DISK
no obsolete backups found
RMAN>
D:\>rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Sun Sep 25 02:10:38 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: NEW1 (DBID=1594352576)
RMAN> backup database plus archivelog;
Starting backup at 25-SEP-11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
skipping archive log file D:\ORACLE\FRA\NEW1\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_
59_77LWX5YZ_.ARC; already backed up 2 time(s)
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_60_77
LWZRSH_.ARC; already backed up 1 time(s)
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_61_77
LX0VJQ_.ARC; already backed up 1 time(s)
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=62 recid=4 stamp=762482263
input archive log thread=1 sequence=63 recid=5 stamp=762486481
input archive log thread=1 sequence=64 recid=6 stamp=762571215
input archive log thread=1 sequence=65 recid=7 stamp=762582643
input archive log thread=1 sequence=66 recid=8 stamp=762735297
input archive log thread=1 sequence=67 recid=9 stamp=762735327
input archive log thread=1 sequence=68 recid=10 stamp=762747078
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 tag=TAG20110925T0211
22 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 25-SEP-11
Starting backup at 25-SEP-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 tag=TAG20110925T0211
32 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 25-SEP-11
Starting backup at 25-SEP-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=69 recid=11 stamp=762747118
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 tag=TAG20110925T0211
58 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 25-SEP-11
Starting Control File and SPFILE Autobackup at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 comment=
NONE
Finished Control File and SPFILE Autobackup at 25-SEP-11
RMAN>
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
no obsolete backups found
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_01MN3IS6_1_1
.BKP recid=1 stamp=762432390
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_02MN3ISV_1_1
.BKP recid=2 stamp=762432417
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG
20110921T104830_77LWX806_.BKP recid=3 stamp=762432511
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T104956_77LWZXCT_.BKP recid=4 stamp=762432597
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNNDF_TAG20110
921T104958_77LWZZ36_.BKP recid=5 stamp=762432599
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCSNF_TAG20110
921T104958_77LX0T7G_.BKP recid=6 stamp=762432626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T105027_77LX0X5O_.BKP recid=7 stamp=762432629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCNNF_TAG20110
921T105122_77LX2MNN_.BKP recid=8 stamp=762432683
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNSNF_TAG20110
921T105122_77LX2OV9_.BKP recid=9 stamp=762432685
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 recid=10 stam
p=762747084
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 recid=11 stam
p=762747092
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 recid=12 stam
p=762747119
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 r
ecid=13 stamp=762747121
Crosschecked 13 objects
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
no obsolete backups found
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
new RMAN configuration parameters are successfully stored
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_01MN3IS6_1_1
.BKP recid=1 stamp=762432390
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_02MN3ISV_1_1
.BKP recid=2 stamp=762432417
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG
20110921T104830_77LWX806_.BKP recid=3 stamp=762432511
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T104956_77LWZXCT_.BKP recid=4 stamp=762432597
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNNDF_TAG20110
921T104958_77LWZZ36_.BKP recid=5 stamp=762432599
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCSNF_TAG20110
921T104958_77LX0T7G_.BKP recid=6 stamp=762432626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T105027_77LX0X5O_.BKP recid=7 stamp=762432629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCNNF_TAG20110
921T105122_77LX2MNN_.BKP recid=8 stamp=762432683
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNSNF_TAG20110
921T105122_77LX2OV9_.BKP recid=9 stamp=762432685
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 recid=10 stam
p=762747084
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 recid=11 stam
p=762747092
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 recid=12 stam
p=762747119
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 r
ecid=13 stamp=762747121
Crosschecked 13 objects
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_01MN3IS6_1_1
.BKP recid=1 stamp=762432390
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_02MN3ISV_1_1
.BKP recid=2 stamp=762432417
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG
20110921T104830_77LWX806_.BKP recid=3 stamp=762432511
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T104956_77LWZXCT_.BKP recid=4 stamp=762432597
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNNDF_TAG20110
921T104958_77LWZZ36_.BKP recid=5 stamp=762432599
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCSNF_TAG20110
921T104958_77LX0T7G_.BKP recid=6 stamp=762432626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T105027_77LX0X5O_.BKP recid=7 stamp=762432629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCNNF_TAG20110
921T105122_77LX2MNN_.BKP recid=8 stamp=762432683
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNSNF_TAG20110
921T105122_77LX2OV9_.BKP recid=9 stamp=762432685
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 recid=10 stam
p=762747084
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 recid=11 stam
p=762747092
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 recid=12 stam
p=762747119
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 r
ecid=13 stamp=762747121
Crosschecked 13 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 1 21-SEP-11
Backup Piece 1 21-SEP-11 D:\ORACLE\PRODUCT\10.2.0\DATABASE
\SAN-MIGR_NEW1_01MN3IS6_1_1.BKP
Backup Set 2 21-SEP-11
Backup Piece 2 21-SEP-11 D:\ORACLE\PRODUCT\10.2.0\DATABASE
\SAN-MIGR_NEW1_02MN3ISV_1_1.BKP
Archive Log 1 21-SEP-11 D:\ORACLE\FRA\NEW1\NEW1\ARCHIVELO
G\2011_09_21\O1_MF_1_59_77LWX5YZ_.ARC
Backup Set 3 21-SEP-11
Backup Piece 3 21-SEP-11 D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET
\2011_09_21\O1_MF_ANNNN_TAG20110921T104830_77LWX806_.BKP
Archive Log 2 21-SEP-11 D:\ORACLE\FRA\NEW1\ARCHIVELOG\201
1_09_21\O1_MF_1_60_77LWZRSH_.ARC
Backup Set 4 21-SEP-11
Backup Piece 4 21-SEP-11 D:\ORACLE\FRA\NEW1\BACKUPSET\2011
_09_21\O1_MF_ANNNN_TAG20110921T104956_77LWZXCT_.BKP
Backup Set 6 21-SEP-11
Backup Piece 6 21-SEP-11 D:\ORACLE\FRA\NEW1\BACKUPSET\2011
_09_21\O1_MF_NCSNF_TAG20110921T104958_77LX0T7G_.BKP
RMAN>
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 1 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DATABASE\SNCFNE
W1.ORA'; # default
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_01MN3IS6_1_1
.BKP recid=1 stamp=762432390
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_02MN3ISV_1_1
.BKP recid=2 stamp=762432417
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG
20110921T104830_77LWX806_.BKP recid=3 stamp=762432511
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T104956_77LWZXCT_.BKP recid=4 stamp=762432597
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNNDF_TAG20110
921T104958_77LWZZ36_.BKP recid=5 stamp=762432599
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCSNF_TAG20110
921T104958_77LX0T7G_.BKP recid=6 stamp=762432626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T105027_77LX0X5O_.BKP recid=7 stamp=762432629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCNNF_TAG20110
921T105122_77LX2MNN_.BKP recid=8 stamp=762432683
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNSNF_TAG20110
921T105122_77LX2OV9_.BKP recid=9 stamp=762432685
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 recid=10 stam
p=762747084
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 recid=11 stam
p=762747092
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 recid=12 stam
p=762747119
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 r
ecid=13 stamp=762747121
Crosschecked 13 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
no obsolete backups found
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
validation failed for archived log
archive log filename=D:\ORACLE\FRA\NEW1\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_59_77
LWX5YZ_.ARC recid=1 stamp=762432510
validation succeeded for archived log
archive log filename=D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_60_77LWZRS
H_.ARC recid=2 stamp=762432592
validation succeeded for archived log
archive log filename=D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_61_77LX0VJ
Q_.ARC recid=3 stamp=762432627
validation succeeded for archived log
archive log filename=D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_22\O1_MF_1_62_77NFHZ2
7_.ARC recid=4 stamp=762482263
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00063_0762400640.001 reci
d=5 stamp=762486481
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00064_0762400640.001 reci
d=6 stamp=762571215
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00065_0762400640.001 reci
d=7 stamp=762582643
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00066_0762400640.001 reci
d=8 stamp=762735297
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00067_0762400640.001 reci
d=9 stamp=762735327
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00068_0762400640.001 reci
d=10 stamp=762747078
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00069_0762400640.001 reci
d=11 stamp=762747118
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00070_0762400640.001 reci
d=12 stamp=762777018
Crosschecked 12 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
no obsolete backups found
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
no obsolete backups found
RMAN>
RMAN> SHUTDOWN IMMEDIATE
database closed
database dismounted
Oracle instance shut down
RMAN> STARTUP MOUNT
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 209715200 bytes
Fixed Size 1295896 bytes
Variable Size 67111400 bytes
Database Buffers 134217728 bytes
Redo Buffers 7090176 bytes
RMAN> SHOW ALL;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 1 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DATABASE\SNCFNE
W1.ORA'; # default
RMAN> BACKUP DATABASE;
Starting backup at 25-SEP-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0GMNE6RK_1_1 tag=TAG20110925T1128
52 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 25-SEP-11
Starting Control File and SPFILE Autobackup at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-02 comment=
NONE
Finished Control File and SPFILE Autobackup at 25-SEP-11
MOUNT STAGE : DB SCN IS NOT CHANGING, HENCE NO NEED TO TAKE A NEW BACKUP BECAUSE WE HAVE DATAFILES WITH THE SAME SCNs.
RMAN> BACKUP DATABASE;
Starting backup at 25-SEP-11
using channel ORA_DISK_1
skipping datafile 1; already backed up 1 time(s)
skipping datafile 2; already backed up 1 time(s)
skipping datafile 3; already backed up 1 time(s)
Finished backup at 25-SEP-11
RMAN> BACKUP DATABASE;
Starting backup at 25-SEP-11
using channel ORA_DISK_1
skipping datafile 1; already backed up 1 time(s)
skipping datafile 2; already backed up 1 time(s)
skipping datafile 3; already backed up 1 time(s)
Finished backup at 25-SEP-11
RMAN>
OPEN MODE : DB SCN IS KEEP ON CHANGING HENCE THERE IS NEED TO PERFORM A FRESH BACKUP ALWAYS.
RMAN> ALTER DATABASE OPEN;
database opened
RMAN> BACKUP DATABASE;
Starting backup at 25-SEP-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0IMNE715_1_1 tag=TAG20110925T1131
49 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
Finished backup at 25-SEP-11
Starting Control File and SPFILE Autobackup at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-03 comment=
NONE
Finished Control File and SPFILE Autobackup at 25-SEP-11
RMAN>
RMAN> BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL;
Starting backup at 25-SEP-11
current log archived
using channel ORA_DISK_1
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_60_77
LWZRSH_.ARC; already backed up 1 time(s)
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_61_77
LX0VJQ_.ARC; already backed up 1 time(s)
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_22\O1_MF_1_62_77
NFHZ27_.ARC; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00063_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00064_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00065_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00066_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00067_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00068_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00069_0762400640.001
; already backed up 1 time(s)
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=70 recid=12 stamp=762777018
input archive log thread=1 sequence=71 recid=13 stamp=762781309
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0KMNE7JU_1_1 tag=TAG20110925T1141
49 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 25-SEP-11
Starting Control File and SPFILE Autobackup at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-04 comment=
NONE
Finished Control File and SPFILE Autobackup at 25-SEP-11
RMAN>
========================================================================================================================
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to 'x:\oracle\backups\%ORACLE_SID%\controlfiles\%F';
configure retention policy to redundancy 2;
run {
allocate channel ch1 type disk MAXPIECESIZE 1G;
crosscheck backup;
delete noprompt obsolete;
sql 'alter system switch logfile';
change archivelog all validate;
backup AS COMPRESSED BACKUPSET database
format 'x:\oracle\backups\%ORACLE_SID%\full\%d_%s_%U.DBF';
backup archivelog all
format 'x:\oracle\backups\%ORACLE_SID%\full\%d_%s_%U.ARC';
backup current controlfile
format 'x:\oracle\backups\%ORACLE_SID%\full\%d_%s_%U.CTL';
}
========================================================================================================================
TEST "RECOVERY WINDOW" ON PROD
AND BACKUP OPTIMIZATION
AND REPORT OBSOLETE
=======================================================================================================================
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 1 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DATABASE\SNCFNE
W1.ORA'; # default
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=148 devtype=DISK
no obsolete backups found
RMAN>
D:\>rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Sun Sep 25 02:10:38 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: NEW1 (DBID=1594352576)
RMAN> backup database plus archivelog;
Starting backup at 25-SEP-11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
skipping archive log file D:\ORACLE\FRA\NEW1\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_
59_77LWX5YZ_.ARC; already backed up 2 time(s)
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_60_77
LWZRSH_.ARC; already backed up 1 time(s)
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_61_77
LX0VJQ_.ARC; already backed up 1 time(s)
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=62 recid=4 stamp=762482263
input archive log thread=1 sequence=63 recid=5 stamp=762486481
input archive log thread=1 sequence=64 recid=6 stamp=762571215
input archive log thread=1 sequence=65 recid=7 stamp=762582643
input archive log thread=1 sequence=66 recid=8 stamp=762735297
input archive log thread=1 sequence=67 recid=9 stamp=762735327
input archive log thread=1 sequence=68 recid=10 stamp=762747078
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 tag=TAG20110925T0211
22 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 25-SEP-11
Starting backup at 25-SEP-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 tag=TAG20110925T0211
32 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 25-SEP-11
Starting backup at 25-SEP-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=69 recid=11 stamp=762747118
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 tag=TAG20110925T0211
58 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 25-SEP-11
Starting Control File and SPFILE Autobackup at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 comment=
NONE
Finished Control File and SPFILE Autobackup at 25-SEP-11
RMAN>
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
no obsolete backups found
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_01MN3IS6_1_1
.BKP recid=1 stamp=762432390
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_02MN3ISV_1_1
.BKP recid=2 stamp=762432417
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG
20110921T104830_77LWX806_.BKP recid=3 stamp=762432511
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T104956_77LWZXCT_.BKP recid=4 stamp=762432597
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNNDF_TAG20110
921T104958_77LWZZ36_.BKP recid=5 stamp=762432599
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCSNF_TAG20110
921T104958_77LX0T7G_.BKP recid=6 stamp=762432626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T105027_77LX0X5O_.BKP recid=7 stamp=762432629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCNNF_TAG20110
921T105122_77LX2MNN_.BKP recid=8 stamp=762432683
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNSNF_TAG20110
921T105122_77LX2OV9_.BKP recid=9 stamp=762432685
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 recid=10 stam
p=762747084
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 recid=11 stam
p=762747092
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 recid=12 stam
p=762747119
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 r
ecid=13 stamp=762747121
Crosschecked 13 objects
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
no obsolete backups found
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
new RMAN configuration parameters are successfully stored
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_01MN3IS6_1_1
.BKP recid=1 stamp=762432390
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_02MN3ISV_1_1
.BKP recid=2 stamp=762432417
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG
20110921T104830_77LWX806_.BKP recid=3 stamp=762432511
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T104956_77LWZXCT_.BKP recid=4 stamp=762432597
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNNDF_TAG20110
921T104958_77LWZZ36_.BKP recid=5 stamp=762432599
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCSNF_TAG20110
921T104958_77LX0T7G_.BKP recid=6 stamp=762432626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T105027_77LX0X5O_.BKP recid=7 stamp=762432629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCNNF_TAG20110
921T105122_77LX2MNN_.BKP recid=8 stamp=762432683
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNSNF_TAG20110
921T105122_77LX2OV9_.BKP recid=9 stamp=762432685
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 recid=10 stam
p=762747084
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 recid=11 stam
p=762747092
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 recid=12 stam
p=762747119
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 r
ecid=13 stamp=762747121
Crosschecked 13 objects
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_01MN3IS6_1_1
.BKP recid=1 stamp=762432390
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_02MN3ISV_1_1
.BKP recid=2 stamp=762432417
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG
20110921T104830_77LWX806_.BKP recid=3 stamp=762432511
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T104956_77LWZXCT_.BKP recid=4 stamp=762432597
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNNDF_TAG20110
921T104958_77LWZZ36_.BKP recid=5 stamp=762432599
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCSNF_TAG20110
921T104958_77LX0T7G_.BKP recid=6 stamp=762432626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T105027_77LX0X5O_.BKP recid=7 stamp=762432629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCNNF_TAG20110
921T105122_77LX2MNN_.BKP recid=8 stamp=762432683
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNSNF_TAG20110
921T105122_77LX2OV9_.BKP recid=9 stamp=762432685
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 recid=10 stam
p=762747084
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 recid=11 stam
p=762747092
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 recid=12 stam
p=762747119
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 r
ecid=13 stamp=762747121
Crosschecked 13 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 1 21-SEP-11
Backup Piece 1 21-SEP-11 D:\ORACLE\PRODUCT\10.2.0\DATABASE
\SAN-MIGR_NEW1_01MN3IS6_1_1.BKP
Backup Set 2 21-SEP-11
Backup Piece 2 21-SEP-11 D:\ORACLE\PRODUCT\10.2.0\DATABASE
\SAN-MIGR_NEW1_02MN3ISV_1_1.BKP
Archive Log 1 21-SEP-11 D:\ORACLE\FRA\NEW1\NEW1\ARCHIVELO
G\2011_09_21\O1_MF_1_59_77LWX5YZ_.ARC
Backup Set 3 21-SEP-11
Backup Piece 3 21-SEP-11 D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET
\2011_09_21\O1_MF_ANNNN_TAG20110921T104830_77LWX806_.BKP
Archive Log 2 21-SEP-11 D:\ORACLE\FRA\NEW1\ARCHIVELOG\201
1_09_21\O1_MF_1_60_77LWZRSH_.ARC
Backup Set 4 21-SEP-11
Backup Piece 4 21-SEP-11 D:\ORACLE\FRA\NEW1\BACKUPSET\2011
_09_21\O1_MF_ANNNN_TAG20110921T104956_77LWZXCT_.BKP
Backup Set 6 21-SEP-11
Backup Piece 6 21-SEP-11 D:\ORACLE\FRA\NEW1\BACKUPSET\2011
_09_21\O1_MF_NCSNF_TAG20110921T104958_77LX0T7G_.BKP
RMAN>
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 1 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DATABASE\SNCFNE
W1.ORA'; # default
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_01MN3IS6_1_1
.BKP recid=1 stamp=762432390
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\SAN-MIGR_NEW1_02MN3ISV_1_1
.BKP recid=2 stamp=762432417
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\FRA\NEW1\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG
20110921T104830_77LWX806_.BKP recid=3 stamp=762432511
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T104956_77LWZXCT_.BKP recid=4 stamp=762432597
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNNDF_TAG20110
921T104958_77LWZZ36_.BKP recid=5 stamp=762432599
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCSNF_TAG20110
921T104958_77LX0T7G_.BKP recid=6 stamp=762432626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_ANNNN_TAG20110
921T105027_77LX0X5O_.BKP recid=7 stamp=762432629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NCNNF_TAG20110
921T105122_77LX2MNN_.BKP recid=8 stamp=762432683
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\FRA\NEW1\BACKUPSET\2011_09_21\O1_MF_NNSNF_TAG20110
921T105122_77LX2OV9_.BKP recid=9 stamp=762432685
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0AMND66B_1_1 recid=10 stam
p=762747084
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0BMND66K_1_1 recid=11 stam
p=762747092
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0CMND67E_1_1 recid=12 stam
p=762747119
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-00 r
ecid=13 stamp=762747121
Crosschecked 13 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
no obsolete backups found
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
validation failed for archived log
archive log filename=D:\ORACLE\FRA\NEW1\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_59_77
LWX5YZ_.ARC recid=1 stamp=762432510
validation succeeded for archived log
archive log filename=D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_60_77LWZRS
H_.ARC recid=2 stamp=762432592
validation succeeded for archived log
archive log filename=D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_61_77LX0VJ
Q_.ARC recid=3 stamp=762432627
validation succeeded for archived log
archive log filename=D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_22\O1_MF_1_62_77NFHZ2
7_.ARC recid=4 stamp=762482263
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00063_0762400640.001 reci
d=5 stamp=762486481
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00064_0762400640.001 reci
d=6 stamp=762571215
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00065_0762400640.001 reci
d=7 stamp=762582643
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00066_0762400640.001 reci
d=8 stamp=762735297
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00067_0762400640.001 reci
d=9 stamp=762735327
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00068_0762400640.001 reci
d=10 stamp=762747078
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00069_0762400640.001 reci
d=11 stamp=762747118
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00070_0762400640.001 reci
d=12 stamp=762777018
Crosschecked 12 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
no obsolete backups found
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
no obsolete backups found
RMAN>
RMAN> SHUTDOWN IMMEDIATE
database closed
database dismounted
Oracle instance shut down
RMAN> STARTUP MOUNT
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 209715200 bytes
Fixed Size 1295896 bytes
Variable Size 67111400 bytes
Database Buffers 134217728 bytes
Redo Buffers 7090176 bytes
RMAN> SHOW ALL;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 1 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DATABASE\SNCFNE
W1.ORA'; # default
RMAN> BACKUP DATABASE;
Starting backup at 25-SEP-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0GMNE6RK_1_1 tag=TAG20110925T1128
52 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 25-SEP-11
Starting Control File and SPFILE Autobackup at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-02 comment=
NONE
Finished Control File and SPFILE Autobackup at 25-SEP-11
MOUNT STAGE : DB SCN IS NOT CHANGING, HENCE NO NEED TO TAKE A NEW BACKUP BECAUSE WE HAVE DATAFILES WITH THE SAME SCNs.
RMAN> BACKUP DATABASE;
Starting backup at 25-SEP-11
using channel ORA_DISK_1
skipping datafile 1; already backed up 1 time(s)
skipping datafile 2; already backed up 1 time(s)
skipping datafile 3; already backed up 1 time(s)
Finished backup at 25-SEP-11
RMAN> BACKUP DATABASE;
Starting backup at 25-SEP-11
using channel ORA_DISK_1
skipping datafile 1; already backed up 1 time(s)
skipping datafile 2; already backed up 1 time(s)
skipping datafile 3; already backed up 1 time(s)
Finished backup at 25-SEP-11
RMAN>
OPEN MODE : DB SCN IS KEEP ON CHANGING HENCE THERE IS NEED TO PERFORM A FRESH BACKUP ALWAYS.
RMAN> ALTER DATABASE OPEN;
database opened
RMAN> BACKUP DATABASE;
Starting backup at 25-SEP-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0IMNE715_1_1 tag=TAG20110925T1131
49 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
Finished backup at 25-SEP-11
Starting Control File and SPFILE Autobackup at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-03 comment=
NONE
Finished Control File and SPFILE Autobackup at 25-SEP-11
RMAN>
RMAN> BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL;
Starting backup at 25-SEP-11
current log archived
using channel ORA_DISK_1
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_60_77
LWZRSH_.ARC; already backed up 1 time(s)
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_21\O1_MF_1_61_77
LX0VJQ_.ARC; already backed up 1 time(s)
skipping archive log file D:\ORACLE\FRA\NEW1\ARCHIVELOG\2011_09_22\O1_MF_1_62_77
NFHZ27_.ARC; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00063_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00064_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00065_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00066_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00067_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00068_0762400640.001
; already backed up 1 time(s)
skipping archive log file D:\ORACLE\PRODUCT\10.2.0\RDBMS\ARC00069_0762400640.001
; already backed up 1 time(s)
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=70 recid=12 stamp=762777018
input archive log thread=1 sequence=71 recid=13 stamp=762781309
channel ORA_DISK_1: starting piece 1 at 25-SEP-11
channel ORA_DISK_1: finished piece 1 at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\0KMNE7JU_1_1 tag=TAG20110925T1141
49 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 25-SEP-11
Starting Control File and SPFILE Autobackup at 25-SEP-11
piece handle=D:\ORACLE\PRODUCT\10.2.0\DATABASE\C-1594352576-20110925-04 comment=
NONE
Finished Control File and SPFILE Autobackup at 25-SEP-11
RMAN>
========================================================================================================================
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to 'x:\oracle\backups\%ORACLE_SID%\controlfiles\%F';
configure retention policy to redundancy 2;
run {
allocate channel ch1 type disk MAXPIECESIZE 1G;
crosscheck backup;
delete noprompt obsolete;
sql 'alter system switch logfile';
change archivelog all validate;
backup AS COMPRESSED BACKUPSET database
format 'x:\oracle\backups\%ORACLE_SID%\full\%d_%s_%U.DBF';
backup archivelog all
format 'x:\oracle\backups\%ORACLE_SID%\full\%d_%s_%U.ARC';
backup current controlfile
format 'x:\oracle\backups\%ORACLE_SID%\full\%d_%s_%U.CTL';
}
========================================================================================================================
TEST "RECOVERY WINDOW" ON PROD
AND BACKUP OPTIMIZATION
AND REPORT OBSOLETE
=======================================================================================================================
