How do you find out from the RMAN catalog if a particular archive log has been

How do you find out from the RMAN catalog if a particular
archive log has been backed-up?

Question Posted / narmada kumari

Answers were Sorted based on User's Feedback

How do you find out from the RMAN catalog if a particular archive log has been backed-up?..

Answer / gidhin

RMAN> list archivelog all;

Is This Answer Correct ?

32 Yes

5 No

How do you find out from the RMAN catalog if a particular archive log has been backed-up?..

Answer / narmada kumari

The database should be in ARCHIVE mode if you are going to
use RMAN as backup method.

Is This Answer Correct ?

16 Yes

13 No

More DB Administration Interview Questions

How to start SQL Server in minimal configuration mode?

what is a user-defined lock?

How to determine the service pack currently installed on SQL Server?

What is RAID and what are different types of RAID configurations?

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

Name three advisory statistics you can collect.

How would you go about verifying the network name that the local_listener is currently using?

how can you schedule a job in database?

What is the importance of a recovery model? : sql server DBA

What are the different types of indexes available in sql server? : sql server DBA

For more DB Administration Interview Questions Click Here