Restoring Oracle Archive Logs with a CLI Tool

You can use the Log Restore CLI tool to restore an Oracle log file. Usually, to restore a log file using the Commvault CommCell Console, you need to create an auxiliary instance on the destination server with a restored control file or you need a connection to the recovery catalog. The Log Restore CLI tool simplifies the process so you don't need to create the auxiliary instance on the destination server or don't need a connection to the recovery catalog.

Procedure

Run the tool on the destination client server. For Windows agents, run the tool from the Base folder. For Unix agents, run the tool from the iDataagent folder in the core directory.

Before running the tool, use the qlogin command to create the qlogin token for authentication.

Usage

The Unix syntax to use the CLI tool is as follows:

../iDataAgent/ClOraAgent -tools -restoreArchiveLogs -tf <tokenFile> -vm <InstanceNNN> -sc <srcCVClientName> -si <srcInstanceName> -dc <dstCVClientName> -oh <ORACLE_HOME> -d <LogDestPath> [-startLogSeq <startLogSequence#> -endLogSeq <endLogSequence#> | -startTime <'MM:DD:YYYY-HH:MM:SS'> -endTime <'MM:DD:YYYY-HH:MM:SS'> | -allLogs ] [-useSrcCatalog <0/1> [-cp <copyPrecedence#>] -ma <MediaAgentName>]

Options

-tf

Token file from the qlogin command

-vm

Instance number

-sc

Source client name

-si

Source instance name

-dc

Destination client name

-oh

Oracle home directory on the destination client

-d

Destination path for the restored log file

-startLogSeq

Starting log seqence number

-endLogSeq

Ending log seqence number

-startTime

Start time

-endTime

End time

-allLogs

Restore all log files

-useSrcCatalog

Use the source database catalog flag

  • 0 - Don't use source catalog

  • 1 - Use source catalog

-cp

Copy precedence number

-ma

MediaAgent name

Loading...