Changing directory of Archive Logs

[Former Member]

Hi folks,

We have Solution Manager 4.0 running on Oracle 10.2.0.2. There is a need to change oraarch from its present directory to another location. How can one do this with Brtools? What other options are also available to do this?

Thanks in anticipation.

Edited by: Akintunde Olorunsola on Sep 18, 2008 6:54 PM

[stefan_koehler · Accepted solution]

Hello,

if you have set all parameters like described in sapnote #830576.

Then you have only to change the parameter LOG_ARCHIVE_DEST_1.

>SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=<NEW_FOLDER>' scope=spfile;

After a database restart the new location is active.. there are also some dynamic solutions .. but this is the easiest one to explain.

Regards

Stefan

[Former Member · Accepted solution]

Thanks for your response.

I executed the command: SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=' scope=spfile; . On restarting the database I get this error: 0RA-16019 cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST. And Oracle is no longer available.

How can I revert?

Regards

Edited by: Akintunde Olorunsola on Sep 19, 2008 9:45 AM

[stefan_koehler · Accepted solution]

Hello,

just unset the parameters LOG_ARCHIVE_DEST and / or LOG_ARCHIVE_DUPLEX_DEST.

>SQL> alter system reset LOG_ARCHIVE_DEST scope=spfile;

>SQL> alter system reset LOG_ARCHIVE_DUPLEX_DEST scope=spfile;

Your database is not configured like described in sapnote #830576... that is the reason why you get this error.

Regards

Stefan

[Former Member · Accepted solution]

Thanks Stefan for your prompt feedback.

When i try to do this:

SQL> alter system reset LOG_ARCHIVE_DEST scope=spfile;

SQL> alter system reset LOG_ARCHIVE_DUPLEX_DEST scope=spfile;

I get ORA-01034: Oracle not available.

Other ideas, please?

[Former Member · Accepted solution]

Try to startup the instance first:

SQL> startup nomount

Then set the parameter as suggested, then shutdown, startup again.

Regards

Michael

[Former Member · Accepted solution]

Thanks Stefan and Michael for your contributions. After trying your suggestions and others and the database still did not come up, I took the decision to start the installation all over again. And should be fine now.

Cheers.

AKT.