RMAN> configure controlfile autobackup off;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\OPT\ORACLE9I\PRODUCT\9.2.0\DATABASE\SNCFORA92US.ORA'; # default
RMAN> backup database format 'D:\ora_bak\RMAN\ORA92US\df_%d_%s_%p.bak';
Starting backup at 2008-04-09 14:08:48
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=9 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\SYSTEM01.DBF
input datafile fno=00002 name=D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\UNDOTBS01.DBF
input datafile fno=00003 name=D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 2008-04-09 14:08:50
channel ORA_DISK_1: finished piece 1 at 2008-04-09 14:09:25
piece handle=D:\ORA_BAK\RMAN\ORA92US\DF_ORA92US_6_1.BAK comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:36
Finished backup at 2008-04-09 14:09:25
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1 Full 442M DISK 00:00:28 2008-04-09 10:12:02
BP Key: 1 Status: AVAILABLE Tag: WHOLECOLD
Piece Name: D:\ORA_BAK\RMAN\ORA92US\DF_ORA92US_2_1.BAK
SPFILE Included: Modification time: 2008-04-09 10:07:38
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 1611232 2008-04-09 10:11:35 D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\SYSTEM01.DBF
2 Full 1611232 2008-04-09 10:11:35 D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\UNDOTBS01.DBF
3 Full 1610978 2008-04-09 10:03:40 D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\USERS01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Full 441M DISK 00:00:28 2008-04-09 13:20:31
BP Key: 2 Status: AVAILABLE Tag: TAG20080409T132003
Piece Name: D:\ORA_BAK\RMAN\ORA92US\DF_ORA92US_3_1.BAK
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 1615052 2008-04-09 13:20:04 D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\SYSTEM01.DBF
2 Full 1615052 2008-04-09 13:20:04 D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\UNDOTBS01.DBF
3 Full 1615052 2008-04-09 13:20:04 D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\USERS01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 1M DISK 00:00:01 2008-04-09 13:27:32
BP Key: 3 Status: AVAILABLE Tag:
Piece Name: D:\OPT\ORACLE9I\PRODUCT\9.2.0\DATABASE\C-3206997025-20080409-00
SPFILE Included: Modification time: 2008-04-09 10:07:38
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 442M DISK 00:00:31 2008-04-09 14:09:20
BP Key: 4 Status: AVAILABLE Tag: TAG20080409T140849
Piece Name: D:\ORA_BAK\RMAN\ORA92US\DF_ORA92US_6_1.BAK
SPFILE Included: Modification time: 2008-04-09 10:07:38
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 1616001 2008-04-09 14:08:51 D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\SYSTEM01.DBF
2 Full 1616001 2008-04-09 14:08:51 D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\UNDOTBS01.DBF
3 Full 1616001 2008-04-09 14:08:51 D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\USERS01.DBF
RMAN> shutdown immediate;
database closed
database dismounted
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
C:\Documents and Settings\p485224>
C:\Documents and Settings\p485224>
C:\Documents and Settings\p485224>
C:\Documents and Settings\p485224>rman target /
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database (not started)
RMAN> startup
Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 04/09/2008 14:11:57
ORA-00205: error in identifying controlfile, check alert log for more info
RMAN> restore controlfile from 'D:\ora_bak\RMAN\ORA92US\DF_ORA92US_6_1.BAK';
Starting restore at 2008-04-09 14:12:39
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: restoring controlfile
channel ORA_DISK_1: restore complete
replicating controlfile
input filename=D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\CONTROL01.CTL
output filename=D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\CONTROL02.CTL
output filename=D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\CONTROL03.CTL
Finished restore at 2008-04-09 14:12:47
RMAN> alter database mount;
database mounted
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/09/2008 14:13:14
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/09/2008 14:14:37
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\SYSTEM01.DBF'
RMAN> restore database;
Starting restore at 2008-04-09 14:14:49
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/09/2008 14:14:49
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
RMAN> restore database from 'D:\ora_bak\RMAN\ORA92US\DF_ORA92US_6_1.BAK';
Starting restore at 2008-04-09 14:15:17
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/09/2008 14:15:17
RMAN-06509: only SPFILE or controlfile can be restored from autobackup
RMAN> recover database;
Starting recover at 2008-04-09 14:15:33
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 1 is already on disk as file D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\REDO03.LO
archive log filename=D:\OPT\ORACLE9I\PRODUCT\9.2.0\ORADATA\ORA92US\REDO03.LOG thread=1 sequence=0
media recovery complete
Finished recover at 2008-04-09 14:15:33
RMAN> alter database open reset logs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "reset": expecting one of: "resetlogs, ;"
RMAN-01007: at line 1 column 21 file: standard input
RMAN> alter database open resetlogs;
database opened
RMAN>
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORA92US 3206997025 NO 1 2008-03-17 15:57:21
2 2 ORA92US 3206997025 NO 1615082 2008-04-09 13:27:23
3 3 ORA92US 3206997025 YES 1616053 2008-04-09 14:17:04
RMAN> xit