4 Replies Latest reply: Sep 17, 2013 8:36 AM by user12075536123 RSS

    RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/16/2013

    Dan8

      Hi all !

       

      I've attempted to backup my database using RMAN but i got the ERROR that follows:

       

      RMAN> backup database;

       

      output:


      Starting backup at 16-SEP-13

      using target database control file instead of recovery catalog

      allocated channel: ORA_DISK_1

      channel ORA_DISK_1: SID=20 device type=DISK

      channel ORA_DISK_1: starting full datafile backup set

      channel ORA_DISK_1: specifying datafile(s) in backup set

      input datafile file number=00001 name=/u01/app/oracle/oradata/db11gr2/system01.dbf

      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/16/2013 17:10:17

      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

      continuing other job steps, job failed will not be re-run

      channel ORA_DISK_1: starting full datafile backup set

      channel ORA_DISK_1: specifying datafile(s) in backup set

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/16/2013 17:10:17

      ORA-00237: snapshot operation disallowed: control file newly created

       

       

      To verify the database status I runned:

      1.

      SQL> select STATUS, DATABASE_STATUS from v$instance;

       

      output:

       

      STATUS       DATABASE_STATUS

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

      MOUNTED      ACTIVE

       

      Then:

      2.

      SQL> select CONTROLFILE_CREATED, CONTROLFILE_TIME, CONTROLFILE_TYPE, RESETLOGS_TIME from v$database;

       

      Output:

       

      CONTROLFI CONTROLFI CONTROL RESETLOGS

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

      03-JUL-13 12-SEP-13 CURRENT 03-JUL-13

       

      Last line of output reads : ORA-00237: snapshot operation disallowed: control file newly created

      but I didn't get it. Please help me to resolve the issue.

       

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

       

      I've used the Oracle Entreprise Manager for attempting again to restore and recover but got what that follow.

      plus let me what should I do from that image. Please click link below.

       

      https://drive.google.com/folderview?id=0By7GAjmfUoMTSllCRjVMOGlrdTg&usp=sharing

       

      Thanks.

      Dan.

        • 2. Re: RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/16/2013
          user10201385

          Could you please post the below commands output.


          select STATUS, DATABASE_STATUS from v$instance;

          select CONTROLFILE_CREATED, CONTROLFILE_TIME, CONTROLFILE_TYPE, RESETLOGS_TIME from v$database;

          • 3. Re: RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/16/2013
            nagulan.selvakumar

            Hi,


            ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode


            The error states that your database runs in NOARCHIVELOG mode. RMAN can't backup an open database in noarchivelog mode as recovery would be incomplete. Either turn your database to ARCHIVELOG mode and take a backup or mount your database and take a backup in the same setup.

             

            Thank you!!

            • 4. Re: RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/16/2013
              user12075536123

              please try


              # sqlplus
              alter database open;
              shutdown immediate
              startup mount


              # rman
              backup database;

               

              =====================================================

              I tested


              # sqlplus
              # -----------------------------------------
              SQL> archive log list
              Database log mode              No Archive Mode
              Automatic archival             Disabled
              Archive destination            USE_DB_RECOVERY_FILE_DEST
              Oldest online log sequence     3
              Current log sequence           5


              SQL> create table a(b date);


              Table created.


              SQL> insert into a(b) values (sysdate);


              1 row created.


              SQL> commit;


              Commit complete.


              SQL> shutdown abort
              ORACLE instance shut down.


              SQL> startup mount
              ORACLE instance started.


              Total System Global Area  612368384 bytes
              Fixed Size                  1250452 bytes
              Variable Size             180357996 bytes
              Database Buffers          427819008 bytes
              Redo Buffers                2940928 bytes
              Database mounted.
              # -----------------------------------------


              # rman
              # -----------------------------------------
              RMAN> backup database;


              Starting backup at 17-SEP-13
              allocated channel: ORA_DISK_1
              channel ORA_DISK_1: sid=156 devtype=DISK
              channel ORA_DISK_1: starting full datafile backupset
              channel ORA_DISK_1: specifying datafile(s) in backupset
              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/17/2013 22:27:57
              ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
              # -----------------------------------------


              # sqlplus
              # -----------------------------------------
              SQL> alter database open;


              Database altered.


              SQL> shutdown immediate
              Database closed.
              Database dismounted.
              ORACLE instance shut down.
              SQL> startup mount
              ORACLE instance started.


              Total System Global Area  612368384 bytes
              Fixed Size                  1250452 bytes
              Variable Size             184552300 bytes
              Database Buffers          423624704 bytes
              Redo Buffers                2940928 bytes
              Database mounted.
              # -----------------------------------------


              # rman
              # -----------------------------------------
              RMAN> backup database;


              Starting backup at 17-SEP-13
              allocated channel: ORA_DISK_1
              channel ORA_DISK_1: sid=156 devtype=DISK
              channel ORA_DISK_1: starting full datafile backupset
              channel ORA_DISK_1: specifying datafile(s) in backupset
              input datafile fno=00001 name=C:\ORADATA\ORCL\SYSTEM01.DBF
              input datafile fno=00003 name=C:\ORADATA\ORCL\SYSAUX01.DBF
              input datafile fno=00005 name=C:\ORADATA\ORCL\EXAMPLE01.DBF
              input datafile fno=00002 name=C:\ORADATA\ORCL\UNDOTBS01.DBF
              input datafile fno=00004 name=C:\ORADATA\ORCL\USERS01.DBF
              channel ORA_DISK_1: starting piece 1 at 17-SEP-13
              ・・・
              # -----------------------------------------