Steps for media recovery:
Restore and recover the whole database
RMAN> STARTUP FORCE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN;
Restore and recover a tablespace
RMAN> SQL 'ALTER TABLESPACE AXPERT OFFLINE';
RMAN> RESTORE TABLESPACE AXPERT;
RMAN> RECOVER TABLESPACE AXPERT;
RMAN> SQL 'ALTER TABLESPACE AXPERT ONLINE';
Restore and recover a datafile
RMAN> SQL 'ALTER DATABASE DATAFILE 8 OFFLINE';
RMAN> RESTORE DATAFILE 8;
RMAN> RECOVER DATAFILE 8;
RMAN> SQL 'ALTER DATABASE DATAFILE 8 ONLINE';
Steps to be Performed for tablespace recovery:
1. Mount the database
2. Make the data file offline
3. Restore the data file
4. Recover the data file
5. Make the data file online
6. Open the database
Thanks...
