2 Replies Latest reply: Jan 27, 2013 7:38 PM by Hemant K Chitale RSS

    RMAN Backup Failed.

    987351
      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
          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
            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