LESSON 19
How to
perform recovery from missing of data
Assuming you last the SYSTEM tablespace of mycdb
Recover
the SYSTEM tablespace of mycdb
# rman target
/
RMAN> list
backup summary;
RMAN> SHUTDOWN
ABORT;
RMAN> STARTUP
MOUNT;
RMAN> RESTORE
TABLESPACE system;
RMAN> RECOVER
TABLESPACE system;
RMAN> ALTER
DATABASE OPEN;
RMAN> ALTER
PLUGGABLE DATABASE ALL OPEN;
RMAN> EXIT;
Recover
the whole mypdb1 pluggable database
# rman target
/
RMAN> list
backup summary;
RMAN> SHUTDOWN
ABORT;
RMAN> STARTUP
MOUNT;
RMAN> RESTORE
PLUGGABE DATABASE mypdb1;
RMAN> RECOVER
PLUGGABE DATABASE mypdb1;
RMAN> ALTER
DATABASE OPEN;
RMAN> ALTER
PLUGGABLE DATABASE ALL OPEN;
RMAN> EXIT;
Recover
the whole tablespace mytbs from mypdb1 pluggable database
SQL> connect
sys/mypass@mypdb1 as sysdba
SQL> ALTER
TABLESPACE mytbs OFFLINE IMMEDIATE;
# rman target
/
RMAN> list
backup summary;
RMAN> RESTORE
TABLESPACE mypdb1:mytbs;
RMAN> RECOVER
TABLESPACE mypdb1:mytbs;
RMAN> EXIT;
SQL> connect
sys/mypass@mypdb1 as sysdba
SQL> ALTER
TABLESPACE mytbs ONLINE;
Recovery from missing control files
# rman target
/
RMAN> list
backup summary;
RMAN> SHUTDOWN
ABORT;
RMAN> STARTUP
NOMOUNT;
RMAN> RESTORE
CONTROLFILE FROM AUTOBACKUP;
RMAN> ALTER
DATABASE MOUNT;
RMAN> RECOVER
DATABASE;
RMAN> ALTER
DATABASE OPEN RESETLOGS;
RMAN> EXIT;
Reclaiming space on the recovery area by deleting backupset, obsolete
objects and archivelog files
# rman target
/
RMAN> list
backup summary;
RMAN> DELETE
archivelog all;
RMAN> DELETE
archivelog until time "sysdate-7";
RMAN> DEETE
obsolete;
RMAN> DELETE
backup until time "sysdate-7";
Recovery from missing SYSAUX of your CDB
# rman target
/
RMAN> list
backup summary;
RMAN> ALTER
TABLESPACE sysaux OFFLINE IMMEDIATE;
RMAN> RESTORE
TABLESPACE sysaux;
RMAN> RECOVER
TABLESPACE sysaux;
RMAN> ALTER
TABLESPACE sysaux ONLINE;
RMAN> RMAN>
EXIT;
Recovery from user deleted records not knowing using Point-In-Time
Recovery (PITR)
# rman target
/
RMAN> list
backup summary;
RMAN> ALTER
PLUGGABLE DATABASE mypdb1 CLOSE IMMEDIATE;
RMAN> RUN {
SET UNTIL SCN = xxxxxxx;
RESTORE PLUGGABLE DATABASE mypdb1;
RECOVER PLUGGABLE DATABASE mypdb1 AUXILIARY DESTINATION="/oradata/mypdb1";
ALTER PLUGGABLE DATABASE mypdb1 OPEN RESETLOGS;
}
RMAN> EXIT;
Good Luck!
|