Rman Recovery Database Enhancements in Oracle 10g

We know that in previous versions of Oracle 10g R2, temporary files for temporary tablespaces are not automatically restored if you use Rman to recover the database.

This has caused a series of problems, many DBAs forget to add temporary files after the recovery is complete, often to the application error to discover.

Starting with the Oracle 10g R2, after using Rman to recover the database, Oracle will automatically re-create the temporary files, because the temporary files are sparse file, so the creation will be very rapid, usually you will not feel it.

The following is a log that I recovered, documenting Oracle's recovery process:

Thu Sep 22:52:06 2006
successfully onlined Undo tablespace 1.
Dictionary Check beginning
Thu Sep 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/oradat A/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 22:52:06 2006
Errors in File/opt/oracle/admin/order/bdump/ord ER_DBW0_31025.TRC:
Ora-01186:file 201 Failed verification tests
Ora-01157:cannot identify/lock data File 201-s EE dbwr trace File
Ora-01110:data file 201: '/data1/oradata/order/datafile/o1_mf_temp_28spyr8h_.tmp '
Thu Sep 14 2 2:52:06 2006
File 201 not verified due to error ORA-01157
Thu Sep 22:52:06 2006
Dictionary Check complete Thu Sep 22:52:06 2006
smon:enabling TX Recovery
ThU Sep 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 pi d=22, OS id=13671
Thu Sep 22:52:10 2006
logstdby:validating controlfile with logical metadata
Thu SEP 14 2 2:52:10 2006
Logstdby:validation complete
Starting control Autobackup
Control autobackup written to DISK Devi Ce
handle '/opt/oracle/product/db10g/dbs/c-1341966532-20060914-03 '
Completed:alter database open resetlogs

This is also a meticulous improvement of ORACLE10GR2.