OraFAQ Forum: Data Guard » problem in achive log destination -2 after switchover

Home » Server Options » Data Guard » problem in achive log destination -2 after switchover

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

problem in achive log destination -2 after switchover [message #288572]

Tue, 18 December 2007 01:12

pankajkmeena
Messages: 46
Registered: September 2007

Member

ORACLE 9i -- winXP
=============
primart database parameter

*.log_archive_dest_1='LOCATION=F:\oracle\ARCHIVE\PROD1'
*.log_archive_dest_2='SERVICE=PROD1_S mandatory reopen=20'

standby database parameter

*.log_archive_dest_1='LOCATION=F:\oracle\ARCHIVE\PROD1'
*.log_archive_dest_2='SERVICE=PROD1_P mandatory reopen=20 '

Before switchover logs are transported from primary to standy log_archive_dest_1 location

After switchover achived redo logs generated by New primary database are transfered to F:\oracle\ora92\rdbms location instead of log_archive_dest_1 of new standby database location
Any Help ???? Sad

Report message to a moderator

Re: problem in achive log destination -2 after switchover [message #288762 is a reply to message #288572]

Tue, 18 December 2007 10:55

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Disable archiving and reset the parameter and enable the archiving.

Report message to a moderator

Re: problem in achive log destination -2 after switchover [message #289176 is a reply to message #288762]

Wed, 19 December 2007 23:50

pankajkmeena
Messages: 46
Registered: September 2007

Member

Thankx for ur suggesitions.

But I am bit confused . can u plz let me know abt

1) in Oracle 9i i have created standby redo log file in primary site (as per documnet in earlier posts).Will i have to create it in standby site also.

[Updated on: Thu, 20 December 2007 04:03]

Report message to a moderator

Re: problem in achive log destination -2 after switchover [message #289297 is a reply to message #289176]

Thu, 20 December 2007 10:41

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Actually SRL's are neceassry for REAL TIME DG not for normal..

If you dont create SRL's in 9i its ok .No problem with that.

Report message to a moderator

Previous Topic:	importance of standby_archive_dest in dataguard/Real time log application in Oracle9i
Next Topic:	Primary/Logical/Physical

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 02:16:05 CST 2024