Database Reference
In-Depth Information
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 09/28/2013 20:01:30
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: 'C:\ORACLE\ORADATA\ORCL\USERS01.DBF'
RMAN> sql 'alter tablespace users datafile offline';
sql statement: alter tablespace users datafile offline
RMAN> alter database open;
database opened
RMAN> restore tablespace users;
Starting restore at 28-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=153 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
handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_09_28
\O1_MF_NNNDF_TAG20130928T185206_4G09OW7B_.BKP tag=TAG20130928T185206
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 28-SEP-13
RMAN> recover tablespace users;
Starting recover at 28-SEP-13
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:02
Finished recover at 28-SEP-13
RMAN> sql 'alter tablespace users online';
sql statement: alter tablespace users online
Restoring Read-Only Tablespaces
Restoring read-only tablespaces is done the same way that you restore regular tablespaces.
The only difference is that RMAN will skip backups of read-only tablespaces, after they
have been backed up and if backup optimization is enabled. The only problem with this is
Search WWH ::
Custom Search