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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.

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: