Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
Title: v$archived_log
Brad
Posted: Mar 30, 2004 12:33:27 PM
Total Post: 1
Joined: Mar, 2004
i have a perl script that removes week-old archives logs physically from the disk. however, when i query the v$archived_log view, all of the archive logs that have been physically removed are still seen in the view. i read that the control_file_record_keep_time is supposed to manage the contents of the control file. in my case, this parameter is set to the default of 7 days. i have also read that the 'DELETED' column in the v$archived_log view is set to 'YES' if an RMAN delete command has been issued--i'm guessing that this does not apply to archive logs that have been removed from the OS level. how can i maintain the view to be up-to-date after an archive log is removed? thx
Steve
Posted: Dec 27, 2004 09:50:45 PM
Total Post: 8
Joined: Nov, 2004
Looks like the v$archive_log view works together with RMAN.
Using RMAN if you run DELETE ARCHIVELOG
Steve
