error rman

RMAN> backup full database format '/u01/app/backup/%d_%U.bkp' plus archivelog format '/u01/app/backup/%d_%U.bkp';


Starting backup at 10-MAR-12
ORACLE error from target database:
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
specification does not match any archive log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 10-MAR-12

Starting backup at 10-MAR-12
using channel ORA_DISK_1
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 03/10/2012 19:20:31
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
channel ORA_DISK_1: starting piece 1 at 10-MAR-12
channel ORA_DISK_1: finished piece 1 at 10-MAR-12
piece handle=/u01/app/backup/TEST_02n5hujv_1_1.bkp tag=TAG20120310T192031 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 03/10/2012 19:20:43

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/10/2012 19:20:31
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

RMAN>
b7dbaAsked:
Who is Participating?
 
Victor TarasovConnect With a Mentor Head of the Department of System AdministrationCommented:
You must enable database in  archivelog mode.

shutdown database

SQL> shutdown immediate;

startup database in mount mode

SQL> startup mount;

Change DB log mode

SQL> alter database archivelog;

Open DB for normal use

SQL> alter database open;

check archivelog status

SQL> archive log list
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.