Home » Server Options » Data Guard » Change the location of archive file to new location for Primary DB.
icon14.gif  Change the location of archive file to new location for Primary DB. [message #240056] Thu, 24 May 2007 00:53 Go to next message
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


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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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?
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 Go to previous message
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.


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


Current Time: Fri Mar 29 09:26:54 CDT 2024