Home » Infrastructure » Unix » STANDBY in HP-Ux
STANDBY in HP-Ux [message #244544] Wed, 13 June 2007 04:55 Go to next message
miraijaz
Messages: 15
Registered: October 2006
Junior Member
hi all,

we are on HP-UX platform with SAP erp application. At present we have one standby database where we copy archive log from primary twice in a day and then apply these archives to the standby database. the archive list of the two databases is as follows

on standby
--------------------
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/PRD/saparch/PRDarch
Oldest online log sequence 40944
Next log sequence to archive 40947
Current log sequence 40947

on Primary
-------------------
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/PRD/saparch
Oldest online log sequence 61370
Next log sequence to archive 61372
Current log sequence 61372



QUESTIONS

1. archive destination on standby (shown above) does not exist. we copy files to " /oracle/PRD/saparch". Will they be still applied?
2. even the log seqence v$log return different output. alert log file on standby shows that file has been applied
(Wed Jun 13 09:48:13 2007 Media Recovery Log /oracle/PRD/saparch/PRDarch1_61370.dbf)


help will be highly appreciated


Thanks and Regards,
Aijaz
Re: STANDBY in HP-Ux [message #244678 is a reply to message #244544] Wed, 13 June 2007 13:50 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
it depends on your this parameter
Log_archive_dest_2=’Service=to_primary
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
db_unique_name=primary’


Does your primary generates 2 copies 1 on primary and 1 on standby i guess not .

did you check this
•	SQL> Select Status, Error 
from v$Archive_dest 
where dest_id=2;


it should be VALID.

Quote:
1. archive destination on standby (shown above) does not exist. we copy files to " /oracle/PRD/saparch". Will they be still applied?


check this by this querry weather they are applying or not.

•	SQL> Select Name, Applied, Archived
from v$Archived_log;
Previous Topic: FTP Bounce signature
Next Topic: Unix command help
Goto Forum:
  


Current Time: Fri Mar 29 10:54:58 CDT 2024