cancel
Showing results for 
Search instead for 
Did you mean: 

change Archive log file destination

Former Member
0 Kudos

hi

I install ECC 6.0. By mistake while installation the destination of archive log file was pen hard disk. When i was removing pen HDD & try to start server it will get the problem. So tell me how to change the destination of the log file so that my server will start properly.

Thanks

Atul Amrutkar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Please change path in spfile<SID>.ora you an do it manually.

Regards

Sachin Sonawane

Former Member
0 Kudos

We should not change SPfile manually ... misleading info

Answers (3)

Answers (3)

Former Member
0 Kudos

very helpful

Former Member
0 Kudos

Atul,

As you are not able to start oracle you may want to mount the database, switch off the archive log and then open it. Once you are able to open database you may want to change the destination parameters as suggested.

You may want to use following sequence of commands:

SQL> Shutdown normal/immediate

SQL> startup mount

SQL> Alter database noarchivelog;

SQL> Alter database open;

Alternatively you can comment/modify destinations in initialization parameter files.

Hope this helps.

Manoj

Former Member
0 Kudos

Hello,

change the parameter log_archive_dest_1 to a valid directory.

Example:

SQL> alter system set log_archive_dest_1='LOCATION=/oracle/<SID>/oraarch/<SID>arch' scope=spfile;

SQL> shutdown

SQL> startup

SQL> show parameter log_archive_dest_1;

If you have still parameter log_archive_dest set, please remove it, before setting the new one:

SQL> alter system reset log_archive_dest scope=spfile sid='*';

Greetings

Christian