OraFAQ Forum: Server Administration » How to set NULL on LOG_ARCHIVE_DEST

Home » RDBMS Server » Server Administration » How to set NULL on LOG_ARCHIVE_DEST_N (Oracle, 11g R2, solaris 5.10)

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

How to set NULL on LOG_ARCHIVE_DEST_N [message #625061]

Wed, 01 October 2014 00:48

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

Hello,

I want delete path of "LOG_ARCHIVE_DEST_1" on database. How to do it?


select dest_name, destination
from v$archive_dest
where status='VALID'

result:
DEST_NAME	DESTINATION
LOG_ARCHIVE_DEST_1	/u01/app/oracle/product/11.2.0/db_1/dbs/arch
LOG_ARCHIVE_DEST_3	/bkp/archive2

[Updated on: Wed, 01 October 2014 00:54]

Report message to a moderator

Re: How to set NULL on LOG_ARCHIVE_DEST_N [message #625063 is a reply to message #625061]

Wed, 01 October 2014 01:19

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends if you started from a pfile or spfile.
For the former, remove the line from the file.
For the latter, "alter system reset log_archive_dest_1"

Report message to a moderator

Re: How to set NULL on LOG_ARCHIVE_DEST_N [message #625064 is a reply to message #625063]

Wed, 01 October 2014 01:26

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

I works on RAC environment. May I do one node or all nodes?
Do I disable archive log mode before do it?

Report message to a moderator

Re: How to set NULL on LOG_ARCHIVE_DEST_N [message #625069 is a reply to message #625064]

Wed, 01 October 2014 02:09

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

I did below command then fixed.

alter system set LOG_ARCHIVE_DEST_1='';

Report message to a moderator

Re: How to set NULL on LOG_ARCHIVE_DEST_N [message #625070 is a reply to message #625064]

Wed, 01 October 2014 02:28

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Tlg13team wrote on Wed, 01 October 2014 08:26

I works on RAC environment. May I do one node or all nodes?
Do I disable archive log mode before do it?

For all nodes:
alter system reset log_archive_dest_1 sid='*';

You still didn't tell us if you work with a pfile or a spfile.

Quote:

I did below command then fixed.

Setting to null or resetting parameter is not the same thing.
Setting to null is OK to fix the problem in the current instances (without restarting them).

Report message to a moderator

Previous Topic:	Which is better for a lot of sessions in oracle database?
Next Topic:	Actual Database Size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:41:43 CST 2024