Standby database commands.
This section, standby db tutorials aims to give you real-life examples and practical advice on
setting up and maintaining Oracle’s standby database technology, now called Oracle Data Guard.
Standby databases are no longer very complex to set up.
By using Data Guard Broker, all the hard work is done for you in the background,
and all you have to do is click a few buttons.
If you would rather get your hands dirty, this is the place for you.
The tutorials below will take you through all the steps needed to set up and maintain an Oracle standby database.
The examples are all related to a physical standby database, not a logical one.
Standby databases are really Oracle’s gift to the DBA community.
Gone are the days where hardware failure meant days of restoring backup files from tapes,
which were probably far away in an offsite vault,
while hoping that the tapes were not corrupt and that no bug had crept into your backup routine.
With a standby database in place, you can be up and running in no time,
minimizing the impact on your users and their businesses.
Quick reference to monitor, start and stop a physical standby database
Starting a physical standby database:
alter database mount standby database;
Starting the managed recovery:
Stop the managed recovery:
Shutdown the physical standby database:
Monitor primary’s archive destination status:
where status <> ‘deferred’ and status <> ‘inactive’;
Check if archived logs are synching OK, compare both results:
- on primary db
- on standby db:
Check Dataguard processes status:
- on standby db:
Recommended reading:
Posted: October 23rd, 2009 under Standby DBs.
Tags: archived logs, backup routine, database shutdown, database technology, dest, hardware failure, oracle data, oracle standby databas commands, oracle standby database, quick reference, seq, standby databases