RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode

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;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.