OraFAQ Forum: Server Administration » changing archive log destination

Home » RDBMS Server » Server Administration » changing archive log destination (Oracle 10g R2/ Solaris 10)

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

changing archive log destination [message #514841]

Wed, 06 July 2011 20:04

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Good day!

Just to validate from you experts if in case I change the destination file of my archive logs, does it require a restart of the database?

Thank you in advance.

Report message to a moderator

Re: changing archive log destination [message #514843 is a reply to message #514841]

Wed, 06 July 2011 20:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Just to validate from you experts if in case I change the destination file of my archive logs, does it require a restart of the database?

What prevents you from testing it yourself?

Report message to a moderator

Re: changing archive log destination [message #514845 is a reply to message #514843]

Wed, 06 July 2011 21:00

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Sir, I'm referring to a production server.

I just read from some forums that this does not require a restart.

Thanks.

Report message to a moderator

Re: changing archive log destination [message #514846 is a reply to message #514845]

Wed, 06 July 2011 21:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Sir, I'm referring to a production server.
Surely you have a TEST DB upon which you can run a simple test

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: changing archive log destination [message #514847 is a reply to message #514846]

Wed, 06 July 2011 21:23

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

I'm sorry to tell you Sir in our case, we don't have yet.
We had for 9i, 8i & 7... I would not post it anyway,
if we can test it.

This production server was once maintained by our outsourcer.
It was turned-over to us 2 years ago where the setting of
it's archive log is via FLASH_RECOVERY_AREA.

Thanks.

Report message to a moderator

Re: changing archive log destination [message #514848 is a reply to message #514847]

Wed, 06 July 2011 21:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>It was turned-over to us 2 years ago
Does this mean that no changes have been made on this system since then?

Report message to a moderator

Re: changing archive log destination [message #514849 is a reply to message #514848]

Wed, 06 July 2011 21:38

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Unfortunately yes. It was not properly turned-over to
us, and no good documentations at all.

Please give me the answer for my post, does it require a restart or not.

Thank you.

Report message to a moderator

Re: changing archive log destination [message #514851 is a reply to message #514849]

Wed, 06 July 2011 22:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> desc v$parameter
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 NUM						    NUMBER
 NAME						    VARCHAR2(80)
 TYPE						    NUMBER
 VALUE						    VARCHAR2(4000)
 DISPLAY_VALUE					    VARCHAR2(4000)
 ISDEFAULT					    VARCHAR2(9)
 ISSES_MODIFIABLE				    VARCHAR2(5)
 ISSYS_MODIFIABLE				    VARCHAR2(9)
 ISINSTANCE_MODIFIABLE				    VARCHAR2(5)
 ISMODIFIED					    VARCHAR2(10)
 ISADJUSTED					    VARCHAR2(5)
 ISDEPRECATED					    VARCHAR2(5)
 ISBASIC					    VARCHAR2(5)
 DESCRIPTION					    VARCHAR2(255)
 UPDATE_COMMENT 				    VARCHAR2(255)
 HASH						    NUMBER

Report message to a moderator

Re: changing archive log destination [message #514862 is a reply to message #514841]

Thu, 07 July 2011 00:58

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

All parameters are described in Database Reference, check with the one of your version.

Regards
Michel

Report message to a moderator

Re: changing archive log destination [message #514866 is a reply to message #514849]

Thu, 07 July 2011 01:25

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

I understand why you would like some re-assurance before attempting to make untested changes on a production system. Do not worry: you can issue the appropriate ALTER SYSTEM commands while the system is running.

But the commands may not work. I do not have a 10g database, so I can't test, but when doing this with 11g recently I did find some problems with Standard Edition. I can't remember the details, but I think that if you are using Enterprise Edition, you can change from the FRA to log_archive_Dest_n no problem; but SE didn't let me change from FRA to log_archive_dest and log_archive_duplex_dest.

Try it - you will not crash the database.

Report message to a moderator

Re: changing archive log destination [message #515398 is a reply to message #514841]

Mon, 11 July 2011 06:34

raj9999
Messages: 49
Registered: June 2011

Member

Reym21,

You doesnt need a restart for changing the destination file of your archive logs.
You can do it easily with "alter system set" command.

Report message to a moderator

Previous Topic:	rebuild index and recreate them
Next Topic:	Unable to use more than 2GB memory for Oracle in Windows 2003

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 10:03:34 CDT 2024