OraFAQ Forum: Unix » STANDBY in HP-Ux

Home » Infrastructure » Unix » STANDBY in HP-Ux

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

STANDBY in HP-Ux [message #244544]

Wed, 13 June 2007 04:55

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

Report message to a moderator

Re: STANDBY in HP-Ux [message #244678 is a reply to message #244544]

Wed, 13 June 2007 13:50

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;

Report message to a moderator

Previous Topic:	FTP Bounce signature
Next Topic:	Unix command help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 08:20:23 CST 2024