RMAN : Retention Policy of recovery window and backup optimization on experiments

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 test recovery

catalog start with '......' noprompt;

RMAN> recover datafile 3 test;

Starting recover at 22-JUN-2011 10:50:56
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=158 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=132 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=131 devtype=DISK

starting media recovery
RMAN-11006: WARNING: test recovery results:
ORA-10574: Test recovery did not corrupt any data block
ORA-10573: Test recovery tested redo from change 1153602 to 1153605
ORA-10572: Test recovery canceled due to errors
ORA-10585: Test recovery can not apply redo that may modify control file

media recovery complete, elapsed time: 00:00:01

Finished recover at 22-JUN-2011 10:51:04

RMAN> recover datafile 3;

Starting recover at 22-JUN-2011 10:51:46
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

starting media recovery
media recovery complete, elapsed time: 00:00:02

Finished recover at 22-JUN-2011 10:51:49

RMAN> sql 'alter database datafile 3 online';

sql statement: alter database datafile 3 online

RMAN> exit


Recovery Manager complete.

F:\export>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 22 10:52:15 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from v$recover_file;

no rows selected

Alert Log Messages
==================
Wed Jun 22 10:51:03 2011
alter database recover if needed
 datafile 3 test

Test Media Recovery Start
 ALLOW CORRUPTION option must use serial recovery
Wed Jun 22 10:51:03 2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 321 Reading mem 0
  Mem# 0 errs 0: F:\ORACLE\ORADATA\NEW1\REDO3.LOG
Test recovery cannot apply redo (17.3) that may modify controlfile
Wed Jun 22 10:51:04 2011
Test recovery canceled due to errors
Test recovery tested redo from change 1153602 to 1153605
Test recovery found no problems
ORA-10574 signalled during: alter database recover if needed
 datafile 3 test
...
Wed Jun 22 10:51:47 2011
alter database recover datafile list clear
Wed Jun 22 10:51:47 2011
Completed: alter database recover datafile list clear
Wed Jun 22 10:51:47 2011
alter database recover if needed
 datafile 3

Media Recovery Start

How to fix expdp errors ORA-39095 and ORA-01466 ?

Below errors are fixed to make a correct expdp code :

ORA-39095: Dump file space has been exhausted
Sol: By increasing the filesize

ORA-01466: unable to read data - table definition has changed
Sol: Don't mention flashback_time parameter in export.
     OR
     At OS level, command prompt, do below before export :
     F:\export>set nls_date_format=DD-MM-YY HH24:MI:SS

F:\export>set nls_date_format=DD-MM-YY HH24:MI:SS

F:\export>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 21 02:30:15 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> conn u1/u1
Connected.
SQL> select max(LAST_DDL_TIME) from tab2;

MAX(LAST_DDL_TIME
-----------------
21-06-11 01:21:12

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

F:\export>del *.dmp

F:\export>expdp u1/u1@new1 parfile=exp.par

Export: Release 10.2.0.1.0 - Production on Tuesday, 21 June, 2011 2:30:55

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "U1"."SYS_EXPORT_SCHEMA_04":  u1/********@new1 parfile=exp.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 2.937 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
. . exported "U1"."TAB2"                                 835.5 KB    9518 rows
. . exported "U1"."SYS_EXPORT_SCHEMA_03"                 214.8 KB    1091 rows
. . exported "U1"."SYS_EXPORT_SCHEMA_02"                 172.7 KB    1092 rows
. . exported "U1"."SYS_EXPORT_SCHEMA_01"                 127.3 KB    1059 rows
. . exported "U1"."TAB1"                                 9.039 KB       8 rows
Master table "U1"."SYS_EXPORT_SCHEMA_04" successfully loaded/unloaded
******************************************************************************
Dump file set for U1.SYS_EXPORT_SCHEMA_04 is:
  F:\EXPORT\U101.DMP
  F:\EXPORT\U102.DMP
  F:\EXPORT\U103.DMP
  F:\EXPORT\U104.DMP
Job "U1"."SYS_EXPORT_SCHEMA_04" successfully completed at 02:31:09


F:\export>del *.dmp

F:\export>type exp.par
#     On CMD
#       ======
# Check where your datapump directory is pointing, check dba_directories.

directory=datapump schemas=u1 FLASHBACK_TIME="TO_TIMESTAMP(SYSDATE, 'DD-MM-YYYY HH24:MI:SS')" dumpfile=u1%U.dmp logfile=u1.log filesize=500k

# Run this as expdp system/manager@new1 parfile=exp.par
F:\export>echo %nls_date_format%
DD-MM-YY HH24:MI:SS

F:\export>

How to set nls_date_format for SQLPLUS,RMAN and DATAPUMP etc tools

C:\Windows\System32>set nls_date_format=DD-MON-YYYY hh24:mi:ss

RMAN> RUN
2> {
3>   SET UNTIL TIME "to_date('14-05-2011 00:00:00','dd-mm-yyyy hh24:mi:ss')";
4>   RESTORE DATABASE;
5>   RECOVER DATABASE;
6> }

How to recreate damaged Sysaux tablespace to make export/import work

SQL> select distinct owner "user" from dba_tables where tablespace_name='SYSAUX';

user
------------------------------
MDSYS
DMSYS
TSMSYS
CTXSYS
OLAPSYS
SYSTEM
EXFSYS
DBSNMP
ORDSYS
SYSMAN
XDB

user
------------------------------
SYS
WMSYS

13 rows selected.

SQL> drop user mdsys cascade;

User dropped.

SQL> drop user dmsys cascade;

User dropped.

SQL> drop user tsmsys cascade;

User dropped.

SQL> drop user ctxsys cascade;

User dropped.

SQL> drop user olapsys cascade;

User dropped.

SQL> drop user exfsys cascade;

User dropped.

SQL> drop user dbsnmp cascade;

User dropped.

SQL> drop user ordsys cascade;

User dropped.

SQL> drop user sysman cascade;

User dropped.

SQL> drop user xdb cascade;

User dropped.

SQL> select distinct owner "user" from dba_tables where tablespace_name='SYSAUX';

user
------------------------------
SYSTEM
SYS
WMSYS

SQL> drop user wmsys cascade;

User dropped.

SQL> drop tablespace sysaux;
drop tablespace sysaux
*
ERROR at line 1:
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option


SQL> drop tablespace sysaux INCLUDING CONTENTS;
drop tablespace sysaux INCLUDING CONTENTS
*
ERROR at line 1:
ORA-25183: index-organized table top index segment is in a different tablespace



SQL> drop tablespace sysaux INCLUDING CONTENTS;
drop tablespace sysaux INCLUDING CONTENTS
*
ERROR at line 1:
ORA-25183: index-organized table top index segment is in a different tablespace

SQL> select distinct IOT_TYPE from dba_tables;

IOT_TYPE
------------

IOT_OVERFLOW
IOT

select 'drop '||owner||'.'||table_name||';' from dba_tables where tablespace_name='SYSAUX';

SQL> select 'drop table '||owner||'.'||table_name||' cascade constraints;' from dba_tables where tablespace_name='SYSAUX';

Table dropped.

drop table SYS.SYS_IOT_OVER_9692 cascade constraints
               *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table


drop table SYS.SYS$SERVICE_METRICS_TAB cascade constraints
               *
ERROR at line 1:
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables


drop table SYS.AQ$_SYS$SERVICE_METRICS_TAB_S cascade constraints
               *
ERROR at line 1:
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables


drop table SYS.SYS_IOT_OVER_10165 cascade constraints
               *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table



Table dropped.

set long 999999
set linesize 150
select dbms_metadata.get_ddl('TABLE', table_name, owner) from dba_tables where iot_type like '%IOT%';

select 'drop table '||owner||'.'||table_name||' cascade constraints;' from dba_tables where iot_type like '%IOT%'and tablespace_name='SYSAUX';
         6
SQL> select 'drop table '||owner||'.'||table_name||' cascade constraints;' from dba_tables where iot_type like '%IOT%'and tablespace_name='SYSAUX';
drop table SYS.SYS_IOT_OVER_4478 cascade constraints;
drop table SYS.SYS_IOT_OVER_4484 cascade constraints;
drop table SYS.SYS_IOT_OVER_4488 cascade constraints;
drop table SYS.SYS_IOT_OVER_8799 cascade constraints;
drop table SYS.SYS_IOT_OVER_9692 cascade constraints;
drop table SYS.SYS_IOT_OVER_10165 cascade constraints;

6 rows selected.

SQL> drop table SYS.SYS_IOT_OVER_4478 cascade constraints;
drop table SYS.SYS_IOT_OVER_4478 cascade constraints
               *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table


SQL> drop table SYS.SYS_IOT_OVER_4484 cascade constraints;
drop table SYS.SYS_IOT_OVER_4484 cascade constraints
               *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table


SQL> drop table SYS.SYS_IOT_OVER_4488 cascade constraints;
drop table SYS.SYS_IOT_OVER_4488 cascade constraints
               *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table


SQL> drop table SYS.SYS_IOT_OVER_8799 cascade constraints;
drop table SYS.SYS_IOT_OVER_8799 cascade constraints
               *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table


SQL> drop table SYS.SYS_IOT_OVER_9692 cascade constraints;
drop table SYS.SYS_IOT_OVER_9692 cascade constraints
               *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table


SQL> drop table SYS.SYS_IOT_OVER_10165 cascade constraints;
drop table SYS.SYS_IOT_OVER_10165 cascade constraints
               *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table

select 'drop table '||owner||'.'||table_name||' PURGE;' from dba_tables where iot_type like '%IOT%';

SQL> drop tablespace sysaux including contents and datafiles cascade constraints;
drop tablespace sysaux including contents and datafiles cascade constraints
*
ERROR at line 1:
ORA-24008: queue table SYS.ALERT_QT must be dropped first

SQL> startup migrate
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1248600 bytes
Variable Size              71303848 bytes
Database Buffers          213909504 bytes
Redo Buffers                7139328 bytes
Database mounted.
Database opened.
SQL> drop tablespace sysaux including contents and datafiles cascade constraints;
drop tablespace sysaux including contents and datafiles cascade constraints
*
ERROR at line 1:
ORA-24008: queue table SYS.ALERT_QT must be dropped first


SQL> drop table SYS.ALERT_QT;
drop table SYS.ALERT_QT
               *
ERROR at line 1:
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables


SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE('SYS.ALERT_QT');
BEGIN DBMS_AQADM.DROP_QUEUE_TABLE('SYS.ALERT_QT'); END;

*
ERROR at line 1:
ORA-24012: cannot drop QUEUE_TABLE, some queues in SYS.ALERT_QT have not been
dropped
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4084
ORA-06512: at "SYS.DBMS_AQADM", line 197
ORA-06512: at line 1


SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE('SYS.ALERT_QT') immediate;
BEGIN DBMS_AQADM.DROP_QUEUE_TABLE('SYS.ALERT_QT') immediate; END;

                                                  *
ERROR at line 1:
ORA-06550: line 1, column 51:
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the
following:
:= . ( % ;
The symbol ":=" was substituted for "IMMEDIATE" to continue.


SQL> exec dbms_aqadm.drop_queue_table(queue_table=>'SYS.ALERT_QT',force =>true);
BEGIN dbms_aqadm.drop_queue_table(queue_table=>'SYS.ALERT_QT',force =>true); END;

*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4084
ORA-06512: at "SYS.DBMS_AQADM", line 197
ORA-06512: at line 1





select object_name,object_type from dba_objects where owner='SYS' and object_name like '%AQ%';


IF EXISTS(SELECT NULL
            FROM SYS.ALERT_QT) THEN
  DROP TABLE SYS.ALERT_QT;
END IF;



begin
    for r in ( select table_name from user_tables )
    loop
        execute immediate 'drop table '||r.table_name
                    ||' cascade constraints';
    end loop;
end;

Note 203225.1 - How to Manually Cleanup Advanced Queuing Tables
Note 236898.1 - Procedures to Remove Orphan AQ Objects which Fail to Drop via



     DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'<QUEUE_TABLE>',force => TRUE);
exec dbms_aqadm.drop_queue_table(queue_table=>'SYS.ALERT_QT',force =>true);

SELECT object_name, object_type FROM user_objects WHERE object_name like '%ALERT_QT%';


OBJECT_NAME                    OBJECT_TYPE
------------------------------ -------------------
ALERT_QT                       TABLE
AQ$ALERT_QT                    VIEW
AQ$ALERT_QT_R                  VIEW
AQ$ALERT_QT_S                  VIEW
AQ$_ALERT_QT_E                 QUEUE
AQ$_ALERT_QT_F                 VIEW
AQ$_ALERT_QT_G                 TABLE
AQ$_ALERT_QT_H                 TABLE
AQ$_ALERT_QT_I                 TABLE
AQ$_ALERT_QT_N                 SEQUENCE
AQ$_ALERT_QT_S                 TABLE
AQ$_ALERT_QT_T                 TABLE
AQ$_ALERT_QT_V                 EVALUATION CONTEXT

13 rows selected.

SQL> SELECT 'drop '||object_type||' '||object_name||' cascade constraints;' FROM user_objects WHERE object_name like '%ALERT_QT%';

'DROP'||OBJECT_TYPE||''||OBJECT_NAME||'CASCADECONSTRAINTS;'
--------------------------------------------------------------------------------
drop TABLE ALERT_QT cascade constraints;
drop VIEW AQ$ALERT_QT cascade constraints;
drop VIEW AQ$ALERT_QT_R cascade constraints;
drop VIEW AQ$ALERT_QT_S cascade constraints;
drop QUEUE AQ$_ALERT_QT_E cascade constraints;
drop VIEW AQ$_ALERT_QT_F cascade constraints;
drop TABLE AQ$_ALERT_QT_G cascade constraints;
drop TABLE AQ$_ALERT_QT_H cascade constraints;
drop TABLE AQ$_ALERT_QT_I cascade constraints;
drop SEQUENCE AQ$_ALERT_QT_N cascade constraints;
drop TABLE AQ$_ALERT_QT_S cascade constraints;
drop TABLE AQ$_ALERT_QT_T cascade constraints;
drop EVALUATION CONTEXT AQ$_ALERT_QT_V cascade constraints;

13 rows selected.

SQL> SELECT 'drop '||object_type||' '||object_name||' cascade constraints;' FROM user_objects WHERE object_name like '%ALERT_QT%';

'DROP'||OBJECT_TYPE||''||OBJECT_NAME||'CASCADECONSTRAINTS;'
--------------------------------------------------------------------------------
drop TABLE ALERT_QT cascade constraints;
drop VIEW AQ$ALERT_QT cascade constraints;
drop VIEW AQ$ALERT_QT_R cascade constraints;
drop VIEW AQ$ALERT_QT_S cascade constraints;
drop QUEUE AQ$_ALERT_QT_E cascade constraints;
drop VIEW AQ$_ALERT_QT_F cascade constraints;
drop TABLE AQ$_ALERT_QT_G cascade constraints;
drop TABLE AQ$_ALERT_QT_H cascade constraints;
drop TABLE AQ$_ALERT_QT_I cascade constraints;
drop SEQUENCE AQ$_ALERT_QT_N cascade constraints;
drop TABLE AQ$_ALERT_QT_S cascade constraints;
drop TABLE AQ$_ALERT_QT_T cascade constraints;
drop EVALUATION CONTEXT AQ$_ALERT_QT_V cascade constraints;

13 rows selected.

SQL> drop VIEW AQ$ALERT_QT cascade constraints;

View dropped.

SQL> drop VIEW AQ$ALERT_QT_R cascade constraints;

View dropped.

SQL> drop VIEW AQ$ALERT_QT_S cascade constraints;

View dropped.

SQL> drop QUEUE AQ$_ALERT_QT_E cascade constraints;
drop QUEUE AQ$_ALERT_QT_E cascade constraints
     *
ERROR at line 1:
ORA-00950: invalid DROP option


SQL> drop VIEW AQ$_ALERT_QT_F cascade constraints;

View dropped.

SQL> drop TABLE AQ$_ALERT_QT_G cascade constraints;

Table dropped.

SQL> drop TABLE AQ$_ALERT_QT_H cascade constraints;

Table dropped.

SQL> drop TABLE AQ$_ALERT_QT_I cascade constraints;

Table dropped.

SQL> drop SEQUENCE AQ$_ALERT_QT_N cascade constraints;
drop SEQUENCE AQ$_ALERT_QT_N cascade constraints
                             *
ERROR at line 1:
ORA-00933: SQL command not properly ended


SQL> drop TABLE AQ$_ALERT_QT_S cascade constraints;

Table dropped.

SQL> drop TABLE AQ$_ALERT_QT_T cascade constraints;

Table dropped.

SQL> drop EVALUATION CONTEXT AQ$_ALERT_QT_V cascade constraints;
drop EVALUATION CONTEXT AQ$_ALERT_QT_V cascade constraints
     *
ERROR at line 1:
ORA-00950: invalid DROP option


SQL> drop TABLE ALERT_QT cascade constraints;

Table dropped.

SQL> drop tablespace sysaux including contents and datafiles cascade constraints;

Tablespace dropped.

SQL>

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1248600 bytes
Variable Size              71303848 bytes
Database Buffers          213909504 bytes
Redo Buffers                7139328 bytes
Database mounted.
Database opened.
SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP
USERS
EXAMPLE
SWAMY
PERFSTAT

7 rows selected.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> select tablespace_name,file_name from dba_data_files;

TABLESPACE_NAME
------------------------------
FILE_NAME
------------------------------------------------------------------------
USERS
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF

UNDOTBS1
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF

SYSTEM
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF

EXAMPLE
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF

SWAMY
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SWAMI01.DBF

PERFSTAT
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\PERF01.DBF


6 rows selected.

CREATE TABLESPACE sysaux
DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF' SIZE 300m
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

SQL> startup
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1248600 bytes
Variable Size              71303848 bytes
Database Buffers          213909504 bytes
Redo Buffers                7139328 bytes
Database mounted.
Database opened.
SQL> select tablespace_name,file_name from dba_data_files;

TABLESPACE_NAME
------------------------------
FILE_NAME
--------------------------------------------------------------------------------
USERS
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF

UNDOTBS1
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF

SYSTEM
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF

EXAMPLE
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF

SWAMY
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SWAMI01.DBF

PERFSTAT
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\PERF01.DBF


6 rows selected.

SQL> CREATE TABLESPACE sysaux
  2  DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF' SIZE 300m
  3  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

Tablespace created.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

F:\>exp system/manager file=s111.dmp owner=scott

Export: Release 10.2.0.1.0 - Production on Sat May 21 20:34:24 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.LT_EXPORT_PKG"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at "SYS.DBMS_FILE_GROUP_EXP", line 634
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_FILE_GROUP_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                          BONUS          0 rows exported
. . exporting table                           DEPT          4 rows exported
. . exporting table                            EMP         14 rows exported
. . exporting table                        EMP_BKP         14 rows exported
. . exporting table                        EMP_ORG         14 rows exported
. . exporting table                       SALGRADE          5 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.LT_EXPORT_PKG"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at "SYS.DBMS_FILE_GROUP_EXP", line 634
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_FILE_GROUP_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.

@%ORACLE_HOME%\rdbms\admin\catexp.sql
login as SYS
run catmetx.sql then
run utlrp.sql

EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.LT_EXPORT_PKG"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at "SYS.DBMS_FILE_GROUP_EXP", line 634
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_FILE_GROUP_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                          BONUS          0 rows exported
. . exporting table                           DEPT          4 rows exported
. . exporting table                            EMP         14 rows exported
. . exporting table                        EMP_BKP         14 rows exported
. . exporting table                        EMP_ORG         14 rows exported
. . exporting table                       SALGRADE          5 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.LT_EXPORT_PKG"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at "SYS.DBMS_FILE_GROUP_EXP", line 634
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_FILE_GROUP_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.

F:\export>

@%ORACLE_HOME%\rdbms\admin\catalog.sql
@%ORACLE_HOME%\rdbms\admin\catproc.sql
conn system/manager
@%ORACLE_HOME%\sqlplus\admin\pupbld.sql


BEGIN
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_STATS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_REGISTRY", line 560
ORA-06512: at "SYS.DBMS_REGISTRY", line 612
ORA-06512: at line 4


Connected.
SP2-0310: unable to open file "C:\oracle\product\10.2.0\db_1\rdbms\admin\pupbld.sql"
SQL>

EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.LT_EXPORT_PKG"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at "SYS.DBMS_FILE_GROUP_EXP", line 634
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_FILE_GROUP_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.

Next Plan
=========
Need to startup Upgrade and then upgrade the database by catupgrd.sql
then
cat102s.sql
then
utlrp.sql

Function created.

No errors.
SELECT version_script AS file_name FROM DUAL
       *
ERROR at line 1:
ORA-20000: Upgrade re-run not supported from version
ORA-06512: at "SYS.VERSION_SCRIPT", line 45


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

F:\export>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 21 22:21:44 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1248600 bytes
Variable Size             113246888 bytes
Database Buffers          171966464 bytes
Redo Buffers                7139328 bytes
Database mounted.
Database opened.
SQL>

RMAN incremental backups

Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Windows\System32>set ORACLE_SID=NEW1

C:\Windows\System32>set PATH=%ORACLE_HOME%\BIN;%PATH%

C:\Windows\System32>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 16 23:58:05 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1248600 bytes
Variable Size              96469672 bytes
Database Buffers          188743680 bytes
Redo Buffers                7139328 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

C:\Windows\System32>rman target sys/sys@new1 catalog rman/rman@rman01

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jun 16 23:59:20 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: NEW1 (DBID=1583816731)
connected to recovery catalog database

RMAN>


RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
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 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
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 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";

new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
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 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
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 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE = 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";

starting full resync of recovery catalog
full resync complete
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE = 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";

old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
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 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
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 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default


RMAN>

SQL> alter database enable block change tracking using file 'F:\oracle\admin\NEW1\pfile\bct.i';

Database altered.


RMAN> backup as compressed backupset incremental level 0 database;

Starting backup at 17-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=F:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_3: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_216.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_2: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_217.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:41
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_215.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:41
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_218.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-11

RMAN> backup as compressed backupset incremental level 1 cumulative database;

Starting backup at 17-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=F:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_3: starting piece 1 at 17-JUN-11
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_219.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_220.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_3: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_221.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_222.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-11

RMAN> backup as compressed backupset incremental level 1 database;

Starting backup at 17-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=F:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_3: starting piece 1 at 17-JUN-11
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_223.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_224.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_3: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_225.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_226.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-11

RMAN Configurations 1

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 2 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT   "F:\oracle\tmp\%d_%s.dbf";
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 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default

How to take RMAN backups to some other location (Not in FRA)

Below is the method I use :

RMAN> run{
2> delete noprompt backup;
3> backup as compressed backupset database format 'F:\oracle\oradata\LSTDBY\bkp\full_bkp_%U';
4> backup as compressed backupset archivelog all format 'F:\oracle\oradata\LSTDBY\bkp\%d_%s_%p_%U.arc' delete all input;
5> backup as copy current controlfile format 'F:\oracle\oradata\LSTDBY\bkp\control.bkp';
6> }

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
29      29      1   1   AVAILABLE   DISK        F:\ORACLE\ORADATA\LSTDBY\BKP\NEW1_98_1_32MDP7JA_1_1.ARC
deleted backup piece
backup piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\NEW1_98_1_32MDP7JA_1_1.ARC recid=29 stamp=752655980
Deleted 1 objects


Starting backup at 01-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\STDBY1\SYSTEM.DBF
input datafile fno=00003 name=F:\ORACLE\ORADATA\STDBY1\SYSAUX.DBF
input datafile fno=00002 name=F:\ORACLE\ORADATA\STDBY1\UNDO.DBF
channel ORA_DISK_1: starting piece 1 at 01-JUN-11
channel ORA_DISK_1: finished piece 1 at 01-JUN-11
piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\FULL_BKP_33MDP7L0_1_1 tag=TAG20110601T070711 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 01-JUN-11
channel ORA_DISK_1: finished piece 1 at 01-JUN-11
piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\FULL_BKP_34MDP7MD_1_1 tag=TAG20110601T070711 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 01-JUN-11

Starting backup at 01-JUN-11
using channel ORA_DISK_1
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=93 recid=1 stamp=752203699
input archive log thread=1 sequence=94 recid=4 stamp=752203700
input archive log thread=1 sequence=95 recid=5 stamp=752203700
input archive log thread=1 sequence=96 recid=2 stamp=752203699
input archive log thread=1 sequence=97 recid=3 stamp=752203700
input archive log thread=1 sequence=98 recid=6 stamp=752203704
input archive log thread=1 sequence=99 recid=8 stamp=752203705
input archive log thread=1 sequence=100 recid=7 stamp=752203705
input archive log thread=1 sequence=101 recid=14 stamp=752203760
input archive log thread=1 sequence=102 recid=10 stamp=752203759
input archive log thread=1 sequence=103 recid=13 stamp=752203760
input archive log thread=1 sequence=104 recid=12 stamp=752203760
input archive log thread=1 sequence=105 recid=11 stamp=752203759
input archive log thread=1 sequence=106 recid=9 stamp=752203706
input archive log thread=1 sequence=107 recid=15 stamp=752203829
input archive log thread=1 sequence=108 recid=16 stamp=752206375
input archive log thread=1 sequence=109 recid=17 stamp=752206379
input archive log thread=1 sequence=110 recid=18 stamp=752208664
input archive log thread=1 sequence=111 recid=19 stamp=752231644
input archive log thread=1 sequence=112 recid=20 stamp=752241984
input archive log thread=1 sequence=113 recid=21 stamp=752241988
input archive log thread=1 sequence=114 recid=22 stamp=752284429
input archive log thread=1 sequence=115 recid=23 stamp=752284430
input archive log thread=1 sequence=116 recid=24 stamp=752284437
input archive log thread=1 sequence=117 recid=25 stamp=752306407
input archive log thread=1 sequence=118 recid=26 stamp=752320462
input archive log thread=1 sequence=119 recid=27 stamp=752320469
input archive log thread=1 sequence=120 recid=28 stamp=752348736
input archive log thread=1 sequence=121 recid=29 stamp=752360623
input archive log thread=1 sequence=122 recid=30 stamp=752629379
input archive log thread=1 sequence=123 recid=31 stamp=752629381
input archive log thread=1 sequence=124 recid=32 stamp=752629382
input archive log thread=1 sequence=125 recid=33 stamp=752632827
input archive log thread=1 sequence=126 recid=34 stamp=752632833
input archive log thread=1 sequence=127 recid=35 stamp=752633148
input archive log thread=1 sequence=128 recid=36 stamp=752633378
input archive log thread=1 sequence=129 recid=38 stamp=752636349
input archive log thread=1 sequence=130 recid=37 stamp=752636348
input archive log thread=1 sequence=131 recid=39 stamp=752636349
input archive log thread=1 sequence=132 recid=40 stamp=752636411
input archive log thread=1 sequence=133 recid=42 stamp=752654062
input archive log thread=1 sequence=134 recid=41 stamp=752654061
input archive log thread=1 sequence=135 recid=43 stamp=752654112
channel ORA_DISK_1: starting piece 1 at 01-JUN-11
channel ORA_DISK_1: finished piece 1 at 01-JUN-11
piece handle=F:\ORACLE\ORADATA\LSTDBY\BKP\NEW1_101_1_35MDP7MI_1_1.ARC tag=TAG20110601T070801 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:09
channel ORA_DISK_1: deleting archive log(s)
archive log filename=F:\ORACLE\ARCH\STDBY1\1_93_751864795.ARC recid=1 stamp=752203699
archive log filename=F:\ORACLE\ARCH\STDBY1\1_94_751864795.ARC recid=4 stamp=752203700
archive log filename=F:\ORACLE\ARCH\STDBY1\1_95_751864795.ARC recid=5 stamp=752203700
archive log filename=F:\ORACLE\ARCH\STDBY1\1_96_751864795.ARC recid=2 stamp=752203699
archive log filename=F:\ORACLE\ARCH\STDBY1\1_97_751864795.ARC recid=3 stamp=752203700
archive log filename=F:\ORACLE\ARCH\STDBY1\1_98_751864795.ARC recid=6 stamp=752203704
archive log filename=F:\ORACLE\ARCH\STDBY1\1_99_751864795.ARC recid=8 stamp=752203705
archive log filename=F:\ORACLE\ARCH\STDBY1\1_100_751864795.ARC recid=7 stamp=752203705
archive log filename=F:\ORACLE\ARCH\STDBY1\1_101_751864795.ARC recid=14 stamp=752203760
archive log filename=F:\ORACLE\ARCH\STDBY1\1_102_751864795.ARC recid=10 stamp=752203759
archive log filename=F:\ORACLE\ARCH\STDBY1\1_103_751864795.ARC recid=13 stamp=752203760
archive log filename=F:\ORACLE\ARCH\STDBY1\1_104_751864795.ARC recid=12 stamp=752203760
archive log filename=F:\ORACLE\ARCH\STDBY1\1_105_751864795.ARC recid=11 stamp=752203759
archive log filename=F:\ORACLE\ARCH\STDBY1\1_106_751864795.ARC recid=9 stamp=752203706
archive log filename=F:\ORACLE\ARCH\STDBY1\1_107_751864795.ARC recid=15 stamp=752203829
archive log filename=F:\ORACLE\ARCH\STDBY1\1_108_751864795.ARC recid=16 stamp=752206375
archive log filename=F:\ORACLE\ARCH\STDBY1\1_109_751864795.ARC recid=17 stamp=752206379
archive log filename=F:\ORACLE\ARCH\STDBY1\1_110_751864795.ARC recid=18 stamp=752208664
archive log filename=F:\ORACLE\ARCH\STDBY1\1_111_751864795.ARC recid=19 stamp=752231644
archive log filename=F:\ORACLE\ARCH\STDBY1\1_112_751864795.ARC recid=20 stamp=752241984
archive log filename=F:\ORACLE\ARCH\STDBY1\1_113_751864795.ARC recid=21 stamp=752241988
archive log filename=F:\ORACLE\ARCH\STDBY1\1_114_751864795.ARC recid=22 stamp=752284429
archive log filename=F:\ORACLE\ARCH\STDBY1\1_115_751864795.ARC recid=23 stamp=752284430
archive log filename=F:\ORACLE\ARCH\STDBY1\1_116_751864795.ARC recid=24 stamp=752284437
archive log filename=F:\ORACLE\ARCH\STDBY1\1_117_751864795.ARC recid=25 stamp=752306407
archive log filename=F:\ORACLE\ARCH\STDBY1\1_118_751864795.ARC recid=26 stamp=752320462
archive log filename=F:\ORACLE\ARCH\STDBY1\1_119_751864795.ARC recid=27 stamp=752320469
archive log filename=F:\ORACLE\ARCH\STDBY1\1_120_751864795.ARC recid=28 stamp=752348736
archive log filename=F:\ORACLE\ARCH\STDBY1\1_121_751864795.ARC recid=29 stamp=752360623
archive log filename=F:\ORACLE\ARCH\STDBY1\1_122_751864795.ARC recid=30 stamp=752629379
archive log filename=F:\ORACLE\ARCH\STDBY1\1_123_751864795.ARC recid=31 stamp=752629381
archive log filename=F:\ORACLE\ARCH\STDBY1\1_124_751864795.ARC recid=32 stamp=752629382
archive log filename=F:\ORACLE\ARCH\STDBY1\1_125_751864795.ARC recid=33 stamp=752632827
archive log filename=F:\ORACLE\ARCH\STDBY1\1_126_751864795.ARC recid=34 stamp=752632833
archive log filename=F:\ORACLE\ARCH\STDBY1\1_127_751864795.ARC recid=35 stamp=752633148
archive log filename=F:\ORACLE\ARCH\STDBY1\1_128_751864795.ARC recid=36 stamp=752633378
archive log filename=F:\ORACLE\ARCH\STDBY1\1_129_751864795.ARC recid=38 stamp=752636349
archive log filename=F:\ORACLE\ARCH\STDBY1\1_130_751864795.ARC recid=37 stamp=752636348
archive log filename=F:\ORACLE\ARCH\STDBY1\1_131_751864795.ARC recid=39 stamp=752636349
archive log filename=F:\ORACLE\ARCH\STDBY1\1_132_751864795.ARC recid=40 stamp=752636411
archive log filename=F:\ORACLE\ARCH\STDBY1\1_133_751864795.ARC recid=42 stamp=752654062
archive log filename=F:\ORACLE\ARCH\STDBY1\1_134_751864795.ARC recid=41 stamp=752654061
archive log filename=F:\ORACLE\ARCH\STDBY1\1_135_751864795.ARC recid=43 stamp=752654112
Finished backup at 01-JUN-11

Starting backup at 01-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=F:\ORACLE\ORADATA\LSTDBY\BKP\CONTROL.BKP tag=TAG20110601T070814 recid=24 stamp=752656096
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 01-JUN-11

RMAN>