Backup consistent database with RMAN

Backing up a Database in Consistent State with RMAN

Possible to take Backup the database with RMAN when database is in no archive mode as similar to consistent backup with RMAN. We can take RMAN consistent backup when Oracle database is in mount state. A consistent backup occurs when the database is normal shutdown 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 for consistent with following commands:

RMAN> shutdown immediate;
OR
RMAN> Shutdown
Note: If during shutdown process your database is hanged then follow 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 the database
RMAN> BACKUP DATABASE;
--For creating image copy as copy paste in windows
RMAN> BACKUP AS COPY DATABASE;

5. After finish database need to open

RMAN> 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s