System Administrator’s Guide U42252-J-Z915-1-76
Recovery Performing a recovery
5.2.1 Automatic Recovery for an Optional Point in Time
This section documents the use of the ora_recut command with the aid of which
you can automatically recover a specific database level (recovery until time).
In order to recover a specific database level you can use the following
command:
ora_recut [<ORA-SID>] [-t <time>] [-v]
The ORACLE ID <ORA-SID> only needs to be specified if there is more than one
database. If the -t option is used to define a point in time (format yyyy-mm-
dd:hh:mm:ss,i.e., for instance: 1997-11-27:22:00:00) the ora_recut command
will attempt to roll back the database to precisely that moment. If you do not
enter a time here, then ora_recut will prompt you for a time presently. The -v
option enables the output of additional information.
The following prerequisites must be met so that ora_recut can be used:
●The database must be physically sound (operable) because ora_recut needs
to query the position of the control files.
●All the servers and device servers used for the backups have to be active.
●The last full recovery made before the required point in time using
${ORACLE_SID}_full_save has to have run under Version 3.0 of NSR-ORA or
higher.
If OPS is being used, you must pay attention to some further prerequisites (see
section “Recovery with ORACLE Parallel Server (OPS)” for further information).
With the automatic recover until time you cannot use backups which are
distributed on several days of the week.
In order to restore a specific database level with these prerequisites you must
carry out the following steps:
1. Specify the time.
2. Start ora_recut:
# ora_recut [<ORA-ID>] [-t <time>]
If ora_recut requires further information, you will be prompted to enter it.
Basically ora_recut runs fully automatically. Only if errors occur that ora_recut
cannot solve on its own, does an error message appear and you are
informed that you can attempt to solve the problem yourself, for instance:
The database hadn’t gone down in 5 m inutes
!