Database Backup and Recovery (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center