How to make a cold backup for database running on ASM ( using RMAN )

Many a times, you will come in a situation… Or they may ask you in Interview that how to take a cold backup using RMAN.

You heard Right, Cold backup using RMAN…

Using RMAN Utility, we can perform the backup in MOUNT mode.

Lets see…

Follow the below steps to take cold back of database running on ASM.

1.Start the instances in all the nodes in mount stage.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1.7504E+10 bytes

Fixed Size                  2235448 bytes

Variable Size            4429185992 bytes

Database Buffers         1.3019E+10 bytes

Redo Buffers               53477376 bytes

Database mounted.

2.Connect RMAN from any node and take the backup as below.

[oracle@backupServer ]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Mon May 2 05:53:43 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SPSHIDMP (DBID=465850406, not open)

RMAN> backup device type disk format '/backupServer/test/rman_backup_43/backup/%U' database plus archivelog;

Starting backup at 02-MAY-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=4566 instance=spshidmp1 device type=DISK

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=2 sequence=55 RECID=107 STAMP=783110838

input archived log thread=1 sequence=58 RECID=106 STAMP=783107220

input archived log thread=1 sequence=59 RECID=108 STAMP=783139625

input archived log thread=2 sequence=56 RECID=109 STAMP=783155353

input archived log thread=1 sequence=60 RECID=112 STAMP=783164816

3.Once done, start the instances on all the nodes.

SQL> alter database open;

Database altered

We can take a database Backup using RMAN in Mount, this will be said as COLD-BACKUP