Q

Moving archive logs

Can I remove the archive logs from the system tablespace and place them in the directory which is actually meant for them? How?

I am new in this field, and my questions may be basic ones ... but I need to know. Actually the archive destination was not specified in the parameter file. But the archive destination (archive log list) does mention a path. We found out that the directory that should create archive logs itself was not created. I found out that the archive logs got created in the system tablespace. Can I remove the archive logs from the system tablespace and place it in the directory which is actually meant for it? If yes, how do I do it?

I'm sure that you meant that the archived redo logs are on the same disk volume as the SYSTEM tablespace. It is impossible for them to actually be in the SYSTEM tablespace.

You can move these archived redo logs to any location you want. Just make sure that your LOG_ARCHIVE_DEST parameter is pointed to this location. If you should require recovery and these logs, you can specify the new location at that time. Otherwise, I wouldn't worry about them.

Finally, keep in mind that your archived redo logs before your last backup are not needed to recover from that backup and roll forward in time. So you can remove those archived redo logs if you want.

For More Information

This was first published in August 2003
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close