ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN Restore Clause

RMAN Restore Clause

原创 Linux操作系统 作者:liu_qingwei2008 时间:2011-04-28 16:39:00 0 删除 编辑

RMAN Restore Clause

Restore RMAN backups and copies.

Syntax:

   RESTORE
   [(] restoreObject [(restoreSpecOperand [restoreSpecOperand]...] [)]... 
   [ CHANNEL ['] channel_id ['] 
   | PARMS [=] 'channel_parms' 
   | FROM { BACKUPSET | DATAFILECOPY } 
   | untilClause 
   | FROM TAG [=] ['] tag_name ['] 
   | VALIDATE 
   | DEVICE TYPE deviceSpecifier [, deviceSpecifier]... 
   .
   .
   .
   ]...;

   restoreObject::=
     { CONTROLFILE [TO 'filename']
     | DATABASE 
       [SKIP [FOREVER] TABLESPACE 
        ['] tablespace_name ['] [, ['] tablespace_name [']]...
       ]
     | DATAFILE datafileSpec [, datafileSpec]...
     | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]...
     | archivelogRecordSpecifier
     | SPFILE [TO [PFILE] 'filename']
     }

   restoreSpecOperand::=
     { CHANNEL ['] channel_id [']
     | FROM TAG [=] ['] tag_name [']
     | PARMS [=] 'channel_parms'
     | FROM 
       { AUTOBACKUP 
         [{ MAXSEQ | MAXDAYS } [=] integer)]... 
       | 'media_handle'
       }
     }

Examples

Full DR recovery - Full Example (restoring to a different machine)
Point in time recovery - Full Example (restoring to the same machine / different date/time)

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 users OFFLINE';
 RMAN> RESTORE TABLESPACE users;
 RMAN> RECOVER TABLESPACE users;
 RMAN> SQL 'ALTER TABLESPACE users ONLINE';

Restore and recover a Datafile:

 RMAN> SQL 'ALTER DATABASE DATAFILE 64 OFFLINE';
 RMAN> RESTORE DATAFILE 64;
 RMAN> RECOVER DATAFILE 64;
 RMAN> SQL 'ALTER DATABASE DATAFILE 64 ONLINE';

Restore the Control file, (to all locations specified in the parameter file) then restore the database, using that control file:

STARTUP NOMOUNT;
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
RESTORE DATABASE;
}

Restore Validation confirms that a restore could be run, by confirming that all database files exist and are free of physical and logical corruption, this does not generate any output.
Example:

 RMAN> RESTORE DATABASE VALIDATE;

"Don't count the days, make the days count" - Muhammad Ali

Related Commands:

BACKUP - Back up database files, archive logs, backups, or copies.
CROSSCHECK
- Check whether backup items still exist.
LIST
- List backups and copies
RECOVER
- Perform. media recovery from RMAN backups and copies.
REPORT
- Report backup status: database, files, backups
RUN
- Some RMAN commands are only valid inside a RUN block.
SET
- Settings for the current RMAN session.
SHOW
- Display the current configuration

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23898243/viewspace-694025/,如需转载,请注明出处,否则将追究法律责任。

上一篇: RMAN Recover Clause
下一篇: RMAN LIST
请登录后发表评论 登录
全部评论

注册时间:2010-05-12

  • 博文量
    37
  • 访问量
    86615