Solved

error rman

Posted on 2012-03-10
1
1,191 Views
Last Modified: 2012-06-27
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>
0
Comment
Question by:b7dba
1 Comment
 
LVL 4

Accepted Solution

by:
VictorTarasov earned 500 total points
ID: 37706070
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question