- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: old archived log shown not deleted?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 02:48 PM
тАО10-30-2001 02:48 PM
old archived log shown not deleted?
I recently installed oracle NT client with dba studio and add the instances to the database tree within dba studio.
To my surprise, when I connect the db instance and check the archive log, there is a long list of archive log file showing ( several month old) and saying not deleted.
I then queried v$archive_log using sqlplus
select name, deleted from v$archived_log;
I got the same results
...
NAME
--------------------------------------------------------------------------------
DEL
---
/u01/app/oracle/admin/VCSEL/arch/T0001S0000000067.arc
NO
67 rows selected.
Here is the file I 'ls' while in directory log_archive_dest.
$ ll -a
total 112664
drwxrwxr-x 2 oracle oinstall 2048 Oct 29 13:38 .
drwxrwxr-x 8 oracle oinstall 1024 Aug 13 14:08 ..
-rw-rw---- 1 oracle oinstall 5243904 Oct 18 18:55 T0001S0000000059.arc
-rw-rw---- 1 oracle oinstall 5243904 Oct 19 11:50 T0001S0000000060.arc
-rw-rw---- 1 oracle oinstall 5243904 Oct 19 16:14 T0001S0000000061.arc
-rw-rw---- 1 oracle oinstall 5243904 Oct 20 15:00 T0001S0000000062.arc
-rw-r----- 1 oracle oinstall 5243904 Oct 21 12:00 T0001S0000000063.arc
-rw-r----- 1 oracle oinstall 5243904 Oct 22 08:00 T0001S0000000064.arc
-rw-r----- 1 oracle oinstall 5241856 Oct 23 18:28 T0001S0000000065.arc
-rw-r----- 1 oracle oinstall 5243904 Oct 24 18:30 T0001S0000000066.arc
-rw-rw---- 1 oracle oinstall 5243904 Oct 25 13:30 T0001S0000000067.arc
-rw-rw---- 1 oracle oinstall 5243904 Oct 26 16:21 T0001S0000000068.arc
-rw-r----- 1 oracle oinstall 5243904 Oct 29 13:38 T0001S0000000069.arc
Can anybody tell me why? sorry this is a long question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 06:33 PM
тАО10-30-2001 06:33 PM
Re: old archived log shown not deleted?
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 07:22 PM
тАО10-30-2001 07:22 PM
Re: old archived log shown not deleted?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 11:07 PM
тАО10-30-2001 11:07 PM
Re: old archived log shown not deleted?
I put OS command.
find
in the coldbackup script, if coldbackup succeed, the archived log before this coldbackup are deleted.
please let me know the proper way, and how do I correct the display of DBA studio and query result?
Thank you,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 11:24 PM
тАО10-30-2001 11:24 PM
Re: old archived log shown not deleted?
When Oracle run i archivelog mode it archives full redologs to an archive area. If the database crashes and needs to be recovered Oracle uses the redoinformation stored in the redologs to redo changes applied to the database after the last update of the datafiles (on checkpoint). If the information on the redologs are filling fast or the recovery needs old data, there is a need for using the archived redologs.
These files are expected by Oracle to be found at the archive area, and are kept trackof by the data dictionary.
If you moved / delete archived redologs, there is no way Oracle can sense this and belives that this data still is in place. Upon an recovery session later, Oracle will check archive location for these files.
If using RMAN or other Oracle compatible backup utility to backup and delete these files, Oracle is informed of the action taken by RMAN and the files is marked as deleted.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2001 11:44 PM
тАО10-30-2001 11:44 PM
Re: old archived log shown not deleted?
If you have RMAN available you can cleanup in these entries by typing the following at the RMAN prompt after using OS command to delete:
RMAN> change archivelog all crosscheck;
From until 8.1.5 this markes deleted logs as deleted, and of 8.1.6 removes the entry.
Otherwise the these entries are stuck until the MAXLOGHISTORY parameter is reached, the info is then overwritten in the controlfile (not Data Dictionary as I wrote earlier)
You might recreate the controlfile to get rid of these, but that would be like shooting sparrows with a stinger missile.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2001 02:09 PM
тАО10-31-2001 02:09 PM
Re: old archived log shown not deleted?
Thank for the explanation.
I am not using rman to do the backup and recovery, and planning to set it up very soon after I am clear about the rman compatibility matrix.
I will deal with it later using rman.
Regards,