The snapshot standby can be restored to its normal function as a physical standby through through SQL*Plus using the procedure described in 10.7.3 Converting a Snapshot Standby Database into a Physical Standby Database.
One (1) system is involved:
On BOTANY, use the following SQL*Plus command to find out what the current mode and role is for the database instance:
select open_mode, database_role from v$database;
The expected output is:
OPEN_MODE DATABASE_ROLE -------------------- ---------------- READ WRITE SNAPSHOT STANDBY
On BOTANY, use the following SQL*Plus command to shutdown the database instance:
shutdown immediate
The expected output is:
Database closed. Database dismounted. ORACLE instance shut down.
On BOTANY, use the following SQL*Plus command to mount the database instance:
startup mount
The expected output is:
ORACLE instance started. Total System Global Area 1258291200 bytes Fixed Size 2923920 bytes Variable Size 973079152 bytes Database Buffers 268435456 bytes Redo Buffers 13852672 bytes Database mounted.
On BOTANY, use the following SQL*Plus command to find out what the current mode and role is for the database instance:
select open_mode, database_role from v$database;
The expected output is:
OPEN_MODE DATABASE_ROLE -------------------- ---------------- MOUNTED SNAPSHOT STANDBY
On BOTANY, use the following SQL*Plus command to find out what the current mode and role is for the database instance:
ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
The expected output is:
Database altered.
On BOTANY, use the following SQL*Plus command to find out what the current mode and role is for the database instance:
select open_mode, database_role from v$database;
The expected output is:
OPEN_MODE DATABASE_ROLE -------------------- ---------------- MOUNTED PHYSICAL STANDBY