Database Reference
In-Depth Information
In this example, we will try to start up our database from the RMAN prompt only to
find that the
SYSTEM
tablespace data file is missing for some odd reason:
RMAN> startup
Oracle instance started
database mounted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 09/28/2013 17:37:53
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
We could, of course, restore the entire database, but the size of the
SYSTEM
tablespace/
data file is a very small part of the overall size of the database. So we will just restore and
recover the
SYSTEM
tablespace. Note that the
SYSTEM
tablespace is a critical tablespace; thus,
this recovery cannot be done online:
RMAN> startup
Oracle instance started
database mounted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 09/28/2013 17:37:53
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
RMAN> restore tablespace system;
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 00001 to
C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
channel ORA_DISK_1: reading from backup piece
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_09_28
\O1_MF_NNNDF_TAG20130928T172015_4G049OQX_.BKP
channel ORA_DISK_1: piece
Search WWH ::
Custom Search