How to skip a tablespace for restore operation
With the RESTORE DATABASE command we perform all datafiles restore operation except those that are offline or read-only.
Note that RESTORE DATABASE does not work same as BACKUP DATABASE. With command BACKUP DATABASE, RMAN backs up datafiles along with controlfiles and spfile. But with RESTORE COMMAND operation, RMAN only restores datafiles.
To omit a certain tablespace for restore operation use RESTORE DATABASE SKIP TABLESPACE tablespace_name. Suppose I want to omit restore of indexed tablespace KRISH,KRISHNAand SIVA. Then my restore command will be,
RMAN>RESTORE DATABASE SKIP TABLESPACE KRISH,KRISHNA,SIVA;
If you specify SKIP FOREVER TABLESPACE, then RMAN specifies the DROP option of ALTER DATABASE DATAFILE ... OFFLINE when taking the datafiles that belong to the tablespace offline before the restore. The DROP option indicates that RMAN does not intend to recover these files and intends to drop their tablespaces from the database after the database is opened again. In other words, FOREVER indicates that RMAN never intends to do anything with the skipped tablespaces again.
Suppose you want to skip forever to restore tablespace KRISHNA,KRISH and SIVA then your command will be,
RMAN>RESTORE DATABASE SKIP FOREVER TABLESPACE KRISHNA, KRISH, SIVA;
No comments:
Post a Comment
Thank for showing interest in giving comments/feedback/suggestions
Note: Only a member of this blog may post a comment.