backup standby control file

From: Kumar Karthik <karthikeyansambandam_at_gmail.com>
Date: Mon, 3 Dec 2012 02:36:51 +0530
Message-ID: <CAPW7_1GwNAe_oWcaG=CDaMOTUf6DZ=ao+PC0q8Bm2N6iqkMfsA_at_mail.gmail.com>

Hi All,
I am trying to practice physical standby database setup in 10.2.0.4/linux64 bit. The standby is set to run on max performance mode,and it performs
well. But i have a question on the sequence of creating standby controlfile and database full backup(hot backup)

Scenario-1
Take standby controlfile backup via rman/do some transactions/take a full database backup with the command when the sequence moves

 backup full database format '/oradata/db101/backup/%d_%U.bckp' plus archivelog format '/oradata/db101/backup/%d_%U.bckp';

At this point i thought, the controlfile will not be aware of the backup taken(no catalog db) and the restore will fail,but it did worked

DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK; The standby archive log list shows as follow

SQL> archive log list

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /oradata/db101/arch
Oldest online log sequence     173
Next log sequence to archive   0---it becomes zero
Current log sequence           186

Scenario-2
Same as above,only that i backup the standby controlfile after the backup of database. It works as expected and infact the "next log sequence to archive" is shown correctly

QL> archive log list

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /oradata/db101/arch
Oldest online log sequence     187
Next log sequence to archive   189
Current log sequence           189

1,Now my question is, when both the methods work without any problem, which is the right way to do?
2,I strongly believe #2 is correct, as it will be having information on archivelogs generated latest, but how option 1 was aware of the backup taken after standby Controlfile creation?

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Dec 02 2012 - 22:06:51 CET