5 Replies Latest reply on Apr 11, 2018 9:51 AM by Shaik Ahmed Ali Bajubair

    ORA-1126 signalled during: ALTER DATABASE ARCHIVELOG... while DUPLICATE

    3138225

      On Oracle Enterprise 11.2.0.4 on linux RedHat 6

       

       

      While duplicate database from backup we've got this error:

      ORA-1126 signalled during: ALTER DATABASE ARCHIVELOG...

       

       

      It seems that this error occurs while rman is executing:

      contents of Memory Script:

      {

         Alter clone database open resetlogs;

      }

      executing Memory Script

       

       

       

       

      This error only appears in alert.log file.

       

       

      Extract of alert.log:

      ---------------------

      Dictionary check complete

      Verifying file header compatibility for 11g tablespace encryption..

      Verifying 11g file header compatibility for tablespace encryption completed

      SMON: enabling tx recovery

      Re-creating tempfile /appli/oracle/SIKAPADB/oradata03/SIKAPADB_temp_01.dbf

      ORA-01565: Unable to open Spfile /logiciels/oracle/oradb/11.2.0.m/ora/dbs/spfileSIKAPADB.ora.

      ORA-01565: Unable to open Spfile /logiciels/oracle/oradb/11.2.0.m/ora/dbs/spfileSIKAPADB.ora.

      ORA-01565: Unable to open Spfile /logiciels/oracle/oradb/11.2.0.m/ora/dbs/spfileSIKAPADB.ora.

      ORA-01565: Unable to open Spfile /logiciels/oracle/oradb/11.2.0.m/ora/dbs/spfileSIKAPADB.ora.

      ORA-01565: Unable to open Spfile /logiciels/oracle/oradb/11.2.0.m/ora/dbs/spfileSIKAPADB.ora.

      ORA-01565: Unable to open Spfile /logiciels/oracle/oradb/11.2.0.m/ora/dbs/spfileSIKAPADB.ora.

      ORA-01565: Unable to open Spfile /logiciels/oracle/oradb/11.2.0.m/ora/dbs/spfileSIKAPADB.ora.

      ORA-01565: Unable to open Spfile /logiciels/oracle/oradb/11.2.0.m/ora/dbs/spfileSIKAPADB.ora.

      Re-creating tempfile /appli/oracle/SIKAPADB/oradata01/PATROL_TEMP_01.dbf

      Database Characterset is AL32UTF8

      No Resource Manager plan active

      replication_dependency_tracking turned off (no async multimaster replication found)

      ALTER DATABASE ARCHIVELOG

      ORA-1126 signalled during: ALTER DATABASE ARCHIVELOG...

      Starting background process QMNC

      Thu Mar 01 12:26:28 2018

      QMNC started with pid=28, OS id=12094

      LOGSTDBY: Validating controlfile with logical metadata

      LOGSTDBY: Validation complete

      Global Name changed to SIKAPADB

      Completed: alter database open resetlogs

       

       

       

       

      No error  appears in rman log

      The database is in archivelog before executing duplicate.