Backing up an Oracle Data Guard environment

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>
We can now set the standby database in recovery mode:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM
SESSION;
Database altered.
To verify the standby is receiving the redo information from the primary, perform the
following on the actual primary (SITE oracle1):
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/DG1/archive
Oldest online log sequence 724
Next log sequence to archive 725
Current log sequence 725
SQL> alter system archive log current;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/DG1/archive
Oldest online log sequence 724
Next log sequence to archive 726
Current log sequence 726
Now, on the standby (SITE oracle2):
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/DG1/archive
Oldest online log sequence 722
Next log sequence to archive 0
Current log sequence 726
To bring both sites to the role they had before the site failover, we need to perform a
switchover, where SITE oracle2 will become primary and SITE oracle1 standby;
As done previously after the failover, we need to set the primary in maximum availability
mode:
19