Backing up an Oracle Data Guard environment

SQL> select PROTECTION_MODE, SWITCHOVER_STATUS from v$database;

PROTECTION_MODE SWITCHOVER_STATUS

--------------- ------------------

MAXIMUM AVAILABILITY TO STANDBY

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 536870912 bytes

Fixed Size 1310536 bytes

Variable Size 157548728 bytes

Database Buffers 377487360 bytes

Redo Buffers 524288 bytes

Database mounted.

SQL> alter database set standby to maximize availability;

Database altered.

SQL> alter database open;

Database altered.

SQL>

To initiate the switchover, on the primary (SITE oracle1) perform a switchover to physical

standby

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;

Database altered.

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 536870912 bytes

Fixed Size 1310536 bytes

Variable Size 157548728 bytes

Database Buffers 377487360 bytes

Redo Buffers 524288 bytes

Database mounted.

SQL>

On SITE oracle2, the standby site:

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS

--------------------

TO PRIMARY

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.

SQL> shutdown immediate;

ORA-01507: database not mounted