Backing up an Oracle Data Guard environment

oracle@oracle2[DG1]:/oradata/DG1$ sqlplus " /as sysdba"

SQL*Plus: Release 10.1.0.3.0 - Production on Wed May 4 07:54:13 2005

Connected to:

Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production

With the Partitioning and Data Mining options

SQL> select DATABASE_ROLE from v$database;

DATABASE_ROLE

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

PHYSICAL STANDBY

Before setting the new standby in recovery mode, we need to recreate the standby redo logs

(only for 10g databases running in maximum protection and maximum availability):

SQL> alter database add standby logfile '/oradata/DG1/stbredo1.log' size 10m;

Database altered.

SQL> alter database add standby logfile '/oradata/DG1/stbredo2.log' size 10m;

Database altered.

SQL> alter database add standby logfile '/oradata/DG1/stbredo3.log' size 10m;

Database altered.

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_

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

3 ONLINE /oradata/DG1/redo03.log NO

2 ONLINE /oradata/DG1/redo02.log NO

1 ONLINE /oradata/DG1/redo01.log NO

4 STANDBY /oradata/DG1/stbredo1.log NO

5 STANDBY /oradata/DG1/stbredo2.log NO

6 STANDBY /oradata/DG1/stbredo3.log NO

6 rows selected.

SQL>

Before the failover was performed, our Data Guard setup was running in maximum availability

mode (see data guard documentation). We need to set the new primary in this mode:

SQL> select PROTECTION_MODE, SWITCHOVER_STATUS from v$database;

PROTECTION_MODE SWITCHOVER_STATUS

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

MAXIMUM PERFORMANCE TO STANDBY

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.