Solved

error rman

Posted on 2014-04-08
4
612 Views
Last Modified: 2014-10-14
RMAN:/vsr/apps/config/rman_networker_daily_full_pbBAOPRE.sql with following message recorded in error log

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 04/07/2014 01:34:26

RMAN-03009: failure of backup command on t1 channel at 04/07/2014 01:18:29
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on t7 channel at 04/07/2014 01:18:29
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on t3 channel at 04/07/2014 01:18:29
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on t2 channel at 04/07/2014 01:18:29
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on t4 channel at 04/07/2014 01:18:29
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on t1 channel at 04/07/2014 01:18:29
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on t5 channel at 04/07/2014 01:18:29
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on t6 channel at 04/07/2014 01:18:29
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
0
Comment
Question by:tonydba
[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
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39987335
It appears the database you are trying to back up is not in archive log mode.
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 39987337
You have told RMAN to backup a database and archivelogs (plus archivelog in your backup command) and the database is in NOARCHIVELOG mode.

You can't do that.

Either remove PLUS ARCHIVELOGS from the backup command or put the database into archivelog mode.
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39987376
>>Either remove PLUS ARCHIVELOGS

More than just that.  You cannot do a hot backup of a database unless it is in archive log mode.  So the decision is to do a cold backup or put the database in archive log mode.
0
 

Author Closing Comment

by:tonydba
ID: 40381298
changed the archive log as you commented.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

617 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