OraFAQ Forum: Data Guard » Change the location of archive file to new location for Primary DB.

Home » Server Options » Data Guard » Change the location of archive file to new location for Primary DB.

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

Change the location of archive file to new location for Primary DB. [message #240056]

Thu, 24 May 2007 00:53

rc_ashish
Messages: 39
Registered: June 2005
Location: mumbai

Member

Hi All,

I want to Change the location of archive file to new location for Primary DB.So i want to confirm the following way,

Operating System : Unix
Oracle Version : 9.2.0.4
Standby Primary DB.
we are using spfile.

old location : /u02/0racle/procdb/archive
new location : /u04/0racle/procdb/archive

Alter system set log_archive_dest_1="LOCATION=/u04/0racle/procdb/archive" scope=both;

Is it right way or i have to follow another way.Please tell me.

Thanks in Advance.

Ashish

Report message to a moderator

Re: Change the location of archive file to new location for Primary DB. [message #240058 is a reply to message #240056]

Thu, 24 May 2007 00:56

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

wut you would do with this remaining syntax??

VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
db_unique_name=xxxxxxx’

if your DG is in running then u should have to write the whole syntax.

[Updated on: Thu, 24 May 2007 00:57]

Report message to a moderator

Re: Change the location of archive file to new location for Primary DB. [message #240064 is a reply to message #240058]

Thu, 24 May 2007 01:13

rc_ashish
Messages: 39
Registered: June 2005
Location: mumbai

Member

Hi,

Thanks for your reply...

we r using following parameter in pfile :

log_archive_dest_1='location=/u02/oracle/procdb/archive'
log_archive_format='arch_%s_PROCDB.log'
log_archive_start=true

even there is need to use other options and one more thing scope=both is valid with alter system set....... systax.

Thanks in advance.

Ashish

Report message to a moderator

Re: Change the location of archive file to new location for Primary DB. [message #240067 is a reply to message #240064]

Thu, 24 May 2007 01:18

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

we r using following parameter in pfile

your instance is running with Pfile or Spfile?

Report message to a moderator

Re: Change the location of archive file to new location for Primary DB. [message #240673 is a reply to message #240056]

Fri, 25 May 2007 08:36

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

Senior Member

The statement looks correct:
Alter system set log_archive_dest_1="LOCATION=/u04/0racle/procdb/archive" scope=both;

This takes effect with the next "alter system switch logfiles;"

You would use operating system commands to move previous archive logfiles into that directory from the old one.

Report message to a moderator

Previous Topic:	Real Time Apply -- does it apply to DG 9.2?
Next Topic:	V$STANDBY_STATUS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 22:27:27 CST 2024