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