Redolog archives - how to check the number ?

[Former Member]

Hello,

I need to check the numbers of redologs archived in the last 12 months , by week and month .

Is that plossible to be checked ?

Thanks in advance,

Daniel

[former_member188883 · Accepted solution]

Hi Daniel,

Using RMAN you can very well do it. Steps are as below

1) Start RMAN and connect to the target database and, optionally, the recovery catalog database. For example, enter:

% rman target / catalog rman/rman@rcvcat

2) Use list command to get a list of archived redo logs. For example.

list copy of archivelog completed between '10-DEC-1998' and '17-DEC-1998';

Regards,

Deepak Kori

[Former Member]

Evaluate the alert_SID.log or the /oracle/SID/saparch/archSID.log.

Cheers Michael