This discussion is archived
7 Replies Latest reply: Nov 9, 2012 10:04 AM by Venkadesh Raja RSS

Error while Backup

Venkadesh Raja Pro
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    // *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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    Thank you so much for all :).

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points