RMAN - Create Standby Database

From NazimWIKI
Jump to navigation Jump to search

These are just rough notes for my own benefit. They are not well researched and are only posted as a reminder for myself.

Had to convert a database to a physical standby using a RMAN hotbackup taken earlier. No standby redo log files exist and time was limited to do this task. Decided to take a quick and dirty approach and tidy up the rough edges later on when I have more time.

Oracle Version 11.2.0.3.0

Steps taken:

  • Backup the init.ora file and edit the existing one
    • db_name=oraPRD (to match production)
    • db_unique_name=oraSTG
  • Create spfile from pfile
  • Shutdown the database
  • Remove datafiles and onlinelogs from ASM
  • Startup nomount
  • Run RMAN Command
rman auxiliary /

run {
set archivelog destination to '/backup/oraPRD/rmanbackup/device/';
duplicate database for standby
    backup location '/backup/oraPRD/rmanbackup/device/'
  nofilenamecheck;
}


Oracle Version 10.2.0.5.0

On PRODUCTION:

RMAN>COPY CURRENT CONTROLFILE FOR STANDBY TO '/tmp/sby_control01.ctl';

Copy the latest rman backup to the STANDBY server.



ON STANDBY:

rman target sys/password@PRODUCTION_DB auxiliary /  
DUPLICATE TARGET DATABASE FOR STANDBY DORECOVER;