RMAN for OEM92 backup
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN>
connected to target database: OEM92 (DBID=4042519487)
using target database controlfile instead of recovery catalog
RMAN>
RMAN> run {
2> allocate channel Channel1 type disk format 'C:\ORACLE\ORADATA\OEM92\BACKUP\b_%u_%p_%c';
3> backup ( database include current controlfile );
4> backup ( archivelog all
5> delete input );
6>
7> }
allocated channel: Channel1
channel Channel1: sid=28 devtype=DISK
Starting backup at AUG 01 2003 09:52:05
channel Channel1: starting full datafile backupset
channel Channel1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=C:\ORACLE\ORADATA\OEM92\SYSTEM01.DBF
input datafile fno=00002 name=C:\ORACLE\ORADATA\OEM92\UNDOTBS01.DBF
input datafile fno=00005 name=C:\ORACLE\ORADATA\OEM92\EXAMPLE01.DBF
input datafile fno=00011 name=C:\ORACLE\ORADATA\OEM92\OEM_REPOSITORY.DBF
input datafile fno=00010 name=C:\ORACLE\ORADATA\OEM92\XDB01.DBF
input datafile fno=00006 name=C:\ORACLE\ORADATA\OEM92\INDX01.DBF
input datafile fno=00009 name=C:\ORACLE\ORADATA\OEM92\USERS01.DBF
input datafile fno=00003 name=C:\ORACLE\ORADATA\OEM92\CWMLITE01.DBF
input datafile fno=00004 name=C:\ORACLE\ORADATA\OEM92\DRSYS01.DBF
input datafile fno=00007 name=C:\ORACLE\ORADATA\OEM92\ODM01.DBF
input datafile fno=00008 name=C:\ORACLE\ORADATA\OEM92\TOOLS01.DBF
channel Channel1: starting piece 1 at AUG 01 2003 09:52:07
channel Channel1: finished piece 1 at AUG 01 2003 09:53:02
piece handle=C:\ORACLE\ORADATA\OEM92\BACKUP\B_03ETM4I5_1_1 comment=NONE
channel Channel1: backup set complete, elapsed time: 00:00:57
Finished backup at AUG 01 2003 09:53:02
Starting backup at AUG 01 2003 09:53:02
current log archived
channel Channel1: starting archive log backupset
channel Channel1: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=2 stamp=500828956
input archive log thread=1 sequence=2 recid=1 stamp=500828955
input archive log thread=1 sequence=3 recid=3 stamp=500828961
input archive log thread=1 sequence=4 recid=4 stamp=500832586
input archive log thread=1 sequence=5 recid=5 stamp=500832767
input archive log thread=1 sequence=6 recid=6 stamp=500832767
input archive log thread=1 sequence=7 recid=7 stamp=500833485
input archive log thread=1 sequence=8 recid=8 stamp=500833488
input archive log thread=1 sequence=9 recid=9 stamp=500833494
input archive log thread=1 sequence=10 recid=10 stamp=500833603
input archive log thread=1 sequence=11 recid=11 stamp=500833646
input archive log thread=1 sequence=12 recid=12 stamp=500850612
input archive log thread=1 sequence=13 recid=13 stamp=500850621
input archive log thread=1 sequence=14 recid=14 stamp=500896019
input archive log thread=1 sequence=15 recid=15 stamp=500896383
channel Channel1: starting piece 1 at AUG 01 2003 09:53:06
channel Channel1: finished piece 1 at AUG 01 2003 09:53:21
piece handle=C:\ORACLE\ORADATA\OEM92\BACKUP\B_04ETM4K1_1_1 comment=NONE
channel Channel1: backup set complete, elapsed time: 00:00:16
channel Channel1: deleting archive log(s)
archive log filename=C:\ORACLE\ORA92\RDBMS\ARCHIVEARC00001.001 recid=2 stamp=500828956
archive log filename=C:\ORACLE\ORA92\RDBMS\ARCHIVEARC00002.001 recid=1 stamp=500828955
archive log filename=C:\ORACLE\ORA92\RDBMS\ARCHIVEARC00003.001 recid=3 stamp=500828961
archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00004.001 recid=4 stamp=500832586
archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00005.001 recid=5 stamp=500832767
archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00006.001 recid=6 stamp=500832767
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00007.001 recid=7 stamp=500833485
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00008.001 recid=8 stamp=500833488
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00009.001 recid=9 stamp=500833494
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00010.001 recid=10 stamp=500833603
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00011.001 recid=11 stamp=500833646
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00012.001 recid=12 stamp=500850612
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00013.001 recid=13 stamp=500850621
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00014.001 recid=14 stamp=500896019
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00015.001 recid=15 stamp=500896383
Finished backup at AUG 01 2003 09:53:22
released channel: Channel1
RMAN>
RMAN> **end-of-file**
RMAN>
Recovery Manager complete.
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN>
connected to target database: OEM92 (DBID=4042519487)
using target database controlfile instead of recovery catalog
RMAN>
RMAN> configure retention policy to recovery window of 7 days;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
RMAN>
RMAN> **end-of-file**
RMAN>
Recovery Manager complete.
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN>
connected to target database: OEM92 (DBID=4042519487)
using target database controlfile instead of recovery catalog
RMAN>
RMAN> run {
2> allocate channel Channel1 type disk format 'C:\ORACLE\ORADATA\OEM92\BACKUP\b_%u_%p_%c';
3> backup ( database include current controlfile );
4> backup ( archivelog all
5> delete input );
6>
7> }
allocated channel: Channel1
channel Channel1: sid=28 devtype=DISK
Starting backup at AUG 01 2003 09:52:05
channel Channel1: starting full datafile backupset
channel Channel1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=C:\ORACLE\ORADATA\OEM92\SYSTEM01.DBF
input datafile fno=00002 name=C:\ORACLE\ORADATA\OEM92\UNDOTBS01.DBF
input datafile fno=00005 name=C:\ORACLE\ORADATA\OEM92\EXAMPLE01.DBF
input datafile fno=00011 name=C:\ORACLE\ORADATA\OEM92\OEM_REPOSITORY.DBF
input datafile fno=00010 name=C:\ORACLE\ORADATA\OEM92\XDB01.DBF
input datafile fno=00006 name=C:\ORACLE\ORADATA\OEM92\INDX01.DBF
input datafile fno=00009 name=C:\ORACLE\ORADATA\OEM92\USERS01.DBF
input datafile fno=00003 name=C:\ORACLE\ORADATA\OEM92\CWMLITE01.DBF
input datafile fno=00004 name=C:\ORACLE\ORADATA\OEM92\DRSYS01.DBF
input datafile fno=00007 name=C:\ORACLE\ORADATA\OEM92\ODM01.DBF
input datafile fno=00008 name=C:\ORACLE\ORADATA\OEM92\TOOLS01.DBF
channel Channel1: starting piece 1 at AUG 01 2003 09:52:07
channel Channel1: finished piece 1 at AUG 01 2003 09:53:02
piece handle=C:\ORACLE\ORADATA\OEM92\BACKUP\B_03ETM4I5_1_1 comment=NONE
channel Channel1: backup set complete, elapsed time: 00:00:57
Finished backup at AUG 01 2003 09:53:02
Starting backup at AUG 01 2003 09:53:02
current log archived
channel Channel1: starting archive log backupset
channel Channel1: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=2 stamp=500828956
input archive log thread=1 sequence=2 recid=1 stamp=500828955
input archive log thread=1 sequence=3 recid=3 stamp=500828961
input archive log thread=1 sequence=4 recid=4 stamp=500832586
input archive log thread=1 sequence=5 recid=5 stamp=500832767
input archive log thread=1 sequence=6 recid=6 stamp=500832767
input archive log thread=1 sequence=7 recid=7 stamp=500833485
input archive log thread=1 sequence=8 recid=8 stamp=500833488
input archive log thread=1 sequence=9 recid=9 stamp=500833494
input archive log thread=1 sequence=10 recid=10 stamp=500833603
input archive log thread=1 sequence=11 recid=11 stamp=500833646
input archive log thread=1 sequence=12 recid=12 stamp=500850612
input archive log thread=1 sequence=13 recid=13 stamp=500850621
input archive log thread=1 sequence=14 recid=14 stamp=500896019
input archive log thread=1 sequence=15 recid=15 stamp=500896383
channel Channel1: starting piece 1 at AUG 01 2003 09:53:06
channel Channel1: finished piece 1 at AUG 01 2003 09:53:21
piece handle=C:\ORACLE\ORADATA\OEM92\BACKUP\B_04ETM4K1_1_1 comment=NONE
channel Channel1: backup set complete, elapsed time: 00:00:16
channel Channel1: deleting archive log(s)
archive log filename=C:\ORACLE\ORA92\RDBMS\ARCHIVEARC00001.001 recid=2 stamp=500828956
archive log filename=C:\ORACLE\ORA92\RDBMS\ARCHIVEARC00002.001 recid=1 stamp=500828955
archive log filename=C:\ORACLE\ORA92\RDBMS\ARCHIVEARC00003.001 recid=3 stamp=500828961
archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00004.001 recid=4 stamp=500832586
archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00005.001 recid=5 stamp=500832767
archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00006.001 recid=6 stamp=500832767
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00007.001 recid=7 stamp=500833485
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00008.001 recid=8 stamp=500833488
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00009.001 recid=9 stamp=500833494
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00010.001 recid=10 stamp=500833603
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00011.001 recid=11 stamp=500833646
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00012.001 recid=12 stamp=500850612
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00013.001 recid=13 stamp=500850621
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00014.001 recid=14 stamp=500896019
archive log filename=C:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00015.001 recid=15 stamp=500896383
Finished backup at AUG 01 2003 09:53:22
released channel: Channel1
RMAN>
RMAN> **end-of-file**
RMAN>
Recovery Manager complete.
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN>
connected to target database: OEM92 (DBID=4042519487)
using target database controlfile instead of recovery catalog
RMAN>
RMAN> configure retention policy to recovery window of 7 days;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
RMAN>
RMAN> **end-of-file**
RMAN>
Recovery Manager complete.
