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