Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, August 11, 2015

rman take full database backup


Here we will take the whole database backup and keep it forever.

[oracle@collabn1 config]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Aug 4 14:47:27 2015

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

RMAN> connect catalog rcuser/rcuser@prod1;

connected to recovery catalog database

RMAN> connect target /

connected to target database: ORCL (DBID=1414564590)

RMAN> run {
2> allocate channel ch01 type disk format "/home/oracle/sshaik/backup/orcl-backup-%U.bak";
3> backup database plus archivelog keep forever tag "long01";
4> }

allocated channel: ch01
channel ch01: SID=30 device type=DISK


Starting backup at 04-AUG-15
current log archived
backup will never be obsolete
archived logs required to recover from this backup will be backed up
channel ch01: starting archived log backup set
channel ch01: specifying archived log(s) in backup set
input archived log thread=1 sequence=7 RECID=1 STAMP=886865277
input archived log thread=1 sequence=8 RECID=2 STAMP=886865398
channel ch01: starting piece 1 at 04-AUG-15
channel ch01: finished piece 1 at 04-AUG-15
piece handle=/home/oracle/sshaik/backup/orcl-backup-04qdovfm_1_1.bak tag=LONG01 comment=NONE
channel ch01: backup set complete, elapsed time: 00:00:01
Finished backup at 04-AUG-15

Starting backup at 04-AUG-15
channel ch01: starting full datafile backup set
channel ch01: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA2/orcl/system01.dbf
input datafile file number=00002 name=+DATA2/orcl/sysaux01.dbf
input datafile file number=00003 name=+DATA2/orcl/undotbs01.dbf
input datafile file number=00005 name=+DATA2/orcl/example01.dbf
input datafile file number=00004 name=+DATA2/orcl/users01.dbf
channel ch01: starting piece 1 at 04-AUG-15
channel ch01: finished piece 1 at 04-AUG-15
piece handle=/home/oracle/sshaik/backup/orcl-backup-05qdovfo_1_1.bak tag=TAG20150804T153000 comment=NONE
channel ch01: backup set complete, elapsed time: 00:00:07
Finished backup at 04-AUG-15

Starting backup at 04-AUG-15
current log archived
backup will never be obsolete
archived logs required to recover from this backup will be backed up
channel ch01: starting archived log backup set
channel ch01: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=3 STAMP=886865407
channel ch01: starting piece 1 at 04-AUG-15
channel ch01: finished piece 1 at 04-AUG-15
piece handle=/home/oracle/sshaik/backup/orcl-backup-06qdovg0_1_1.bak tag=LONG01 comment=NONE
channel ch01: backup set complete, elapsed time: 00:00:01
Finished backup at 04-AUG-15

Starting Control File and SPFILE Autobackup at 04-AUG-15
piece handle=+DATA2/orcl/autobackup/2015_08_04/s_886865409.287.886865409 comment=NONE
Finished Control File and SPFILE Autobackup at 04-AUG-15
released channel: ch01

RMAN>


RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
69      B  F  A DISK        04-AUG-15       1       1       NO         TAG20150804T152113
70      B  F  A DISK        04-AUG-15       1       1       NO         TAG20150804T152121
104     B  A  A DISK        04-AUG-15       1       1       NO         LONG01
105     B  F  A DISK        04-AUG-15       1       1       NO         TAG20150804T153000
125     B  A  A DISK        04-AUG-15       1       1       NO         LONG01
140     B  F  A DISK        04-AUG-15       1       1       NO         TAG20150804T153009

No comments: