Oracle升级_oracle10g版本由10.2.0.1.0升级为10.2.0.4.0(即CPU升级)(五)

2014-11-24 12:27:40 · 作者: · 浏览: 3
;

6> }

using target database control file instead ofrecovery catalog

database dismounted

Oracle instance shut down

connected to target database (not started)

Oracle instance started

database mounted

Total System Global Area 272629760 bytes

Fixed Size 1218944 bytes

Variable Size 71304832 bytes

Database Buffers 197132288 bytes

Redo Buffers 2973696 bytes

Starting backup at 15-MAY-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: starting full datafilebackupset

channel ORA_DISK_1: specifying datafile(s) inbackupset

input datafile fno=00001name=/u01/app/oracle/oradata/prod/system01.dbf

input datafile fno=00003name=/u01/app/oracle/oradata/prod/sysaux01.dbf

input datafile fno=00006name=/u01/app/oracle/oradata/prod/test1.dbf

input datafile fno=00002name=/u01/app/oracle/oradata/prod/undotbs01.dbf

input datafile fno=00005name=/u01/app/oracle/oradata/prod/example01.dbf

input datafile fno=00007 name=/u01/app/oracle/oradata/prod/tbs1.dbf

input datafile fno=00008name=/u01/app/oracle/oradata/prod/test3.dbf

input datafile fno=00004name=/u01/app/oracle/oradata/prod/users01.dbf

channel ORA_DISK_1: starting piece 1 at 15-MAY-14

channel ORA_DISK_1: finished piece 1 at 15-MAY-14

piece handle=/disk2/backup/PROD_378.baktag=TAG20140515T165417 comment=NONE

channel ORA_DISK_1: backup set complete, elapsedtime: 00:00:34

Finished backup at 15-MAY-14

Starting Control File and SPFILE Autobackup at15-MAY-14

piece handle=/disk1/recovery/PROD/autobackup/2014_05_15/o1_mf_s_847644081_9q906yj6_.bkpcomment=NONE

Finished Control File and SPFILE Autobackup at15-MAY-14

database opened

更正:由于之前已经处于mount状态,直接执行备份语句即可,如下所示:

RMAN> backup database format '/disk2/backup/%d_%s.bak';

database closed

database dismounted

Oracle instance shut down

connected to target database (not started)

Oracle instance started

database mounted

Total System Global Area 272629760 bytes

Fixed Size 1218944 bytes

Variable Size 71304832 bytes

Database Buffers 197132288 bytes

Redo Buffers 2973696 bytes

Starting backup at 15-MAY-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) inbackupset

input datafile fno=00001name=/u01/app/oracle/oradata/prod/system01.dbf

input datafile fno=00003name=/u01/app/oracle/oradata/prod/sysaux01.dbf

input datafile fno=00006 name=/u01/app/oracle/oradata/prod/test1.dbf

input datafile fno=00002name=/u01/app/oracle/oradata/prod/undotbs01.dbf

input datafile fno=00005name=/u01/app/oracle/oradata/prod/example01.dbf

input datafile fno=00007name=/u01/app/oracle/oradata/prod/tbs1.dbf

input datafile fno=00008name=/u01/app/oracle/oradata/prod/test3.dbf

input datafile fno=00004name=/u01/app/oracle/oradata/prod/users01.dbf

channel ORA_DISK_1: starting piece 1 at 15-MAY-14

channel ORA_DISK_1: finished piece 1 at 15-MAY-14

piece handle=/disk2/backup/PROD_380.baktag=TAG20140515T170725 comment=NONE

channel ORA_DISK_1: backup set complete, elapsedtime: 00:00:34

Finished backup at 15-MAY-14

Starting Control File and SPFILE Autobackup at15-MAY-14

piecehandle=/disk1/recovery/PROD/autobackup/2014_05_15/o1_mf_s_847645628_9q90zk5q_