Backing up a Database in a Consistent State with RMAN

Possible to back up the database with RMAN when the database is in no archive mode similar to consistent backup with RMAN. We can take RMAN consistent backup when the Oracle database is mounted. A consistent backup occurs when the database is normally shut down with commands: SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL.

Steps for taking Consistent backup with RMAN:

1. Start RMAN and connect to a target database.

RMAN target sys@orcl

2. Clean Shut down the database consistent with the following commands:

RMAN> shutdown immediate;
OR
RMAN> Shutdown
Note: If during the shutdown process your database is hanged then follow the following commands:
RMAN> STARTUP FORCE DBA;
RMAN> SHUTDOWN IMMEDIATE;

3. Start the database in startup mount:

RMAN> STARTUP MOUNT;

4. Use the following command at the RMAN prompt to back up the database:

— For backup of the database
RMAN> BACKUP DATABASE;
–For creating image copy as copy-paste in windows
RMAN> BACKUP AS COPY DATABASE;

5. After finishing the database, you need to open

RMAN> ALTER DATABASE OPEN;