i'm not dba.i'm just learning dba using my home system
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>
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.
SQL>alter system set log_archive_dest_1='location=<location where you want the database to generate the archives>';Now take the backup of the database through RMAN.
SQL>alter database archivelog;
SQL>alter database open;
SQL>shut immediateNow take the backup of the database through RMAN and once done, open the database.
RMAN> shudown immediate; RMAN> startup mount; RMAN> backup database including current controlfile; RMAN> startup;