Skip to Main Content

Database Software

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!

How to check for archivelog backup on a particular date or time?

PradeepcmstNov 20 2013 — edited Nov 22 2013

Dear All,

We have RMAN full database, cumulative and archivelog backup(eg location: Diskgroup A) scheduled on a regular period basis. Assume archivelog location is Diskgroup B. The diskgroup B became full and unable to archive further, since no space. Unable to connect to database, connect internal only until freed error. alert log also shows that archiver error. So the solution for this to clear some space in diskgroup B by removing some old archive logs. In our environment, everyday the archive logs are stored in a separated folder arranged in date wise.  I can do that . But before clearing some space, i need to make sure that the folder( or any date folder what im going to delete) is backed up or not. How to check that? Any idea please?

eg: i have archivelogs like this in folders

01_11_2013/

02_11_2013/

03_11_2013/

04_11_2013/

05_11_2013/

06_11_2013/

If i want to remove the folder 01_11_2013/( and its contents ie archivelogs) , how to check whether the archivelogs in this folder 01_11_2013/ is backed up or not?

Regards,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2013
Added on Nov 20 2013
8 comments
11,569 views