Solved

using disk restores gives ORA-27048

  • 7 May 2021
  • 2 replies
  • 1623 views

Badge

Hi!

For time-saving purposes I decided to restore Oracle RMAN backupsets to disk using this documetation link: https://documentation.commvault.com/commvault/v11/article?p=20540.htm

When I try to restore from it I got ORA-27048:

RMAN> restore controlfile from '/u02/app/oracle/backup/1165136/794747_PBS_r0u1qblp_1_1';

Starting restore at 07-05-2021 13:44:34
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/07/2021 13:44:36
ORA-19870: error while restoring backup piece /u02/app/oracle/backup/1165136/794747_PBS_r0u1qblp_1_1
ORA-19505: failed to identify file "/u02/app/oracle/backup/1165136/794747_PBS_r0u1qblp_1_1"
ORA-27048: skgfifi: file header information is invalid
Additional information: 2

Backup was made from Oracle Linux x86_64 machine and is restored to another OEL x86_64 server.

Is it possible to use disk restores? Maybe there is some Big/Little Endian converion happens?

Oracle Enterprise Edition 12.2

Oracle Linux Server release 7.8
 

icon

Best answer by Mahender Reddy 7 May 2021, 17:40

View original

2 replies

Userlevel 3
Badge +5

@eug , though the backup pieces are copied locally, you still need a sbt channel to read the data.

Could you please try configuring a SBT channel as per the below documentation link and try a restore?

https://documentation.commvault.com/commvault/v11/article?p=20544.htm

Example: 
configure channel device type 'sbt_tape'
PARMS="SBT_LIBRARY=<software_installation_path>/Base/libobk.so,ENV=(BACKUP_DIR=disk_location,CV_media=FILE)";

Userlevel 2
Badge +7

Cataloging Backup Pieces Restored to Disk After an Application-Free Restore

After an application free restore use RMAN scripts to catalog Oracle backup pieces to disk after an application-free restore.

[oracle@uxdboe5 ~]$ rman target /

 

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Oct 7 15:15:06 2015

 

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: UXDBP (DBID=4167489344)

 

RMAN> list backup of database device type disk;

 

using target database control file instead of recovery catalog

specification does not match any backup in the repository

 

Note: the backuppieces are getting restored in a subdirectory <restore path>/<restore jobid>

Procedure

  1. On the RMAN command line, connect to the target database.
  2. On the RMAN command line, create and then run the following RMAN sample script.

Do not use the forward slash (/) at the end of the folder name.

RMAN> configure channel device type 'sbt_tape'

2> PARMS="SBT_LIBRARY=/opt/simpana/Base/libobk.so,ENV=(BACKUP_DIR=/u01/app/oracle/fast_recovery_area/UXDBP/backupset/151782,CV_media=FILE)";

 

old RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  "SBT_LIBRARY=/opt/simpana/Base/libobk.so,BLKSIZE=1048576";

new RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  "SBT_LIBRARY=/opt/simpana/Base/libobk.so,ENV=(BACKUP_DIR=/u01/app/oracle/fast_recovery_area/UXDBP/backupset/151782,CV_media=FILE)";

new RMAN configuration parameters are successfully stored

  1. Verify the configuration. On the RMAN command line, type the following command to verify the configuration.

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  "SBT_LIBRARY=/opt/simpana/Base/libobk.so,ENV=(BACKUP_DIR=/u01/app/oracle/fast_recovery_area/UXDBP/backupset/151782,CV_media=FILE)";

 

 

  1. Catalog the backup pieces. On the RMAN command line, type the following command to catalog the backup pieces.

RMAN> catalog device type 'sbt_tape' backuppiece '151527_UXDBP_8tqj2atq_1_1','151527_UXDBP_8uqj2atu_1_1','151780_UXDBP_9fqj4ao4_1_1','151780_UXDBP_9gqj4aq6_1_1','151780_UXDBP_9hqj4arj_1_1';

 

released channel: ORA_SBT_TAPE_1

allocated channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: SID=148 device type=SBT_TAPE

channel ORA_SBT_TAPE_1: CommVault Systems for Oracle: Version 10.0.0(BUILD116)

cataloged backup piece

backup piece handle=151527_UXDBP_8tqj2atq_1_1 RECID=33977 STAMP=892483390

cataloged backup piece

backup piece handle=151527_UXDBP_8uqj2atu_1_1 RECID=33978 STAMP=892483390

cataloged backup piece

backup piece handle=151780_UXDBP_9fqj4ao4_1_1 RECID=33979 STAMP=892483390

cataloged backup piece

backup piece handle=151780_UXDBP_9gqj4aq6_1_1 RECID=33980 STAMP=892483390

cataloged backup piece

backup piece handle=151780_UXDBP_9hqj4arj_1_1 RECID=33981 STAMP=892483390

 

RMAN> catalog device type 'sbt_tape' backuppiece '151780_UXDBP_9jqj4au4_1_1','151780_UXDBP_9kqj4ava_1_1','c-4167489344-20151006-06','c-4167489344-20151007-04','c-4167489344-20151007-05';

 

released channel: ORA_SBT_TAPE_1

allocated channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: SID=148 device type=SBT_TAPE

channel ORA_SBT_TAPE_1: CommVault Systems for Oracle: Version 10.0.0(BUILD116)

cataloged backup piece

backup piece handle=151780_UXDBP_9jqj4au4_1_1 RECID=33982 STAMP=892483493

cataloged backup piece

backup piece handle=151780_UXDBP_9kqj4ava_1_1 RECID=33983 STAMP=892483493

cataloged backup piece

backup piece handle=c-4167489344-20151006-06 RECID=33984 STAMP=892483493

cataloged backup piece

backup piece handle=c-4167489344-20151007-04 RECID=33985 STAMP=892483493

cataloged backup piece

backup piece handle=c-4167489344-20151007-05 RECID=33986 STAMP=892483493

  1. Restores from application free restore:

RMAN> restore controlfile to '/tmp/ctrlfile.restored'  from  'c-4167489344-20151007-04' ;

 

Starting restore at Oct 07 2015 16:13:09

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=133 device type=DISK

using channel ORA_SBT_TAPE_1

 

channel ORA_DISK_1: no AUTOBACKUP in 7 days found

channel ORA_SBT_TAPE_1: restoring control file

channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:08

Finished restore at Oct 07 2015 16:13:20.

Reply