Create a standby database with RMAN

The following is Recovery Manager tip #4 from "30 tips in 30 minutes," brought to you by the IOUG. Return to the main page for more tips on this topic.

RMAN will create a standby of an open database with just a few simple commands. Connect to the target database, the catalog schema an auxiliary instance. Run these few simple commands and your standby database will be created and recovered for you:

run {
   set command id to 'Create Standby Database';
   set until logseq 101 thread 1;
   allocate auxiliary channel d1 type disk;
   duplicate target database for standby;
   dorecover;
}

The standby database will be recovered to (but not including) log sequence 101. For more details: see chapter 16 of "Oracle backup and recovery 101."

Get more tips in minutes! Return to the main page.

About the author: Kenny Smith has been working with Oracle technology on HP servers for over a decade. He specializes in Oracle database architecture, database administration and development. He has presented at numerous Oracle conferences on two continents. He has published many articles describing Oracle solutions and has co-authored "Oracle backup and recovery 101" from Oracle Press.

IOUG: Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.