Dataguard Daily Maintenance

Opening the main and standby libraries correctly

1 Main Library:

SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;

2 Reserve Library:

SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Two correct shutdown order

1 Reserve Library:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL>SHUTDOWN IMMEDIATE;

2 Main Library

Sql>shutdown IMMEDIATE;

Three-Spare library read-only mode open

Current Main Library normal open state

The standby is in log shipping state.

1 Stop log shipping in the repository

sql> Recover managed standby database cancel;

2 Standby read-only Mode open

Sql> ALTER DATABASE open read only;

3 Reserve Library back to log shipping mode

SQL> recover managed standby database disconnect from session;
Media recovery complete.
SQL> select status from v$instance;

STATUS
------------
MOUNTED