Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

error rman

Posted on 2012-03-10
1
Medium Priority
?
1,300 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 4

Accepted Solution

by:
Victor Tarasov earned 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

610 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