ORA-00258: Manual Archiving in NOARCHIVELOG mode must identify log.

ORA-00258: Manual Archiving in NOARCHIVELOG mode must identify log.
May 6, 2019

Problem:
Trying to do full backup of an Oracle database using RMAN.
Get the above error.

Here is the entire seq of errors before RMAN kicks out.
RMAN>
Starting backup at 14-APR-18
ORACLE error from target database:
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
specification does not match any archived log in the repository
backup cancelled because there are no files to backup
Finished backup at 14-APR-18

Solution:
Basically the DB is in a NOARCHIEVLOG mode and we cannot backup the DB without specifying Log Seq Number.

Restarting the Database in a ARCHIEVLOG mode.

Using SQL*Plus to Change the Database Archiving Mode

1: Connect to DB as SYSDBA
SQLPLUS ‘/as sysdba’

2:SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

3: Start the instance and mount the database:
    SQL> STARTUP MOUNT
ORACLE instance started.
Database mounted.

4: Place the database in ARCHIVELOG mode
SQL> ALTER DATABASE ARCHIVELOG;
Database altered.

5: Open Database
SQL> ALTER DATABASE OPEN;
Database altered.

6: Verify your changes:
SQL>ARCHIVE LOG LIST

Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u05/oradata/flash_recovery_area/xxxx/archivelog/
Oldest online log sequence xxxxxx
Next log sequence to archive xxxxxx
Current log sequence xxxxxxx

As you can see the Archievlog is enabled.
No we try to do a backup again using RMAN.
The backup, using RMAN, works.

Prakash

Leave a Reply

Your email address will not be published. Required fields are marked *