test___just a temp result, ignore it...-CSDN博客

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

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

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9765498/viewspace-232262/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9765498/viewspace-232262/