ORA-19625 and ORA-27037 Perform Archive Backup

The backup team sent me the following error when they run an archive backup.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 10/29/2015 12:18:45
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file $1$dtb277:[000000.][faxes]log_faxes_1_12376_677956094.arc
ORA-27037: unable to obtain file status
HP IPF VMS
Error: 16: mount device busy

The problem is that this particular file is on a disk that has had to be removed due to an error. The issue is that you can not mount the drive because its name is being used by another disk. System team using their magic, manages to move the file to another disk, while not presenting the disk to the rest of user into the system. Once the file is in another location, and using RMAN catalog it is as easy as follows. First we connect to the database backup and catalog;

RMAN> catalog archivelog '$1$dtb277:[000000.][faxes]log_faxes_1_12376_677956094.arc';
cataloged archive log
archive log filename=$1$dtb277:[000000.][faxes]log_faxes_1_12376_677956094.arc recid=12383 stamp=894372030

HTH – Antonio NAVARRO

Advertisements

ORA-16038, ORA-19504, ORA-16014 And ORA-00312 Errors

This last night has appeared the following error in a alert.log file.

Thu Oct 15 03:18:38 2015
ARC0: Error 19504 Creating archive log file to '+SAPPRD_ARCSAPPRD2_DG'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance SAP02 - Archival Error
ORA-16038: log 5 sequence# 20105 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 5 thread 2: '+SAPPRD_DG/SAPprd/onlinelog/group_5.266.811070321'
Thu Oct 15 03:18:38 2015
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance SAP02 - Archival Error
ORA-16014: log 5 sequence# 20105 not archived, no available destinations
ORA-00312: online log 5 thread 2: '+SAPPRD_DG/SAPprd/onlinelog/group_5.266.811070321'
Thu Oct 15 03:18:53 2015
Thread 2 advanced to log sequence 20107 (LGWR switch)
  Current log# 4 seq# 20107 mem# 0: +SAPPRD_DG/SAPprd/onlinelog/group_4.265.811070317
Thu Oct 15 03:18:53 2015

The problem seems to be that failed to access to the ASM, as has regained access to it has solved the problem.

HTH – Antonio NAVARRO

What Is Out-of-place Upgrade?

When we perform an upgrade on Oracle we have two basically two options for binary or database engine.

  • Use out-of-place Upgrade, this is to install another ORACLE_HOME binaries
  • Use In-place Upgrade, this is to use the existing ORACLE_HOME.

The advantage of the first over the second is if you have to backtrack. We only would have to use theĀ old binary (ORACLE_HOME previous to the upgrade), depending on the version of Oracle, run the script catalog.sql or script indicated by the version forback the upgrade to the previous version.

HTH – Antonio NAVARRO