> I'm running a standby database. When I do RECOVER STANDBY DATABASE, it
> for the next logfile it needs.
> I'd like to do some checking that the files exist prior to running the
> statement - so the question is, how can I tell from the database (a V$
> some sort, I guess) what logfiles are needed for the "catch-up" recovery?
> Paul Moore
The Oracle Standby Administration Manual for 8.1.6 lists in chapter 5 on
almost every page a script to retrieve that info. It is called 'Identifying
As the Oracle documentation is online at http://otn.oracle.com I recommend
you visit that site.
Of course you could also do a
select * from dict where table_name like '%RECOVERY%' and find your way
through it, but as I can't reproduce that script from memory, this is
possibly the quickest route.
Sybrand Bakker, Oracle DBA