Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Data Guard Physical standby 9i archive log registration

Data Guard Physical standby 9i archive log registration

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Thu, 1 Nov 2007 19:25:22 -0400
Message-ID: <367369f10711011625l7d256e97x57907e71e3b71229@mail.gmail.com>


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. Question:
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 ?

-- 
Regards,
Ranko Mosic
Consultant Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 01 2007 - 18:25:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US