Skip to main content
commvault.com commvault.com
Solved

Oracle CBT table restore with RMAN script Failed

G
Byte
Forum|alt.badge.img+7

 

Following the Commvault documentation (https://documentation.commvault.com/commvault/v11_sp20/article?p=134884.htm) regarding table restore on Oracle CDB environment I get the following error when I run the RMAN script:

 

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210402-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210402-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210402-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[26902]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210402-00] failed.

failover to previous backup

 

below the RMAN script executed:

RUN {
ALLOCATE CHANNEL dev0 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/commvault/Base/libobk.so,ENV=(CvInstanceName=Instance001)' ;
RECOVER table EXAMPLE.TESTCOMMVAULT OF PLUGGABLE DATABASE test14b
UNTIL SCN 13599650128869
AUXILIARY DESTINATION '/tmp';
release channel dev0;
}

 

Here is the complete output of the script:

Starting recover at 06-APR-21
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace TEST14B:SYSTEM
Tablespace UNDOTBS1
Tablespace TEST14B:UNDOTBS1
Tablespace UNDOTBS2
Tablespace TEST14B:UNDOTBS2

Creating automatic instance, with SID='oEzm'

initialization parameters used for automatic instance:
db_name=CTEST14
db_unique_name=oEzm_pitr_test14b_CTEST14
compatible=12.2.0
db_block_size=8192
db_files=200
diagnostic_dest=/orasw/app/oracle
_system_trig_enabled=FALSE
sga_target=34176M
processes=200
db_create_file_dest=/tmp
log_archive_dest_1='location=/tmp'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used


starting up automatic instance CTEST14

Oracle instance started

Total System Global Area   35836133376 bytes

Fixed Size                    30035200 bytes
Variable Size               5502927616 bytes
Database Buffers           30198988800 bytes
Redo Buffers                 104181760 bytes
Automatic instance created

contents of Memory Script:
{
# set requested point in time
set until  scn 13599650128869;
# restore the controlfile
restore clone controlfile;

# mount the controlfile
sql clone 'alter database mount clone database';

# archive current online log
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET until clause

Starting restore at 06-APR-21
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=23 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=30 device type=DISK

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210402-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210402-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210402-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[26902]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210402-00] failed.

failover to previous backup


Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/06/2021 15:09:33
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: dev0
RMAN-01007: at line 1 column 17 file: standard input
 

 

Best answer by Fabrizio

@Mahender Reddy ,

Thanks for your support, we have opened a support ticket.

The support found the problem in list backup, it was not listing the Commvault backup pieces and instead gave DDBoost details. Very likely the pieces would have been mark expired by the other media. The customer performed third party backup after the commvault full backup.

Blocked third-party backups and performed a full backup again, the restore worked correctly with the parameters described in the guide: Commvault Restoring Oracle Tables in CDB

Thanks

Fabrizio

View original
Thanks - Gabriele
Did this answer your question?

17 replies

Mike Struening
Vaulter
Forum|alt.badge.img+23

@Gabriele Palumbo , are there any errors in the Console?  The main error indicates a possible library issue (initial error and cause highlighted below).

Where is the data coming from?  We would need to see the Media Agent related log files, starting with CVMA.log and CVD.log.

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore

channel ORA_AUX_SBT_TAPE_1: restoring control file

channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210402-00

channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210402-00

ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210402-00", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: non RMAN, but media manager or vendor specific failure, error text:

   sbtrestore: Job[0] thread[26902]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210402-00] failed.

https://www.linkedin.com/in/michael-struening
M
Vaulter
Forum|alt.badge.img+5

@Gabriele Palumbo , After executing the script, did you see an "application command line restore" job in the commavult job controller?
If not, you may need to add the CvClientName parameter to the allocated channel.


Also, instead of including the allocate channel in the script, add "configure channel" to rman parameters and run the table restore script without allocating a channel;

 

Example:- 
configure channel device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/commvault/Base/libobk.so,ENV=(CvInstanceName=Instance001,CvClientName=<client_name>)';

 

Replace <client_name> with the client name appear in the commvault console.

 

Also, remove the "release channel dev0;" line from your script. Instead, use the "exit"; command after the run block;

 

Example:
run
{
RECOVER table EXAMPLE.TESTCOMMVAULT OF PLUGGABLE DATABASE test14b
UNTIL SCN 13599650128869
AUXILIARY DESTINATION '/tmp';
}
exit;

 

If the job fails again, please send us ORSBT.log from /var/log/commvault/Log_Files folder to review.

 

--
Mahender

G
Byte
Forum|alt.badge.img+7

 

In the CIOraAgent log file I see these errors:

1135 46f 04/06 15:06:30 8966 UnixSymbolicLink::getPhysicalPath(141) - isLink failed for '+ORADATA_NETAPP' :0xECCC0002:{CQiPath::IsLink(311)} + {CQiPath::IsLink(299)/ErrNo.2.(No such file or directory)-Failed to identify if file is link, FileName=+ORADATA_NETAPP}
1135 46f 04/06 15:06:30 8966 IdaSnapUtilBase::getMountPoint() - getMountPoint: path:+ORADATA_NETAPP/CTEST14/TEST14C/DATAFILE/undotbs1 - Failed to get a physicalPath
1135 46f 04/06 15:06:30 8966 UnixSymbolicLink::getPhysicalPath(141) - isLink failed for '+ORADATA_NETAPP' :0xECCC0002:{CQiPath::IsLink(311)} + {CQiPath::IsLink(299)/ErrNo.2.(No such file or directory)-Failed to identify if file is link, FileName=+ORADATA_NETAPP}
1135 46f 04/06 15:06:30 8966 IdaSnapUtilBase::getMountPoint() - getMountPoint: path:+ORADATA_NETAPP/CTEST14/9FF5FC55D3F7162DE0538D22020A9A31/DATAFILE/tsi_egovxmlc_1.348.1034606551 - Failed to get a physicalPath

Thanks - Gabriele
M
Vaulter
Forum|alt.badge.img+5

@Gabriele Palumbo , The logging in ClOraAgent.log doesn’t belong to the command line restore script. The ClOraAgent.log writes only for the GUI backup and restores.
Could you please run the steps I suggested in my earlier update and let us know how it went?

G
Byte
Forum|alt.badge.img+7

@Mahender Reddy, Tomorrow I will be with the customer to perform the tests you recommend. As soon as I have the results I'll update you.

 

Thanks

Gabriele

Thanks - Gabriele
Mike Struening
M
2 people like this
  • Mike Struening
    Mike Struening
  • M
    Mahender Reddy
F
Forum|alt.badge.img+4
  • Fabrizio
  • 11 replies
  • April 8, 2021

Hello,

I’m Fabrizio a colleague of Gabriele. I performed the test you recommended, but the result was the same. Below are the commands given:

configure channel device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/commvault/Base/libobk.so,ENV=(CvInstanceName=Instance001,CvClientName=rlldbtest14b)';

run
{
RECOVER table EXAMPLE.TESTCOMMVAULT OF PLUGGABLE DATABASE test14b
until time "to_date('04-08-2021 09:00:00','mm/dd/yyyy hh24:mi:ss')"
AUXILIARY DESTINATION '/tmp';
}
exit;

I checked the ORASBT log, below the output:
10758 2a06 04/08 11:02:58 ### skipFS::SetFSCacheEnabled(537) - FSType cache is enabled
10758 2a06 04/08 11:02:58 ### EvEvent::SetupConnectionWithCVD() - Loading library under Base32
10758 2a06 04/08 11:02:58 ### EvEvent::SetupConnectionWithCVD() - Loading library under Base64
10758 2a06 04/08 11:02:58 ### SbtParamsInit: event has initialized
10758 2a06 04/08 11:02:58 ### SbtParamsInit: setFocus -> ClientName [rlldbtest14b], InstanceName[Instance001]
10758 2a06 04/08 11:02:58 ### SbtParamsInit: Got argc=0.
10758 2a06 04/08 11:02:58 ### SbtParamsInit: Using Current Directory as backupdir [/orasw/app/oracle/product/12.2.0/dbhome_1/dbs]
10758 2a06 04/08 11:02:58 ### SbtParamsInit: Backup Directory /orasw/app/oracle/product/12.2.0/dbhome_1/dbs
10758 2a06 04/08 11:02:58 ### sbtinit: enter - PID:9965, TID:10758
10758 2a06 04/08 11:02:58 ### sbtinit: SBT Perf stats is ON
10758 2a06 04/08 11:02:58 ### sbtinit: ThreadId=10758 ThreadNumber=1
10758 2a06 04/08 11:02:58 ### sbtinit: enter 1 time - PID:9965, TID:10758
10758 2a06 04/08 11:02:58 ### sbtinit() - sbtio event successfully initialized
10758 2a06 04/08 11:02:58 ### sbtinit: define trace file name=/orasw/app/oracle/product/12.2.0/dbhome_1/rdbms/log/sbtio.log
10758 2a06 04/08 11:02:58 ### sbtinit: Version 2.0
10758 2a06 04/08 11:02:58 ### setup_sigusr2_action: sbrtsigset(SIGUSR2,SIG_IGN) done - PID:0, TID:9965
10758 2a06 04/08 11:02:58 ### sbtinit: exit 1 time - PID:9965, TID:10758; retVal=0
10758 2a06 04/08 11:02:58 ### sbtinit2: enter - PID:9965, TID:10758
10758 2a06 04/08 11:02:58 ### sbtinit2: changing a trace level to: 0
10758 2a06 04/08 11:02:58 ### sbtinit2: API Client supports Oracle MM API Version: 2.0
10758 2a06 04/08 11:02:58 ### sbtinit2: Got argc=0.
10758 2a06 04/08 11:02:58 ### sbtinit2: exit - PID:9965, TID:10758; retVal=0
11995 2edb 04/08 11:03:45 ### skipFS::SetFSCacheEnabled(537) - FSType cache is enabled
11995 2edb 04/08 11:03:45 ### EvEvent::SetupConnectionWithCVD() - Loading library under Base32
11995 2edb 04/08 11:03:45 ### EvEvent::SetupConnectionWithCVD() - Loading library under Base64
11995 2edb 04/08 11:03:45 ### SbtParamsInit: event has initialized
11995 2edb 04/08 11:03:45 ### SbtParamsInit: setFocus -> ClientName [rlldbtest14b], InstanceName[Instance001]
11995 2edb 04/08 11:03:45 ### SbtParamsInit: Got argc=0.
11995 2edb 04/08 11:03:45 ### SbtParamsInit: Using Current Directory as backupdir [/orasw/app/oracle/product/12.2.0/dbhome_1/dbs]
11995 2edb 04/08 11:03:45 ### SbtParamsInit: Backup Directory /orasw/app/oracle/product/12.2.0/dbhome_1/dbs
11995 2edb 04/08 11:03:45 ### sbtinit: enter - PID:1, TID:11995
11995 2edb 04/08 11:03:45 ### sbtinit: SBT Perf stats is ON
11995 2edb 04/08 11:03:45 ### sbtinit: ThreadId=11995 ThreadNumber=1
11995 2edb 04/08 11:03:45 ### sbtinit: enter 1 time - PID:1, TID:11995
11995 2edb 04/08 11:03:45 ### sbtinit() - sbtio event successfully initialized
11995 2edb 04/08 11:03:45 ### sbtinit: define trace file name=/orasw/app/oracle/product/12.2.0/dbhome_1/rdbms/log/sbtio.log
11995 2edb 04/08 11:03:45 ### sbtinit: Version 2.0
11995 2edb 04/08 11:03:45 ### setup_sigusr2_action: sbrtsigset(SIGUSR2,SIG_IGN) done - PID:0, TID:1
11995 2edb 04/08 11:03:45 ### sbtinit: exit 1 time - PID:1, TID:11995; retVal=0
11995 2edb 04/08 11:03:45 ### sbtinit2: enter - PID:1, TID:11995
11995 2edb 04/08 11:03:45 ### sbtinit2: changing a trace level to: 0
11995 2edb 04/08 11:03:45 ### sbtinit2: API Client supports Oracle MM API Version: 2.0
11995 2edb 04/08 11:03:45 ### sbtinit2: Got argc=0.
11995 2edb 04/08 11:03:45 ### sbtinit2: exit - PID:1, TID:11995; retVal=0
11995 2edb 04/08 11:03:48 ### sbtinfo2: enter.
11995 2edb 04/08 11:03:48 ### ReadOraMediaParams: Read media env parameters
11995 2edb 04/08 11:03:48 ### OraAgentBase20::CreateContextObject(3647) - Oracle AppType
11995 2edb 04/08 11:03:48 ### ::Initialize1() - AppType = [22]
11995 2edb 04/08 11:03:48 ### ::Initialize1() - clientName=[rlldbtest14b]
11995 2edb 04/08 11:03:48 ### GetHostName() - Exit hostName=[rlldbtest14b.interno.regione.lazio.it].
11995 2edb 04/08 11:03:48 ### ::Initialize1() - hostName=[rlldbtest14b.interno.regione.lazio.it]
11995 2edb 04/08 11:03:48 ### ::Initialize1() - getting args (for Command Line case) db_name=[] logsBackup=[FALSE] mode=400 op = [CrossCheck] ...
11995 2edb 04/08 11:03:48 ### ::Initialize1() - Setting  CTRL HostName: rlldbtest14b.interno.regione.lazio.it*rlldbtest14b*8400*8402 for eRUN_EM job
11995 2edb 04/08 11:03:48 ### ::RecvArgsForCommandLine() - Retrieving information from CommServe: Client=[rlldbtest14b.interno.regione.lazio.it] Instance=[].
11995 2edb 04/08 11:03:48 ### isCCSDbEnabled() - Use CCSDb Enabled [0] IsCloudLaptop [0] IsFSCoreLaptop [0]
11995 2edb 04/08 11:03:48 ### CvClntCert::loadLib() - Successfully loaded /opt/commvault/Base/libCvClntCertImpl.so
11995 2edb 04/08 11:03:48 ### cccAuthClient() - Only built-in certificate is loaded. Client name requested by remote end: ()(). Physical node in the registry: (rlldbtest14b).
11995 2edb 04/08 11:03:48 ### Cvcl::init() - CVCL: Running in FIPS Mode
11995 2edb 04/08 11:03:49 ### ::RecvArgsForCommandLine() - CrossCheck init succeeded.
11995 2edb 04/08 11:03:49 ### ::Initialize1() - m_totalBytesDiff=[524288000].
11995 2edb 04/08 11:03:49 ### ::Initialize1() - secondsToWait=120 mode=400 m_backup=400.
11995 2edb 04/08 11:03:49 ### ::Initialize1() - Done
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::Initialize2() - Using vsnprintf [archFileName=<> blockSize=0 jobUnit=831a8d88 phase=8 threadId=140200617455323 channelNumber=140724603453439 criticalSection=0.]
11995 2edb 04/08 11:03:49 ### GetChannelParamFileName() - Channel Parameter File : /opt/commvault/Base/Temp/cv_channel_info0
11995 2edb 04/08 11:03:49 ### GetIncrementalChannelNumber() - previous channel number : 15
11995 2edb 04/08 11:03:49 ### GetIncrementalChannelNumber() - Channel Num = 16
11995 2edb 04/08 11:03:49 ### Initialize2() - Using vsnprintf [Restore Head KeepAlive set to [1800] seconds]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::NewArchive() - Using vsnprintf [Getting new CvDeMuxArchive for archFileName=[]...]
11995 2edb 04/08 11:03:49 ### CVArchive::Construct() - Constructing CVArchive Object. This=0x17765f30
11995 2edb 04/08 11:03:49 ### CVArchive::Construct() - Enable CVArchive Big Buffer [true] [perf-update interval 600 seconds]
11995 2edb 04/08 11:03:49 ### CreateOraObject: Added CvArchive to IdaPerfMgr
11995 2edb 04/08 11:03:49 ### controlResourceUtilization() - Aptype=[0] not supported for CPU resource control
11995 2edb 04/08 11:03:49 ### CreateOraObject20: after initialize new OraBackupRestore20
11995 2edb 04/08 11:03:49 ### get_file_info: enter.
11995 2edb 04/08 11:03:49 ### get_file_info: begin GetBackupInfo - file <c-2205816741-20210408-00>
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::GetBackupInfo() - Using vsnprintf [clientId=[32] instanceId=[0] name=[c-2205816741-20210408-00] copy=[0], matchClient =[0]...]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::GetBackupInfo() - Using vsnprintf [calling archMgr ]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::GetBackupInfo() - Using vsnprintf [AFileIdList is empty, retCode=1]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::GetBackupInfo() - Using vsnprintf [For crosscheck: retCode=[1] appId=[0] afileNumber=[0] agroupNumber=[0] streamNum=[0] appType=[0].]
11995 2edb 04/08 11:03:49 ### IdaUtilBrowse::browseByItemName(38) - Invalid argument,  clientId or one of (Application Id, Instance Id and backupsetId) need to be passed (ErrNo.22): 0xECCC0016:{IdaUtilBrowse::browseByItemName(38)/Browse inputs cannot be empty} + {IdaUtilBrowse::browseByItemName(37)/ErrNo.22.(Invalid argument)- clientId or one of (Application Id, Instance Id and backupsetId) need to be passed}
11995 2edb 04/08 11:03:49 ### OscLogBackupUtility::LookupIndexForBackupPiece(208) - Failed to lookup Index for backuppiece [c-2205816741-20210408-00] error = [0xECCC0016:{IdaUtilBrowse::browseByItemName(38)/Browse inputs cannot be empty} + {IdaUtilBrowse::browseByItemName(37)/ErrNo.22.(Invalid argument)- clientId or one of (Application Id, Instance Id and backupsetId) need to be passed}]
11995 2edb 04/08 11:03:49 ### get_file_info: file <c-2205816741-20210408-00> is not found
11995 2edb 04/08 11:03:49 ### get_file_info: exit: retVal=0.
11995 2edb 04/08 11:03:49 ### sbtinfo2: exit retVal=0
11995 2edb 04/08 11:03:49 ### sbtrestore: enter - PID:1, TID:11995; backup_file_name=c-2205816741-20210408-00; block_size=262144
11995 2edb 04/08 11:03:49 ### sbtrestore: Switch To Restore after CrossCheck ...
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::SwitchToRestore() - Using vsnprintf [Enter: current mode=400.]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::SwitchToRestore() - Using vsnprintf [SwitchToRestore() ... GetBackupInfo() to get the AppType]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::GetBackupInfo() - Using vsnprintf [clientId=[32] instanceId=[0] name=[c-2205816741-20210408-00] copy=[0], matchClient =[0]...]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::GetBackupInfo() - Using vsnprintf [calling archMgr ]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::GetBackupInfo() - Using vsnprintf [AFileIdList is empty, retCode=1]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::GetBackupInfo() - Using vsnprintf [For crosscheck: retCode=[1] appId=[0] afileNumber=[0] agroupNumber=[140202702368494] streamNum=[0] appType=[0].]
11995 2edb 04/08 11:03:49 ### IdaUtilBrowse::browseByItemName(38) - Invalid argument,  clientId or one of (Application Id, Instance Id and backupsetId) need to be passed (ErrNo.22): 0xECCC0016:{IdaUtilBrowse::browseByItemName(38)/Browse inputs cannot be empty} + {IdaUtilBrowse::browseByItemName(37)/ErrNo.22.(Invalid argument)- clientId or one of (Application Id, Instance Id and backupsetId) need to be passed}
11995 2edb 04/08 11:03:49 ### OscLogBackupUtility::LookupIndexForBackupPiece(208) - Failed to lookup Index for backuppiece [c-2205816741-20210408-00] error = [0xECCC0016:{IdaUtilBrowse::browseByItemName(38)/Browse inputs cannot be empty} + {IdaUtilBrowse::browseByItemName(37)/ErrNo.22.(Invalid argument)- clientId or one of (Application Id, Instance Id and backupsetId) need to be passed}]
11995 2edb 04/08 11:03:49 ### OraBackupRestoreBase::SwitchToRestore() - Job[0] thread[11995]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210408-00] failed.
11995 2edb 04/08 11:03:49 ### sbtrestore: exiting after br->SwitchToRestore()
11995 2edb 04/08 11:03:49 ### : sbtrestore: Job[0] thread[11995]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210408-00] failed.
11995 2edb 04/08 11:03:49 ### sbtrestore: exit - PID:1, TID:11995; retVal=-1
11995 2edb 04/08 11:03:49 ### sbterror: enter.
11995 2edb 04/08 11:03:49 ### sbterror: error_code=7501 error_text=sbtrestore: Job[0] thread[11995]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210408-00] failed.
11995 2edb 04/08 11:03:49 ### sbterror: exit retVal=0

 

I noticed the “invalid argument...”, possible that some more parameters are missing?

I add that the environment is an ORACLE RAC with two nodes, and restore attempts are performed on CDB.

 

Thanks

Fabrizio

M
Vaulter
Forum|alt.badge.img+5

@Fabrizio , 

Can I see the output of that script?
Also, is this an inplace or out-of-place restore?
In commvault, has the source database created as a RAC? If yes, may I know the RAC client name and RAC db name?
Also, can you please provide the output of the #commvault status; command from the client?

Based on the above details, we will add more information to the ENV section of the configuration channel and try a new restore.

F
Forum|alt.badge.img+4
  • Fabrizio
  • 11 replies
  • April 8, 2021

@Mahender Reddy ,

Below the output of the script:

Show content

RMAN> run
{
RECOVER table EXAMPLE.TESTCOMMVAULT OF PLUGGABLE DATABASE test14b
until time "to_date('04-02-2021 06:00:00','mm/dd/yyyy hh24:mi:ss')"
AUXILIARY DESTINATION '/tmp';
}
exit;2> 3> 4> 5> 6>
Starting recover at 08-APR-21
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=1762 instance=CTEST142 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=11552 instance=CTEST142 device type=DISK
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace TEST14B:SYSTEM
Tablespace UNDOTBS1
Tablespace TEST14B:UNDOTBS1
Tablespace UNDOTBS2
Tablespace TEST14B:UNDOTBS2

Creating automatic instance, with SID='ogcu'

initialization parameters used for automatic instance:
db_name=CTEST14
db_unique_name=ogcu_pitr_test14b_CTEST14
compatible=12.2.0
db_block_size=8192
db_files=200
diagnostic_dest=/orasw/app/oracle
_system_trig_enabled=FALSE
sga_target=34176M
processes=200
db_create_file_dest=/tmp
log_archive_dest_1='location=/tmp'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used


starting up automatic instance CTEST14

Oracle instance started

Total System Global Area   35836133376 bytes

Fixed Size                    30035200 bytes
Variable Size               5502927616 bytes
Database Buffers           30198988800 bytes
Redo Buffers                 104181760 bytes
Automatic instance created

contents of Memory Script:
{
# set requested point in time
set until  time "to_date('04-02-2021 06:00:00','mm/dd/yyyy hh24:mi:ss')";
# restore the controlfile
restore clone controlfile;

# mount the controlfile
sql clone 'alter database mount clone database';

# archive current online log
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET until clause

Starting restore at 08-APR-21
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=23 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=30 device type=DISK


Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/08/2021 15:07:38
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

 

This is In-Place restore.

Yes in Commserve there is a Pseudo Client Oracle RAC, below the settings:

This below the otput of Commvault Status on client:

Show content

--------------------------------- Instance001 ---------------------------------
[ General ]
 Version = 11.21.10
 Media Revision = 830
 CommServe Host Name = RLWCVCS01.domain.it
 CommServe Client Name = rlwcvcs01
 Home Directory = /opt/commvault/Base
 Log Directory = /var/log/commvault/Log_Files
 Core Directory = /opt/commvault
 Temp Directory = /opt/commvault/Base/Temp
 Platform Type = 4
 Cvd Port Number = 8400
[ Package ]
 1002/CVGxBase 11(BUILD80) = File System Core
 1101/CVGxIDA  = File System
 1204/CVGxOrIDA  = Oracle iDataAgent
[ Physical Machine/Cluster Groups ]
 Display Name = rlldbtest14b
  - Client Hostname = rlldbtest14b.domain.it
  - Job Results Directory = /opt/commvault/iDataAgent/jobResult

 

Thanks

Fabrizio

M
Vaulter
Forum|alt.badge.img+5

@Fabrizio 

Thanks for those details. Could you please execute the following steps?

Step 1:-Configure channel

configure channel device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/commvault/Base/libobk.so,ENV=(CvOraSID=CTEST14)';

Step 2:- Execute the table restore script

run
{
RECOVER table EXAMPLE.TESTCOMMVAULT OF PLUGGABLE DATABASE test14b
until time "to_date('04-08-2021 09:00:00','mm/dd/yyyy hh24:mi:ss')"
AUXILIARY DESTINATION '/tmp';
}
exit;

In case, if you still encounter the same issue, please update the configure channel as following and run the restore script.

configure channel device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/commvault/Base/libobk.so,ENV=(CvClientName=rac-scan-test14,CVOraRacDBName=CTEST14,CvInstanceName=Instance001,-hn=rlldbtest14b.domain.it)';
 

F
Forum|alt.badge.img+4
  • Fabrizio
  • 11 replies
  • April 8, 2021

@Mahender Reddy ,

I tried both configuration but the result is still the same, below the output of the script:
 

Show content

RMAN> run
{
RECOVER table EXAMPLE.TESTCOMMVAULT OF PLUGGABLE DATABASE test14b
until time "to_date('04-08-2021 09:00:00','mm/dd/yyyy hh24:mi:ss')"
AUXILIARY DESTINATION '/tmp';
}
exit;2> 3> 4> 5> 6>
Starting recover at 08-APR-21
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=7035 instance=CTEST142 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7285 instance=CTEST142 device type=DISK
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace TEST14B:SYSTEM
Tablespace UNDOTBS1
Tablespace TEST14B:UNDOTBS1
Tablespace UNDOTBS2
Tablespace TEST14B:UNDOTBS2

Creating automatic instance, with SID='uhin'

initialization parameters used for automatic instance:
db_name=CTEST14
db_unique_name=uhin_pitr_test14b_CTEST14
compatible=12.2.0
db_block_size=8192
db_files=200
diagnostic_dest=/orasw/app/oracle
_system_trig_enabled=FALSE
sga_target=34176M
processes=200
db_create_file_dest=/tmp
log_archive_dest_1='location=/tmp'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used


starting up automatic instance CTEST14

Oracle instance started

Total System Global Area   35836133376 bytes

Fixed Size                    30035200 bytes
Variable Size               5502927616 bytes
Database Buffers           30198988800 bytes
Redo Buffers                 104181760 bytes
Automatic instance created

contents of Memory Script:
{
# set requested point in time
set until  time "to_date('04-08-2021 09:00:00','mm/dd/yyyy hh24:mi:ss')";
# restore the controlfile
restore clone controlfile;

# mount the controlfile
sql clone 'alter database mount clone database';

# archive current online log
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET until clause

Starting restore at 08-APR-21
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=23 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=30 device type=DISK

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210408-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210408-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210408-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210408-00] failed.

failover to previous backup

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210407-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210407-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210407-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210407-00] failed.

failover to previous backup

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210406-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210406-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210406-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210406-00] failed.

failover to previous backup

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210405-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210405-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210405-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210405-00] failed.

failover to previous backup

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210404-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210404-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210404-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210404-00] failed.

failover to previous backup


Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/08/2021 16:08:16
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

 

Below the subclient setting:

 

result of full backup:

Thanks

Fabrizio

M
Vaulter
Forum|alt.badge.img+5

@Fabrizio , could you please share the rman script outputs and ORASBT.log?

F
Forum|alt.badge.img+4
  • Fabrizio
  • 11 replies
  • April 13, 2021

@Mahender Reddy ,

Below rman script output:

Show content

RMAN> run
{
RECOVER table EXAMPLE.TESTCOMMVAULT OF PLUGGABLE DATABASE test14b
until time "to_date('04-08-2021 09:00:00','mm/dd/yyyy hh24:mi:ss')"
AUXILIARY DESTINATION '/tmp';
}
exit;2> 3> 4> 5> 6>
Starting recover at 08-APR-21
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=7035 instance=CTEST142 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7285 instance=CTEST142 device type=DISK
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace TEST14B:SYSTEM
Tablespace UNDOTBS1
Tablespace TEST14B:UNDOTBS1
Tablespace UNDOTBS2
Tablespace TEST14B:UNDOTBS2

Creating automatic instance, with SID='uhin'

initialization parameters used for automatic instance:
db_name=CTEST14
db_unique_name=uhin_pitr_test14b_CTEST14
compatible=12.2.0
db_block_size=8192
db_files=200
diagnostic_dest=/orasw/app/oracle
_system_trig_enabled=FALSE
sga_target=34176M
processes=200
db_create_file_dest=/tmp
log_archive_dest_1='location=/tmp'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used


starting up automatic instance CTEST14

Oracle instance started

Total System Global Area   35836133376 bytes

Fixed Size                    30035200 bytes
Variable Size               5502927616 bytes
Database Buffers           30198988800 bytes
Redo Buffers                 104181760 bytes
Automatic instance created

contents of Memory Script:
{
# set requested point in time
set until  time "to_date('04-08-2021 09:00:00','mm/dd/yyyy hh24:mi:ss')";
# restore the controlfile
restore clone controlfile;

# mount the controlfile
sql clone 'alter database mount clone database';

# archive current online log
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET until clause

Starting restore at 08-APR-21
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=23 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=30 device type=DISK

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210408-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210408-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210408-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210408-00] failed.

failover to previous backup

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210407-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210407-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210407-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210407-00] failed.

failover to previous backup

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210406-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210406-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210406-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210406-00] failed.

failover to previous backup

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210405-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210405-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210405-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210405-00] failed.

failover to previous backup

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-2205816741-20210404-00
channel ORA_AUX_SBT_TAPE_1: ORA-19870: error while restoring backup piece c-2205816741-20210404-00
ORA-19507: failed to retrieve sequential file, handle="c-2205816741-20210404-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   sbtrestore: Job[0] thread[14625]: Restore: GetBackupInfo() for Archive File[c-2205816741-20210404-00] failed.

failover to previous backup


Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/08/2021 16:08:16
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

 

 

 

Below an extract of ORASBT.log when started the rman script:

Show content

41191 a0e7 04/13 10:57:11 ### skipFS::SetFSCacheEnabled(537) - FSType cache is enabled
41191 a0e7 04/13 10:57:11 ### EvEvent::SetupConnectionWithCVD() - Loading library under Base32
41191 a0e7 04/13 10:57:11 ### EvEvent::SetupConnectionWithCVD() - Loading library under Base64
41191 a0e7 04/13 10:57:11 ### SbtParamsInit: event has initialized
41191 a0e7 04/13 10:57:11 ### SbtParamsInit: setFocus -> ClientName [rac-scan-test14], InstanceName[Instance001]
41191 a0e7 04/13 10:57:11 ### SbtParamsInit: Got argc=0.
41191 a0e7 04/13 10:57:11 ### SbtParamsInit: Using Current Directory as backupdir [/orasw/app/oracle/product/12.2.0/dbhome_1/dbs]
41191 a0e7 04/13 10:57:11 ### SbtParamsInit: Backup Directory /orasw/app/oracle/product/12.2.0/dbhome_1/dbs
41191 a0e7 04/13 10:57:11 ### sbtinit: enter - PID:40810, TID:41191
41191 a0e7 04/13 10:57:11 ### sbtinit: SBT Perf stats is ON
41191 a0e7 04/13 10:57:11 ### sbtinit: ThreadId=41191 ThreadNumber=1
41191 a0e7 04/13 10:57:11 ### sbtinit: enter 1 time - PID:40810, TID:41191
41191 a0e7 04/13 10:57:11 ### sbtinit() - sbtio event successfully initialized
41191 a0e7 04/13 10:57:11 ### sbtinit: define trace file name=/orasw/app/oracle/product/12.2.0/dbhome_1/rdbms/log/sbtio.log
41191 a0e7 04/13 10:57:11 ### sbtinit: Version 2.0
41191 a0e7 04/13 10:57:11 ### setup_sigusr2_action: sbrtsigset(SIGUSR2,SIG_IGN) done - PID:0, TID:40810
41191 a0e7 04/13 10:57:11 ### sbtinit: exit 1 time - PID:40810, TID:41191; retVal=0
41191 a0e7 04/13 10:57:11 ### sbtinit2: enter - PID:40810, TID:41191
41191 a0e7 04/13 10:57:11 ### sbtinit2: changing a trace level to: 0
41191 a0e7 04/13 10:57:11 ### sbtinit2: API Client supports Oracle MM API Version: 2.0
41191 a0e7 04/13 10:57:11 ### sbtinit2: Got argc=0.
41191 a0e7 04/13 10:57:11 ### sbtinit2: exit - PID:40810, TID:41191; retVal=0
41822 a35e 04/13 10:57:57 ### skipFS::SetFSCacheEnabled(537) - FSType cache is enabled
41822 a35e 04/13 10:57:57 ### EvEvent::SetupConnectionWithCVD() - Loading library under Base32
41822 a35e 04/13 10:57:57 ### EvEvent::SetupConnectionWithCVD() - Loading library under Base64
41822 a35e 04/13 10:57:57 ### SbtParamsInit: event has initialized
41822 a35e 04/13 10:57:57 ### SbtParamsInit: setFocus -> ClientName [rac-scan-test14], InstanceName[Instance001]
41822 a35e 04/13 10:57:57 ### SbtParamsInit: Got argc=0.
41822 a35e 04/13 10:57:57 ### SbtParamsInit: Using Current Directory as backupdir [/orasw/app/oracle/product/12.2.0/dbhome_1/dbs]
41822 a35e 04/13 10:57:57 ### SbtParamsInit: Backup Directory /orasw/app/oracle/product/12.2.0/dbhome_1/dbs
41822 a35e 04/13 10:57:57 ### sbtinit: enter - PID:1, TID:41822
41822 a35e 04/13 10:57:57 ### sbtinit: SBT Perf stats is ON
41822 a35e 04/13 10:57:57 ### sbtinit: ThreadId=41822 ThreadNumber=1
41822 a35e 04/13 10:57:57 ### sbtinit: enter 1 time - PID:1, TID:41822
41822 a35e 04/13 10:57:57 ### sbtinit() - sbtio event successfully initialized
41822 a35e 04/13 10:57:57 ### sbtinit: define trace file name=/orasw/app/oracle/product/12.2.0/dbhome_1/rdbms/log/sbtio.log
41822 a35e 04/13 10:57:57 ### sbtinit: Version 2.0
41822 a35e 04/13 10:57:57 ### setup_sigusr2_action: sbrtsigset(SIGUSR2,SIG_IGN) done - PID:0, TID:1
41822 a35e 04/13 10:57:57 ### sbtinit: exit 1 time - PID:1, TID:41822; retVal=0
41822 a35e 04/13 10:57:57 ### sbtinit2: enter - PID:1, TID:41822
41822 a35e 04/13 10:57:57 ### sbtinit2: changing a trace level to: 0
41822 a35e 04/13 10:57:57 ### sbtinit2: API Client supports Oracle MM API Version: 2.0
41822 a35e 04/13 10:57:57 ### sbtinit2: Got argc=0.
41822 a35e 04/13 10:57:57 ### sbtinit2: exit - PID:1, TID:41822; retVal=0
41822 a35e 04/13 10:58:00 ### sbtend: enter - PID:1, TID:41822
41822 a35e 04/13 10:58:00 ### CvHandleClean: before clean cv_handle=87bba0c8 ThreadNumber=1
41822 a35e 04/13 10:58:00 ### CvHandleClean: ThreadDeleteTidN [41822]
41822 a35e 04/13 10:58:00 ### sbtend: exit  - PID:1, TID:41822; retVal=0 ThreadNumber=0>
<.........
41822 a35e 04/13 10:58:00 ### sbtend: ***** BEGIN SBT PERFORMANCE STATISTICS(SBTPS) for Client API Session: PID:1, TID:41822   ********
41822 a35e 04/13 10:58:00 ### SbtParamsClean: API Client supports Oracle MM API Version: 2.0>
<.........
41822 a35e 04/13 10:58:00 ### SbtParamsClean: delete event...

 

Thanks

Fabrizio

M
Vaulter
Forum|alt.badge.img+5

@Fabrizio , can you please attach the complete ORASBT.log ?

F
Forum|alt.badge.img+4
  • Fabrizio
  • 11 replies
  • April 13, 2021

@Mahender Reddy ,

attached the orasbt file.

 

Thanks

Fabrizio

1 Attachments
M
Vaulter
Forum|alt.badge.img+5

@Fabrizio ,
The command-line restore is not talking to the commserver.
We need to find out a proper configure channel that fits your environment.
Can you send me the view rman log output of the latest backup? 
We can try using the same allocate channel from the backup script for the configuring channel and see how that helps.

F
Forum|alt.badge.img+4
  • Fabrizio
  • 11 replies
  • Answer
  • April 19, 2021

@Mahender Reddy ,

Thanks for your support, we have opened a support ticket.

The support found the problem in list backup, it was not listing the Commvault backup pieces and instead gave DDBoost details. Very likely the pieces would have been mark expired by the other media. The customer performed third party backup after the commvault full backup.

Blocked third-party backups and performed a full backup again, the restore worked correctly with the parameters described in the guide: Commvault Restoring Oracle Tables in CDB

Thanks

Fabrizio

M
1 person likes this
  • M
    Mahender Reddy
Mike Struening
Vaulter
Forum|alt.badge.img+23

Thanks for sharing the fix, @Fabrizio !

https://www.linkedin.com/in/michael-struening
F
1 person likes this
  • F
    Fabrizio

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings