Database Reference
In-Depth Information
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 700 SYSTEM ***
C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 716 SYSAUX ***
C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
4 0 USERS ***
C:\ORACLE\ORADATA\ORCL\USERS01.DBF
5 30 UNDOTBS2 ***
C:\ORACLE\ORADATA\ORCL\UNDOTBS02.DBF
2.
From the RMAN prompt, take all the data files or tablespaces to be recovered offline.
You do this by using the RMAN
SQL
command followed by the appropriate
ALTER
DATABASE DATAFILE OFFLINE
command or the
ALTER TABLESPACE OFFLINE
command.
3.
From the RMAN prompt, issue the
ALTER DATABASE OPEN
command. The database
should open without complaining about any missing data files.
Here is a case where we have tried to start our database and the
USERS01.DBF
data file
is not available. We will make sure that this is the only data file that needs to be restored.
We then take the data file offline and open the database:
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:50:49
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: 'C:\ORACLE\ORADATA\ORCL\USERS01.DBF'
-- We use the report schema command here to look at the schema.
-- we will cover this command in the next chapter.
RMAN> report schema;
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- ------------------ ------- ------------------------
1 700 SYSTEM *** C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 716 SYSAUX *** C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
3 0 USERS *** C:\ORACLE\ORADATA\ORCL\USERS01.DBF
5 30 UNDOTBS2 *** C:\ORACLE\ORADATA\ORCL\UNDOTBS02.DBF
Search WWH ::
Custom Search