系统表空间恢复

Ø 系统表空间损坏或丢失

SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/u01/oradata/retc/rwsw_system' SQL> recover database using backup controlfile; ORA-00283: recovery session canceled due to errors ORA-01110: data file 1: '/u01/oradata/retc/rwsw_system' ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/u01/oradata/retc/rwsw_system'

Ø restore系统表空间SYSTEM

rman target / catalog rman/rman@rmandb Recovery Manager: Release 9.2.0.7.0 - 64bit Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: RETC (DBID=1688860591) connected to recovery catalog database RMAN> run 2> { 3> allocate channel t1 type 'SBT_TAPE' 4> parms 'BLKSIZE=524288,ENV=(TDPO_OPFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; 5> set newname for datafile 1 to '/u01/oradata/retc/rwsw_system'; 6> restore tablespace system from tag='TAG20121124T053038'; 7> release channel t1; 8> } 9> allocated channel: t1 channel t1: sid=10 devtype=SBT_TAPE channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0 executing command: SET NEWNAME Starting restore at 06-DEC-12 channel t1: starting datafile backupset restore channel t1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u01/oradata/retc/rwsw_system channel t1: restored backup piece 1 piece handle=7cnr387v_1_1 tag=TAG20121124T053038 params=NULL channel t1: restored backup piece 2 piece handle=7cnr387v_2_1 tag=TAG20121124T053038 params=NULL channel t1: restore complete Finished restore at 06-DEC-12 released channel: t1 Recovery Manager complete.

Ø 恢复系统表空间SYSTEM