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:

AWS Certified Solutions Architect Associate

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

Wednesday, July 21, 2010

RMAN Full DISK BACKUP

labrman01(RCAT) /ora_backup/datafile
>rman

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jul 21 10:38:33 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN> connect target sys/syspwd@HYPP

connected to target database: HYPP (DBID=2563884143)

RMAN> connect catalog rcat10g/rcat10g@RCAT

connected to recovery catalog database

RMAN> run{
allocate channel ch01 type disk format '/ora_backup/backups/HYPP/HYPP_Full_%u_%s_%U';
backup database include current controlfile;
sql 'alter system archive log current';
backup archivelog all delete input;
}

released channel: ORA_DISK_1
allocated channel: ch01
channel ch01: sid=1079 devtype=DISK

Starting backup at 21-JUL-10
channel ch01: starting full datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00006 name=/adm02/u0001/oracle/datafile/HYPP/hypp_data_01.dbf
input datafile fno=00002 name=/adm02/u0001/oracle/datafile/HYPP/undo_01.dbf
input datafile fno=00008 name=/adm02/u0001/oracle/datafile/HYPP/hypp_bi_01.dbf
input datafile fno=00001 name=/adm02/u0001/oracle/datafile/HYPP/system01.dbf
input datafile fno=00003 name=/adm02/u0001/oracle/datafile/HYPP/sysaux01.dbf
input datafile fno=00009 name=/adm02/u0001/oracle/datafile/HYPP/hypp_apps_01.dbf
input datafile fno=00004 name=/adm02/u0001/oracle/datafile/HYPP/users01.dbf
input datafile fno=00005 name=/adm02/u0001/oracle/datafile/HYPP/tools_01.dbf
input datafile fno=00010 name=/adm02/u0001/oracle/datafile/HYPP/hyp_hal_data_01.dbf
input datafile fno=00007 name=/adm02/u0001/oracle/datafile/HYPP/hypp_idx_01.dbf
channel ch01: starting piece 1 at 21-JUL-10
hannel ch01: finished piece 1 at 21-JUL-10
piece handle=/ora_backup/backups/HYPP/HYPP_Full_tnljb89m_6071_tnljb89m_1_1 tag=TAG20100721T104925 comment=NONE
channel ch01: backup set complete, elapsed time: 00:01:05
channel ch01: starting full datafile backupset
channel ch01: specifying datafile(s) in backupset
including current control file in backupset
channel ch01: starting piece 1 at 21-JUL-10
channel ch01: finished piece 1 at 21-JUL-10
piece handle=/ora_backup/backups/HYPP/HYPP_Full_toljb8bn_6072_toljb8bn_1_1 tag=TAG20100721T104925 comment=NONE
channel ch01: backup set complete, elapsed time: 00:00:02
Finished backup at 21-JUL-10

Starting Control File Autobackup at 21-JUL-10
piece handle=/adm02/u0001/oracle/product/10.2.0/db_1/dbs/c-2563884143-20100721-01 comment=NONE
Finished Control File Autobackup at 21-JUL-10

sql statement: alter system archive log current

Starting backup at 21-JUL-10
current log archived
channel ch01: starting archive log backupset
channel ch01: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=1673 stamp=724874462
input archive log thread=1 sequence=2 recid=1674 stamp=724934781
input archive log thread=1 sequence=3 recid=1675 stamp=724934785
input archive log thread=1 sequence=4 recid=1676 stamp=724935048
input archive log thread=1 sequence=5 recid=1677 stamp=724935052
channel ch01: starting piece 1 at 21-JUL-10
channel ch01: finished piece 1 at 21-JUL-10
piece handle=/ora_backup/backups/HYPP/HYPP_Full_tqljb8cg_6074_tqljb8cg_1_1 tag=TAG20100721T105055 comment=NONE
channel ch01: backup set complete, elapsed time: 00:00:08
channel ch01: deleting archive log(s)
archive log filename=/adm02/u8001/HYPP/arch/arch_HYPQ_0001_0000000001_0724872404.arc recid=1673 stamp=724874462
archive log filename=/adm02/u8001/HYPP/arch/arch_HYPQ_0001_0000000002_0724872404.arc recid=1674 stamp=724934781
archive log filename=/adm02/u8001/HYPP/arch/arch_HYPQ_0001_0000000003_0724872404.arc recid=1675 stamp=724934785
archive log filename=/adm02/u8001/HYPP/arch/arch_HYPQ_0001_0000000004_0724872404.arc recid=1676 stamp=724935048
archive log filename=/adm02/u8001/HYPP/arch/arch_HYPQ_0001_0000000005_0724872404.arc recid=1677 stamp=724935052
Finished backup at 21-JUL-10

Starting Control File Autobackup at 21-JUL-10
piece handle=/adm02/u0001/oracle/product/10.2.0/db_1/dbs/c-2563884143-20100721-02 comment=NONE
Finished Control File Autobackup at 21-JUL-10
released channel: ch01

RMAN>

No comments: