This discussion is archived
2 Replies Latest reply: Jan 27, 2013 5:38 PM by Hemant K Chitale RSS

RMAN Backup Failed.

987351 Newbie
Currently Being Moderated
Hi Gurus,

My RMAN backup failed with below error.Please suggest.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 01/26/2013 22:48:56
RMAN-11003: failure during parse/execution of SQL statement: alter system archive log current
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log

RMAN>

Recovery Manager complete.

Thanks,
  • 1. Re: RMAN Backup Failed.
    ora_tech Expert
    Currently Being Moderated
    Hi,

    Welcome 2 Oracle Forums :)
    ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
    Make sure that your database is in archivelog mode.

    thanks,
    X A H E E R
  • 2. Re: RMAN Backup Failed.
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    The message indicates that your database is in NOARCHIVELOG mode. You cannot make an RMAN Backup of a database that is OPEN if it is in NOARCHIVELOG mode.

    You have two options
    1. Make consistent RMAN Backups with the database only in MOUNT mode (SHUTDOWN ; STARTUP MOUNT)
    OR
    2. Configure for ArchiveLogs (create a target filesystem or FRA), set the database to ARCHIVELOG mode, monitor the volume of ArchiveLog generation, configure both Database and ArchiveLog backups.



    Hemant K Chitale

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points