on 12-29-2009 12:17 PM
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
Please change path in spfile<SID>.ora you an do it manually.
Regards
Sachin Sonawane
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
very helpful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.