Home » Server Options » Data Guard » problem in achive log destination -2 after switchover
problem in achive log destination -2 after switchover [message #288572] Tue, 18 December 2007 01:12 Go to next message
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
Re: problem in achive log destination -2 after switchover [message #288762 is a reply to message #288572] Tue, 18 December 2007 10:55 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Disable archiving and reset the parameter and enable the archiving.
Re: problem in achive log destination -2 after switchover [message #289176 is a reply to message #288762] Wed, 19 December 2007 23:50 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: importance of standby_archive_dest in dataguard/Real time log application in Oracle9i
Next Topic: Primary/Logical/Physical
Goto Forum:
  


Current Time: Thu Mar 28 11:57:23 CDT 2024