Data Guard Physical standby 9i archive log registration

  • From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 1 Nov 2007 19:25:22 -0400

Hi List,
I am maintaining above mentioned database.
We will switch to automactic archive log transfer (
log_archive_dest_state_2 = ENABLE ).
Until that happens archive logs are transferred using OS command and
"recover automatic standby database parallel 44" command runs.
Once applied,  logs are ( also manually ) registered.
Is archive log registration a must for proper functioning ( if we want
failover later, switchover etc ) ?
Some logs were deleted before registered ( so they are applied, just
not registered ).
Do we have to restore those logs from tape, or we could safely skip
this step all together ( contrary to what manuals say ) ?
Can we just create dummy arch log files and register those ? Does
Oracle do any checks on file contents, or this is mere formality and
any file with proper name will do ?

Ranko Mosic
Consultant Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr@xxxxxxxxxx

Other related posts: