The ca_restore command includes the following Oracle RMAN database options:
ca_restore -use_rmancat
[-rman_catdbname <rman_catdbname>] [-rman_catuser <RMan Catalog User>] [-rman_catpassword <RMan Catalog Password>]
ca_restore [-put_online] ca_restore [-oracle_controlfile] ca_restore [-listbakset] ca_restore [-rman_archlogsel
al_all | al_pattern [-rman_alpattern <Archive Log Pattern>] | al_time [-rman_alfromtime <Archive Log From Time>] [-rman_aluntiltime <Archive Log Until Time>] | al_scn [-rman_alfromscn <Archive Log From SCN>] [-rman_aluntilscn <Archive Log Until SCN>] | al_logseq [-rman_alfromlogseq <Archive Log From Sequence>] [-rman_aluntillogseq <Archive Log Until Sequence>] [-rman_althread <Archive Log Number of Threads>] | al_none]
ca_restore [-rman_script <RMan Script>] ca_restore [-rman_numberofchannels <Number of Channels>] ca_restore [-rman_blocksize <Block Size (Bytes)>] ca_restore [-rman_baksetnum <Validate Backup Set Number>] ca_restore [-rman_restoremethod
rm_lastbackup | rm_time [-rman_restoretime <Restore From Backup Made On (Date/Time)>] | rm_tag -rman_baktag <RMan Backup Tag> ]
ca_restore [-rman_recoverytype
rec_norec | rec_untilendoflogs | rec_untilscn [-rman_recoveruntilscn <Until SCN>] | rec_untillogseq [-rman_recoveruntilseq <Until Log Sequence>] [-rman_recthread <Recovery Thread Number>] | rec_untiltime [-rman_recoveruntiltime <Until Time>]]
Note: The ca_restore database options are described in a separate topic titled "Database Options" and can be viewed from the actual CLI by entering the following command: ca_restore allusage.
Note: When using the Arcserve Backup CLI (command line interface) to back up or restore an Oracle object with a DBCS (double-byte character set) or a MBCS (multi-byte character set) in the name, you must ensure the Arcserve Backup server and the agent box have the same language setting.
Note: If the Oracle instance name and the database name are different, the -database options should be "-database ORACLERMAN [instance name@database name]" instead of "-database ORACLERMAN [database name]".
Specifies to use a catalog (recommended). Indicates if an RMAN catalog is to be used for the operation or not. It is always recommended to use one because RMAN will use the database control file if no catalog is to be used. The loss of this control file will prevent RMAN from restoring the database.
This switch is used to include the catalog database name when you attempt to run a Oracle RMAN ca_restore job with a Recovery Catalog Database.
Default: Empty
Specifies the name of the Oracle user who owns the RMAN catalog.
Specifies the password for that user that owns the RMAN catalog.
Specifies to RMAN that the Oracle objects restored should be put online after the recovery is performed.
Specifies that the control file should be restored.
Specifies to list all backup sets that include the objects selected in the source node.
The “Archived Logs Selection” section of this panel allows the user to select which archived logs will be restored, assuming that the “archived logs” object has been included in the Source panel of the Restore Manager GUI. The selection is represented by radio button options. All indicates that all archived logs will be backed up.
Default: All
String pattern used to select the archived logs based on their name.
Use this option to indicate that the archived logs to be restored will be selected based on the time they were created. This field determines the lower time boundary for the archived logs selection. Only the archived logs created after this time will be restored.
Use this option to indicate that the archived logs to be restored will be selected based on the time they were created. This field determines the upper time boundary for the archived logs selection. Only the archived logs created before this time will be restored.
Use this option to indicate that the range of the archived logs to be restored is not determined by the time, rather by the SCN (System Change Number). This field indicates the lowest SCN boundary for the archived logs selection. It can be left empty, assuming that the Until SCN field is not.
Use this option to indicate that the range of the archived logs to be restored is not determined by the time, rather by the SCN (System Change Number). This field is used to determine the upper SCN boundary to the archived logs selection. It is optional, as long as the user has entered a value for the From SCN field.
Use this option to specify that archived logs selection is to be based on the archived log sequence number. This field corresponds to the lowest log sequence number used to determine which archived logs will be restored. This field can be left empty only if a value is provided for the Until Log Sequence one.
Use this option to indicate that the archived logs selection is to be based on the archived log sequence number. This field is used to enter the upper archived log sequence number boundary for the archived logs selection. Providing a value for this field is optional, as long as the user enters a value in the From Log Sequence field.
Use this option to specify the thread number used to identify the Oracle server that generated the archived logs. This parameter is only used with the Time Based, SCN Based or Log Sequence Based options described below. It will be ignored if the All or Pattern Based option is used.
Default: 1
Note: This value is only useful for OPS (Oracle Parallel Server, for Oracle 8 and 8i) or RAC (Real Application Clusters, for Oracle 9i and 10g), otherwise the thread number is always one.
Use this option to enter the path of an RMAN script. Providing a value for this field will cause the Oracle agent to ignore all other options that might have been entered by the user in the GUI. The script will be passed as is to RMAN and the Oracle agent will perform the restore operation normally.
Use this option to specify how many channels to be allocated by RMAN to perform the restore operation. RMAN will submit jobs in parallel, one for each channel.
Default: 1 channel
Use this option to specify a value that determines the size of the data blocks that RMAN will send to the Oracle agent when performing a restore. This field should be left empty by default. If the user enters a value for it during backup, then the same block size must also be entered by the user when he wants to restore. Otherwise, RMAN will produce an error message indicating that there is a mismatch between the backup block size and the restore one. In that case, the value used during the backup will be put in the error message. If no value is provided, then RMAN uses 64 KB for Oracle 8 or 8i and 256 KB for Oracle 9i.
This parameter does not exist anymore with Oracle 10g.
Default: Empty
Specifies to make sure that the copy of the data on the tape is valid and could be restored, if necessary. RMAN will not actually restore the data from this command.
The backup set number required can be obtained by connecting to RMAN in its environment and issuing the 'list backupset' command. The backup set number can also be obtained from the results of executing the -listbakset option in ca_restore command and view the available backup set information.
Specifies to perform a data restore based on the method to be performed.
Specifies that RMAN should attempt to restore the data from the latest backup.
Specifies which sets RMAN will use to get the data from, based on the specified date and time.
Specifies that RMAN should attempt to restore the data according to the specified Tag. If you specified a backup Tag during the actual backup, you can then restore the data using Tag name.
Specifies to perform a data recovery based on the type of recovery to be performed.
The switch indicates that no recovery should be performed by RMAN after the data has been restored.
Specifies to RMAN to recover the data as close as possible to the present time, until the end of the current logs.
Specifies to RMAN to perform the recovery until the specified System Change Number (SCN) value.
Specifies to perform the recovery on the entire database up to the point in time represented by the specified archived log sequence. This is the archived log that indicates where the recovery process will stop.
Specifies to perform the recovery of the entire database up to the point in time represented by the specifies recovery thread number. This value is used in an OPS or RAC environment to identify the Oracle server that generated the archived logs.
Specifies to perform the recovery of the entire database up to the specified point in time.
|
Copyright © 2016
|
|