Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 657
  • Last Modified:

error rman

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
tonydba
Asked:
tonydba
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
It appears the database you are trying to back up is not in archive log mode.
0
 
Steve WalesSenior Database AdministratorCommented:
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
 
slightwv (䄆 Netminder) Commented:
>>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
 
tonydbaAuthor Commented:
changed the archive log as you commented.
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now