Database Backup and Recovery (MOSC)

MOSC Banner

Question on list backup of archivelog

Hi,

I have few questions on RMAN commands for "list backup of archivelog" backed up to tape

1) The command "list backup of archivelog from time 'sysdate-1' until time 'sysdate' device type sbt_tape; " gives me information for both nodes of RAC(1 and 2). If I have to filter this to just one thread(either thread 1 or thread 2) what is the command? I tried putting "thread 1" in between command above and gives me error

2) I want to check if any archivelog sequence missing from tape backup from sysdate-10 to sysdate. With above query "list backup of archivelog from time 'sysdate-1' until time 'sysdate' device type sbt_tape;" it gives all sequence in order. I have to go through complete output and see if any sequence is missing.

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