Recovering to Standby Database
Hi, in this environment, we are running 11g (soon to be 12c in a few weeks). But we are taking copies of archive logs from the primary server, sending them to a standby server, and wanting to apply those logs to the standby.
We did this by doing an rsync on the database files.
Followed by this command: alter database create standby controlfile as '/tmp/standby.ctl';
That file was sent to the standby, replacing the existing control files.
On the standby we then did:
- STARTUP NOMOUNT;
- ALTER DATABASE MOUNT STANDBY DATABASE;
- RECOVER AUTOMATIC DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;