備份恢複-----system資料表空間損壞

標籤：

無法進行關庫，報錯如下

SQL> shutdown immediate
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: ‘/u01/app/oracle/oradata/cuug/system01.dbf‘
ORA-01210: data file header is media corrupt
SQL>

只能啟動到mount狀態

SQL> startup
ORACLE instance started.

Total System Global Area 425897984 bytes
Fixed Size 2226656 bytes
Variable Size 322962976 bytes
Database Buffers 96468992 bytes
Redo Buffers 4239360 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: ‘/u01/app/oracle/oradata/cuug/system01.dbf‘

SQL>

手動刪除system資料表空間的資料檔案

[[email protected]:/u01/app/oracle/oradata/cuug]# ls
control01.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
control02.ctl redo02.log sysaux01.dbf temp01.dbf users01.dbf
[[email protected]:/u01/app/oracle/oradata/cuug]# rm -rf system01.dbf
[[email protected]:/u01/app/oracle/oradata/cuug]# ls
control01.ctl redo01.log redo03.log temp01.dbf users01.dbf
control02.ctl redo02.log sysaux01.dbf undotbs01.dbf
[[email protected]:/u01/app/oracle/oradata/cuug]#

在rman下啟動到mount狀態下

RMAN> startup mount

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 425897984 bytes

Fixed Size 2226656 bytes
Variable Size 322962976 bytes
Database Buffers 96468992 bytes
Redo Buffers 4239360 bytes

RMAN>

轉儲datafile 1

RMAN> restore datafile 1;

Starting restore at 29-SEP-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/cuug/system01.dbf
channel ORA_DISK_1: reading from backup piece /backup/02qidfdl_1_1.bak
channel ORA_DISK_1: piece handle=/backup/02qidfdl_1_1.bak tag=TAG20150929T230940
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:55
Finished restore at 29-SEP-15

恢複datafile 1

RMAN>recover datafile 1;

Starting recover at 29-SEP-15
using channel ORA_DISK_1

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

Finished recover at 29-SEP-15

開庫

RMAN> alter database open ;

database opened

RMAN>

 

備份恢複-----system資料表空間損壞