Backing up an Oracle Data Guard environment

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> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/DG1/archive
Oldest online log sequence 731
Next log sequence to archive 732
Current log sequence 732
On SITE oracle1, bring the database in managed recovery:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM
SESSION;
Database altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/DG1/archive
Oldest online log sequence 729
Next log sequence to archive 0
Current log sequence 732
SQL>
At this point, we have the initial setup, where oracle2 is the Primary database and oracle1 the
Standby database.
21