OraFAQ Forum: Data Guard » Automatic Archiving in DG 9 rel 2

Home » Server Options » Data Guard » Automatic Archiving in DG 9 rel 2

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

Automatic Archiving in DG 9 rel 2 [message #235005]

Thu, 03 May 2007 13:23

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

It's confusing that the database must be configured to use a Server Parameter File (spfile), yet the parameter "LOG_ARCHIVE_START" cannot be set in an spfile, only in a text Initialization Parameter File (pfile). How do you set automatic archiving when you're using a spfile without scripting it somewhere?

Report message to a moderator

Re: Automatic Archiving in DG 9 rel 2 [message #235141 is a reply to message #235005]

Fri, 04 May 2007 03:06

orasupport
Messages: 11
Registered: May 2007

Junior Member

You can set the LOG_ARCHIVE_START in SPFILE also.

ALTER SYSTEM SET LOG_ARCHIVE_START=TRUE SCOPE=SPFILE;
and
Bounce the instance.

Report message to a moderator

Re: Automatic Archiving in DG 9 rel 2 [message #235249 is a reply to message #235141]

Fri, 04 May 2007 09:01

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

Thanks! My confusion arose from an entry in the Online Data Guard Concepts and Administration Handbook, Parameters section at:

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96653/init_params.htm#78605

where it explicitly states "You cannot specify this parameter in a server parameter file." Glad to see you can.

Report message to a moderator

Previous Topic:	urgent:dataguard unable to apply logs
Next Topic:	Port usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 30 06:44:28 CDT 2025