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
|
-cp |
Copy precedence number |
-ma |
MediaAgent name |