10gR2使用RMAN恢復(fù)臨時表空間的增強

2024-07-21 02:32:50

字體：大中小

供稿：網(wǎng)友

我們知道在Oracle10gR2以前的版本中，假如使用RMAN恢復(fù)數(shù)據(jù)庫，臨時表空間的臨時文件是不會自動恢復(fù)的。
這曾經(jīng)引發(fā)了一系列的麻煩，很多DBA在恢復(fù)完成之后忘記添加臨時文件，經(jīng)常到應(yīng)用出錯時才能發(fā)現(xiàn)。從Oracle10gR2開始，使用RMAN恢復(fù)數(shù)據(jù)庫之后，Oracle會自動重新創(chuàng)建臨時文件，由于臨時文件是Sparse File，所以創(chuàng)建會非常迅速，通常你不會感覺得到。以下是我曾經(jīng)恢復(fù)的一段日志，其中記錄了Oracle的恢復(fù)處理過程:

Thu Sep 14 22:52:06 2006
SUCcessfully onlined Undo Tablespace 1.
Dictionary check beginning
Thu Sep 14 22:52:06 2006
Errors in file /opt/oracle/admin/order/bdump/order_dbw0_31025.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/data1/oradata/ORDER/datafile/o1_mf_temp_28spyr8h_.tmp'
ORA-27037: unable to oBTain file status
linux Error: 2: No such file or Directory
Additional information: 3
Thu Sep 14 22:52:06 2006
Errors in file /opt/oracle/admin/order/bdump/order_dbw0_31025.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/data1/oradata/ORDER/datafile/o1_mf_temp_28spyr8h_.tmp'
Thu Sep 14 22:52:06 2006
File 201 not verified due to error ORA-01157
Thu Sep 14 22:52:06 2006
Dictionary check complete
Thu Sep 14 22:52:06 2006
SMON: enabling tx recovery
Thu Sep 14 22:52:06 2006
Re-creating tempfile /data1/oradata/ORDER/datafile/o1_mf_temp_28spyr8h_.tmp as
/data1/oradata/ORDER/datafile/o1_mf_temp_2jlv4p90_.tmp
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background PRocess QMNC
QMNC started with pid=22, OS id=13671
Thu Sep 14 22:52:10 2006
LOGSTDBY: Validating controlfile with logical metadata
Thu Sep 14 22:52:10 2006
LOGSTDBY: Validation complete
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/oracle/product/db10g/dbs/c-1341966532-20060914-03'
Completed: alter database open resetlogs