Question

Issues with Oracle Backup and restore from S3 Compatible Cloud Storage

  • 26 May 2023
  • 4 replies
  • 355 views

Badge +1

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.


4 replies

Userlevel 7
Badge +19

Hi @Jass,

To summarize your story even further you currently can't protect the database anymore, because it is in a broken state and you need to recover it from backup, right?

So, I would first perform a data verification of the required jobs to see what comes out of it: → https://documentation.commvault.com/2022e/expert/12371_validate_backups_for_data_recovery.html

In addition can you share the platform release and maintenance release that you are running? Also, you are mentioning S3-compatible, so I assume you run an on-premise S3 solution. Can you share something about it? Are you using strong write consistency? From what it looks like you might be missing some pieces to be able to recovery, however Commvault performs a lot of consistency checks when it writes data to it's library, 

Badge +1

@Onno van den Berg , Hi , as of now, we are just testing the restore operation of a successful archive log backup. We have just changed the database to "no mount” state using SQL Plus using:
SQL> startup nomount;

  • We did perform the Data Verification job on the backup already existing and it ran successfully.
  • We performed archive log full backup, performed data verification job and performed restore but still getting a new error message stating:
     
     Error Code: [18:183]
Description: Failed with Oracle DB/RMAN error [RMAN-03002: failure of restore command at 05/31/2023 02:01:04 RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece ]
Source: win-\XXXXX, Process: ClOraAgent
  • We are using the 11.30.23 version of Commvault.
  • Yes, that’s right, we are using on premises HCP for Cloud Scale.
  • We are not aware of using any strong write consistency.

 

Badge +1

@Onno van den Berg 

Also, as mentioned in the original thread, we are also unable to perform Default Backup 

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.

Badge
Hello team,Did you find a solution to this problem? We are facing the same situation

Reply