oracledb1-> rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Thu May 15 12:47:34 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DGPRD (DBID=223112954)
RMAN> run {
2> #Shutdown Target Database DGPRD For Cold Backup
3> shutdown immediate
4> #Startup Mount, Once the Cold Backup Finishes
5> startup mount
6> #Allocate Channel Now
7> allocate channel c1 TYPE DISK;
8> BACKUP DATABASE FORMAT '/oradata/rman/%d_COLD_%u';
9> #One Backup Completes - Open the database
10> sql 'alter database open';
11> backup current controlfile;
12> sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE';
13> release channel c1;
14> }
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 167772160 bytes
Fixed Size 1260696 bytes
Variable Size 88081256 bytes
Database Buffers 75497472 bytes
Redo Buffers 2932736 bytes
allocated channel: c1
channel c1: sid=157 devtype=DISK
Starting backup at 15-MAY-07
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=/oradata/dgprd/system01.dbf
input datafile fno=00003 name=/oradata/dgprd/sysaux01.dbf
input datafile fno=00005 name=/oradata/dgprd/example01.dbf
input datafile fno=00002 name=/oradata/dgprd/undotbs01.dbf
input datafile fno=00004 name=/oradata/dgprd/users01.dbf
channel c1: starting piece 1 at 15-MAY-07
channel c1: finished piece 1 at 15-MAY-07
piece handle=/oradata/rman/DGPRD_COLD_02jgef91 tag=TAG20080515T125704 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:45
Finished backup at 15-MAY-07
Starting Control File and SPFILE Autobackup at 15-MAY-07
piece handle=/oradata/dgprd/flash_recovery_area/DGPRD_PR/autobackup/2008_05_15/o1_mf_s_654785806_42rtyfgg_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 15-MAY-07
sql statement: alter database open
Starting backup at 15-MAY-07
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 15-MAY-07
channel c1: finished piece 1 at 15-MAY-07
piece handle=/oradata/dgprd/flash_recovery_area/DGPRD_PR/backupset/2008_05_15/o1_mf_ncnnf_TAG20080515T125924_42rtzh7l_.bkp tag=TAG20080515T125924 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 15-MAY-07
\
Starting Control File and SPFILE Autobackup at 15-MAY-07
piece handle=/oradata/dgprd/flash_recovery_area/DGPRD_PR/autobackup/2008_05_15/o1_mf_s_654785968_42rtzltr_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 15-MAY-07
sql statement: ALTER DATABASE BACKUP CONTROLFILE TO TRACE
released channel: c1
RMAN>
No comments:
Post a Comment