HP Application Recovery Manager software Integration guide (March 2008)

If the archive logs were backed up as files, the files can be restored before the
Application Recovery Manager restore with recovery is run. You can then select
recovery with the Use existing archive logs option in the GUI. You can
restore all archive log files, or you can check which logs are required to recover to
a certain point in time.
By querying the location of the archive logs (archive log list) and the name format
for the logs (show parameter LOG_ARCHIVE_FORMAT), you can get the filenames
of the archive logs, listed in the history of the log files (select * from
v$loghist;). By querying the time when the archive logs where used, you can
limit the selection to a certain time frame. All these queries can be performed with
the database mounted (startup mount state).
Example
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /db/oradata/ORCA/archive
Oldest online log sequence 116
Next log sequence to archive 118
Current log sequence 118
SQL> show parameter LOG_ARCHIVE_FORMAT
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s.dbf
SQL> select * from v$loghist;
THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM SWITCH_CHANGE#
---------- ---------- ------------- --------- --------------
1 100 25953200 18-FEB-07 26221532
1 101 26221532 19-FEB-07 26489797
1 102 26489797 20-FEB-07 26758039
1 103 26758039 22-FEB-07 27026185
For recovery from the backup on 19-FEB-07 to the point in time on 22-FEB-07, the
log files 1_100.dbf to 1_103.dbf are required.
Monitoring sessions
During a backup, system messages are sent to the Application Recovery Manager
monitor. You can monitor the backup session from any Application Recovery Manager
client on the network where the Application Recovery Manager User Interface is
installed.
Application Recovery Manager Oracle integration132