Backing up an Oracle Data Guard environment

After the file restore, the payroll.dbf datafile has an SCN number, which is lower than the

Database SCN number as seen in the alert logfile:

Wed May 11 17:50:23 2005

Full restore complete of datafile 6 /oradata/DG1/payroll01.dbf

checkpoint is 3519499

If we query the actual SCN number of the database:

SQL> select CURRENT_SCN from v$database;

CURRENT_SCN

-----------

3539521

After restarting the redo apply on the standby, we can see that file 6 has been successfully

recovered:

SQL> select file#,CHECKPOINT_CHANGE# from v$datafile;

FILE# CHECKPOINT_CHANGE#

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

1 3544336

2 3544336

3 3544336

4 3544336

5 3544336

6 3544336

6 rows selected.

SQL>