OraFAQ Forum: Server Administration » Changing Archive log destination

Home » RDBMS Server » Server Administration » Changing Archive log destination (Oracle 10g,Solaris)

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

Changing Archive log destination [message #344540]

Sat, 30 August 2008 06:46

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

here are some steps to change the archivelog destination Using spfile .

Please correct me if i am wrong somewhere.

alter system set log_archive_dest_1='location=/tmp' ;

shu
startup

can anybody tell me, do i need to backup my old archivelogs to new destiantion before changing destination?

Regards,
Balaji

Report message to a moderator

Re: Changing Archive log destination [message #344551 is a reply to message #344540]

Sat, 30 August 2008 09:00

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Changing the archive log location is a dynamic procedure, no restart is required.

You need to backup your old archive log destination for backup & recovery purposes.

[Updated on: Sat, 30 August 2008 09:01]

Report message to a moderator

Re: Changing Archive log destination [message #344559 is a reply to message #344551]

Sat, 30 August 2008 10:22

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thank you ebrian

Report message to a moderator

Previous Topic:	loose my undo datafile
Next Topic:	installing client 9i on serveur solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 22:15:14 CST 2024