Home » RDBMS Server » Server Administration » Standby database
Standby database [message #258766] Mon, 13 August 2007 09:45 Go to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
On a Oracle 10g,which all below given parameters needed on a standby database which is only pulling and applying archive logs from primary using script,the standby is not visible to primary as its on a private IP so no auto archive log pulling with orapwd.
This standby is used as a reporting database.



log_archive_dest_1=
log_archive_dest_2=
log_archive_dest_state_1=
log_archive_dest_state_2=
remote_login_passwordfile=
standby_archive_dest=
standby_file_management=

Report message to a moderator

Re: Standby database [message #258830 is a reply to message #258766] Mon, 13 August 2007 11:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The standby server must be visible to the primary server otherwise how can it send data (here archived logs)?
Or you use a manual standby and manually copy the archived logs as you want. In this case primary doesn't know there is a standby and parameters are the same as a standard database.

Regards
Michel

Report message to a moderator

Re: Standby database [message #258844 is a reply to message #258830] Mon, 13 August 2007 11:48 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
continue with this.
http://www.orafaq.com/forum/t/87294/105911/

Report message to a moderator

Previous Topic: SVR4 Error: 11: Resource temporarily unavailable
Next Topic: Problem with Oracle 10g (Release 1 & 2)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 20:20:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.