7 Replies Latest reply: Nov 9, 2012 12:04 PM by Venkadesh Raja RSS

    Error while Backup

    Venkadesh Raja
      Hi Experts,


      When i try to take backup via. i'm getting this error :( . Pls Help
      C:\oracle\product\10.2.0\db_3\BIN>rman target /
      
      Recovery Manager: Release 10.2.0.1.0 - Production on Fri Nov 9 22:30:33 2012
      
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      
      connected to target database: TEST (DBID=2095219496)
      
      RMAN> backup database;
      
      Starting backup at 09-NOV-12
      using target database control file instead of recovery catalog
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=141 devtype=DISK
      channel ORA_DISK_1: starting full datafile backupset
      channel ORA_DISK_1: specifying datafile(s) in backupset
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/09/2012 22:32:
      18
      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 backupset
      channel ORA_DISK_1: specifying datafile(s) in backupset
      including current control file in backupset
      including current SPFILE in backupset
      channel ORA_DISK_1: starting piece 1 at 09-NOV-12
      channel ORA_DISK_1: finished piece 1 at 09-NOV-12
      piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2012_11
      _09\O1_MF_NCSNF_TAG20121109T223217_89TFRXYP_.BKP tag=TAG20121109T223217 comment=
      NONE
      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:06
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/09/2012 22:32:
      18
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      
      RMAN>
      i'm not dba.i'm just learning dba using my home system
        • 1. Re: Error while Backup
          sb92075
          19602, 00000, "cannot backup or copy active file in NOARCHIVELOG mode"
          // *Cause:  You tried to copy or backup a file that was not closed cleanly,
          //          and the database was in NOARCHIVELOG mode.  This is not allowed
          //          because when restored, the file will require redo application
          //          before it is usable, and redo is not currently being saved
          //          beyond the contents of the online redo logs.
          // *Action: Take the tablespace offline clean or close the database and retry
          //          the copy or backup.
          • 2. Re: Error while Backup
            Venkadesh Raja
            // *Action: Take the tablespace offline clean or close the database and retry
            // the copy or backup.
            How can i do that ? Pls i dono how to do
            • 3. Re: Error while Backup
              sb92075
              Venkadesh wrote:
              // *Action: Take the tablespace offline clean or close the database and retry
              // the copy or backup.
              How can i do that ? Pls i dono how to do
              SQL> SHUTDOWN IMMEDIATE
              • 4. Re: Error while Backup
                Osama_Mustafa
                This error happened when The database is currently open and in NOARCHIVELOG mode. Because of this RMAN cannot backup the datafiles as they are open.

                Read
                ORA-19602 Using RMAN to Backup Database [ID 246183.1]
                • 5. Re: Error while Backup
                  Shivananda Rao
                  Hello,

                  Your database is running in NOARCHIVE mode. You have two options here:

                  1. Either place your database in archive log mode and then take the backup.
                  SQL>alter system set log_archive_dest_1='location=<location where you want the database to generate the archives>';
                  SQL>shut immediate
                  SQL>startup mount
                  SQL>alter database archivelog;
                  SQL>alter database open;
                  Now take the backup of the database through RMAN.

                  2. If you do not want to have your database in archivelog mode, then take the backup of the database through RMAN when the database is in mount mode.
                  SQL>shut immediate
                  SQL>startup mount
                  Now take the backup of the database through RMAN and once done, open the database.

                  It is recommended to take the backup by placing the database in archivelog mode.
                  • 6. Re: Error while Backup
                    Levi Pereira
                    Hi,

                    You are trying do a inconsistent backup with archivelog mode disabled. It's not possible.

                    You must do a consistent backup with database mounted (i.e all datafiles closed).

                    Try it:
                    RMAN> shudown immediate;
                    RMAN> startup mount;
                    RMAN>  backup database including current controlfile;
                    RMAN>  startup;
                    http://docs.oracle.com/cd/E11882_01/server.112/e10897/backrest.htm#CHDHEJBA

                    Or enable archive log log mode to be able make a online backup.

                    http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo002.htm#i1006184
                    • 7. Re: Error while Backup
                      Venkadesh Raja
                      Thank you so much for all :).