RMAN - Create Standby Database
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;