Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Relocate Archive logs

792290Apr 5 2017 — edited Apr 8 2017

Hi,

Oracle 11gR2 database,  the archive logs were going to wrong directory, even though log_archive_dest_1 set, because the arc directory did not exist on the server when database was created so they were going to \u01\oradata\test directory.  so i need to move all these archive logs to new location from \u01\oradata\ test to u01\oradata\test\arc directory.

moved all the archive logs files from \u01\oradata\test TO u01\oradata\test\arc this location.  after moving these files do we need to register these archive logs with new location?

new archive logs are created in the new location per log_archive_dest_1.  but the old logs that moved were still showing \u01\oradata\test in this location when query the v$archive_log.

what step am i missing?

Any help is appreciated.

Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2017
Added on Apr 5 2017
32 comments
4,728 views