RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
During running the RMAN backup, i am getting the following error:
RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
Error:
RMAN-00571: =======================================================
RMAN-03002: failure of backup command at 03/08/2019 15:04:32
RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
Cause:
Database is in NO ARCHIVE mode. If database is in no-archive mode then we cannot run the online or hot backup with RMAN utility provided by Oracle. Check with following command:
select log_mode from V$database;
LOG_MODE
------------
NOARCHIVELOG
Solution:
Bring the Database in Archive Mode. this process need to bring the database down and start again. So we need the downtime if it is in critical environment.
1. Shutdown the Database
SQL>shutdown immediate;
database closed
database dismounted
Oracle instance shut down
2. Open the Database Up-to mount stage.
SQL> Startup Mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 1610609384 bytes
Fixed Size 9028328 bytes
Variable Size 402653184 bytes
Database Buffers 1191182336 bytes
Redo Buffers 7745536 bytes
3. Enable the Archive log
alter database archivelog;
4. Check destination parameter and change value for archive generation.
-- check
show parameter log_archive_dest
–change value
alter system set log_archive_dest=’D:\Oracle’ scope=both;
5. Open the database.
alter database open;
6. Verify the archive generation by checking the location.
alter system switch logfile;
Disable the Archive Mode:
Rollback Process:
Shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;