Wednesday, 14 August 2013

Taking cold backup for database running on ASM using RMAN in EXADATA

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

1.Start the 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@acldx0041 12Aug]$ rman target /

Recovery Manager: Release - Production on Wed Aug 14 05:53:43 2013

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

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

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

Starting backup at 14-AUG-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1522 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=797410838
input archived log thread=1 sequence=58 RECID=106 STAMP=797407220
input archived log thread=1 sequence=59 RECID=108 STAMP=797439625
input archived log thread=2 sequence=56 RECID=109 STAMP=797455353
input archived log thread=1 sequence=60 RECID=112 STAMP=797464816

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

SQL> alter database open;

Database altered.

No comments:

Post a Comment