backup standby control file
- From: Kumar Karthik <karthikeyansambandam@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 3 Dec 2012 02:36:51 +0530
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » backup standby control file - Kumar Karthik
