Database Backup and Recovery (MOSC)

MOSC Banner

Location of Archive Log Files.

edited Nov 18, 2013 6:40AM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓
After setting the flash recovery area, Do I Need to manually change the location of archive log file, 

SQL> show parameter archive

log_archive_dest_1                   string      LOCATION=/u01/oracle/CRP/db/ap

In the FRA setup I have done 

 ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u01/oracle/CRP/fra' SCOPE=BOTH SID='CRP';

 ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='CRP';

What I was expecting that Archive logs will move in the directory which I have setup in the FRA, but still its doin 
in the previous location,., any idea how to move the newly generated archive log files in the Flash Recovery Area

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center