A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

Recovery of dropped tablespace with RMAN

1 min read
SELECT NAME ,OPEN_MODE FROM V$DATABASE;
SELECT LOG_MODE FROM V$DATABASE;
SELECT NAME FROM V$DATAFILE;
SELECT NAME FROM V$TABLESPACE;
CREATE TABLESPACE(TB1)
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
LIST BACKUP OF CONTROLFILE;
LIST BACKUP OF TABLESPCAE TB1;
DROP TABLESPACE TB1 INCLUDING CONTENTS AND DATAFILES;
SELECT NAME FROM V$DATAFILE;
SELECT NAME FROM V$TABLESPACE;
LIST BACKUP OF TABLESPCAE TB1; =======> Not present in catalog
shu immediate;
startup nomount;
RMAN > RESTORE CONTROLFILE FROM '/U01/----------.BKP';
ALTER DATABASE MOUNT;
LIST BACKUP OF TABLESPCAE TB1;
RMAN> run
{set until scn ----;
restore database;
}
RMAN> run
{set until scn ----;
recover database;
}
Alter database open resetlogs;
List incarnation;