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;
}
