Solved

error rman

Posted on 2014-04-08
4
574 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
  • 2
4 Comments
 
LVL 76

Expert Comment

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

Expert Comment

by:Steve Wales
Comment Utility
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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
>>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
Comment Utility
changed the archive log as you commented.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

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…
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…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now