Tablespace Recovery
Used when number of datafiles to be recovered are large and belong to a particular Tablespace.
Note: Database is running in ARCHIVELOG mode
OPEN Database Recovery :
SVRMGR> ALTER TABLESPACE USERS OFFLINE IMMEDIATE; **
SVRMGR> RECOVER TABLESPACE USERS;
(APPLY REQD. ARCHIVELOG FILES)SVRMGR> ALTER TABLESPACE USERS ONLINE;
** If no errors exist for the Tablespace take it OFFLINE NORMAL,
The Tablespace to be taken OFFLINE should not have any active rollback segments.
CLOSED Database Recovery:
SVRMGR> STARTUP MOUNT;
Take the datafiles belonging to the tablespace OFFLINE first
SVRMGR> ALTER DATABASE DATAFILE '/dsk01/ORACLE/reco/users01.dbf' OFFLINE;
SVRMGR> ALTER DATABASE DATAFILE ''/dsk01/ORACLE/reco/users02.dbf' OFFLINE;
SVRMGR> ALTER DATABASE OPEN;
SVRMGR> ALTER TABLESPACE USERS OFFLINE IMMEDIATE; **
SVRMGR> RECOVER TABLESPACE USERS;
(APPLY REQD. ARCHIVELOG FILES)SVRMGR> ALTER TABLESPACE USERS ONLINE;
Check the Status of the datafile from V$DATAFILE.
If Datafiles are still to be recovered, STATUS will show as RECOVER.