ORA-00258: Manual Archiving in NOARCHIVELOG mode must identify log.
May 6, 2019
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.
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
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
ORACLE instance shut down.
3: Start the instance and mount the database:
SQL> STARTUP MOUNT
ORACLE instance started.
4: Place the database in ARCHIVELOG mode
SQL> ALTER DATABASE ARCHIVELOG;
5: Open Database
SQL> ALTER DATABASE OPEN;
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.