Database Reference
In-Depth Information
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- ----------------- ----------- --------------------
1 20 TEMP 32767 C:\ORACLE\ORADATA\ORCL\TEMP01.DBF
RMAN> sql 'alter database datafile 3 offline';
sql statement: alter database datafile 3 offline
RMAN> alter database open;
database opened
Restoring Database Data Files Online
Once the database is up and running or if the database was already running, follow these
steps to restore one or more missing data files:
1. From the RMAN prompt, take the data file or data files offline using the RMAN SQL
command calling the ALTER DATABASE DATAFILE OFFLINE command. Do this for each
data file that you need to take offline.
2. From the RMAN prompt, restore the data files using the RESTORE DATAFILE command.
You can restore one or multiple data files in one shot. You will be returned to the RMAN
prompt once the restore is complete.
3. Having restored the data files, use the RECOVER DATAFILE command to recover each
specific data file. This will apply any incremental backups and archived redo logs to
the restored data file. You will be returned to the RMAN prompt once the recovery
is complete.
4. Bring the data file(s) back online using the RMAN SQL command to issue the ALTER
DATABASE DATAFILE ONLINE SQL command. This will bring each data file online,
completing the recovery process.
In this example, the USERS01.DBF data file is already offline (we offlined the data file in
the earlier example). We will restore that data file (referring to it by its data file number) and
then recover it. Finally, we will bring the data file online so that the database may access it:
RMAN> restore datafile 3;
Starting restore at 28-SEP-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=136 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 00003 to
C:\ORACLE\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: reading from backup piece
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_09_28
\O1_MF_NNNDF_TAG20130928T185206_4G09OW7B_.BKP
channel ORA_DISK_1: piece
Search WWH ::




Custom Search