Home » RDBMS Server » Server Administration » Changing Archive log destination (Oracle 10g,Solaris)
Changing Archive log destination [message #344540] Sat, 30 August 2008 06:46 Go to next message
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

Re: Changing Archive log destination [message #344551 is a reply to message #344540] Sat, 30 August 2008 09:00 Go to previous messageGo to next message
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 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thank you ebrian
Previous Topic: loose my undo datafile
Next Topic: installing client 9i on serveur solaris
Goto Forum:
  


Current Time: Fri Dec 09 04:20:57 CST 2016

Total time taken to generate the page: 0.05123 seconds