Home » RDBMS Server » Server Administration » archive redo logs
archive redo logs [message #166143] Tue, 04 April 2006 16:09 Go to next message
longduck
Messages: 13
Registered: November 2005
Junior Member
Hi,

We are generating massive Oracle archive logs. In the event the primary location fills up, how do I make Oracle switch to the second location. Please let me know the parameters I need to modfiy. For example, location_1 fills up, Oracle will be unable to archive the redo logs and will hang. So, I want to make Oracle switch to a different directory. I do NOT want to duplex the Oracle archives files. Thank you.

Re: archive redo logs [message #166188 is a reply to message #166143] Wed, 05 April 2006 01:42 Go to previous messageGo to next message
oradba16
Messages: 54
Registered: September 2005
Member
hi,
use the command
alter system archive log start to 'newlocation filename';

it will work....
Re: archive redo logs [message #166292 is a reply to message #166143] Wed, 05 April 2006 09:44 Go to previous message
longduck
Messages: 13
Registered: November 2005
Junior Member
That command will work but if I'm not there when the directory fills up, the database will hang. I want Oracle to automatically switch to the second directory when the first directory fills up, preventing the database from hanging if I'm not there. Thanks.
Previous Topic: oracle9i on suse linux
Next Topic: Temporary Tablespace Group
Goto Forum:
  


Current Time: Fri Sep 27 02:32:18 CDT 2024