We are testing Commvault data backup and restore to S3 Compatible Storage.
For Oracle, archive log backup is successful whereas restore fails, and in the case of Oracle default sub-client both backup and restore fail.
For the restore operation of the archive log:
We were unable to find the below-mentioned data files backed up in our object storage even after a successful backup, and we could notice that the GET requests are failing 302 and 303 errors.
Error in CommCell : Error Code: [18:183]
Description: Failed with Oracle DB/RMAN error [RMAN-03002: failure of restore command at 05/23/2023 07:13:55 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 11 found to restore RMAN-06023: no backup or copy of datafile 10 found to restore RMAN-06023: no backup or copy of datafile 9 found to restore RMAN-06023: no backup or copy of datafile 8 found to restore RMAN-06023: no backup or copy of datafile 7 found to restore RMAN-06023: no backup or copy of datafile 6 found to restore RMAN-06023: no backup or copy of datafile 5 found to restore RMAN-06023: no backup or copy of datafile 4 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore ]
Source: win-3ot9mug08hi, Process: ClOraAgent
Backup for default sub client:
Error Code in CommCell : [72:151]
Description: Error :[Rollback segments update failed:[ SQL*Plus: Release 21.0.0.0.0 - Production on Tue May 23 07:08:59 2023 Version 21.3.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. SQL>SQL>SQL>SQL>Connected. SQL>SQL>SQL>SQL>SQL>SQL>SQL> 2 3 4 5 6 7 8 9 10 11 12 select distinct 'U,', c.name || ':' || s.tablespace_name from cdb_segments s, v$CONTAINERS c where s.owner in ('SYS', 'SYSTEM') and c.CON_ID = s.CON_ID * ERROR at line 1: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only SQL>SQL>Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production ].]
Source: win-3ot9mug08hi, Process: ClOraAgent
Backup is failing since the SQL plus database is not in open state and we are unable to alter it to open.