oracle 0和1,ORACLE10G 10.2.0.1升级到10.2.0.5

备份数据库软件(磁盘空间足够)

[root@dongyang ~]#df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda2              18G   11G6.2G64% /

/dev/sda1             988M

42M  896M   5% /boot

tmpfs                1002M     0 1002M

0% /dev/shm

/dev/sdb1              12G2.3G9.0G

21% /u01

[root@dongyang ~]#

[root@dongyang ~]#mkdir /u02

[root@dongyang ~]#cd /u01

[root@dongyang u01]#cp -r * /u02

关闭当前数据库

[oracle@dongyang ~]$echo $ORACLE_SID

fengzi

[oracle@dongyang ~]$sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production

on Thu Jun 5 13:46:04 2014

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

Connected to:

Oracle Database 10g Enterprise Edition

Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data

Mining options

SQL>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

登录RMAN启动数据库到mount状态

[oracle@dongyang ~]$rman target /

Recovery Manager: Release 10.2.0.1.0 -

Production on Thu Jun 5 13:48:42 2014

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

connected to target database (not

started)

RMAN>startup mount

database is already started

database mounted

备份当前控制文件

RMAN>backup current controlfile;

Starting backup at 05-JUN-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=322 devtype=DISK

channel ORA_DISK_1: starting full

datafile backupset

channel ORA_DISK_1: specifying

datafile(s) in backupset

including current control file in

backupset

channel ORA_DISK_1: starting piece 1 at

05-JUN-14

channel ORA_DISK_1: finished piece 1 at

05-JUN-14

piece

handle=+DATA/fengzi/backupset/2014_06_05/ncnnf0_tag20140605t140242_0.380.849448965

tag=TAG20140605T140242 comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:05

Finished backup at 05-JUN-14

Starting Control File and SPFILE

Autobackup at 05-JUN-14

piece

handle=+DATA/fengzi/autobackup/2014_06_05/s_849447979.381.849448969

comment=NONE

Finished Control File and SPFILE

Autobackup at 05-JUN-14

备份数据库到/u01/backup/目录下

RMAN>backup database format '/u01/backup/2014_06_01_%U';

Starting backup at 05-JUN-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting full

datafile backupset

channel ORA_DISK_1: specifying

datafile(s) in backupset

input datafile fno=00001

name=+DATA/fengzi/datafile/system.277.842187103

channel ORA_DISK_1: starting piece 1 at

05-JUN-14

channel ORA_DISK_1: finished piece 1 at

05-JUN-14

piece handle=/u01/backup/2014_06_01_27pa3431_1_1

tag=TAG20140605T140417 comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:01:15

channel ORA_DISK_1: starting full

datafile backupset

channel ORA_DISK_1: specifying

datafile(s) in backupset

input datafile fno=00007

name=/u01/app/oracle/oradata/FENGZI/datafile/o1_mf_wer_9ns1wd2n_.dbf

input datafile fno=00008

name=/u01/app/oracle/oradata/yyyy12.dbf

input datafile fno=00009

name=/u01/app/oracle/oradata/tt.dbf

input datafile fno=00004 name=+DATA/fengzi/datafile/users2.dbf

input datafile fno=00005

name=+DATA/fengzi/datafile/undotbs.dbf

channel ORA_DISK_1: starting piece 1 at

05-JUN-14

channel ORA_DISK_1: finished piece 1 at

05-JUN-14

piece

handle=/u01/backup/2014_06_01_28pa345d_1_1 tag=TAG20140605T140417

comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:25

channel ORA_DISK_1: starting full

datafile backupset

channel ORA_DISK_1: specifying

datafile(s) in backupset

input datafile fno=00003

name=+DATA/fengzi/datafile/sysaux.279.842187235

channel ORA_DISK_1: starting piece 1 at

05-JUN-14

channel ORA_DISK_1: finished piece 1 at

05-JUN-14

piece

handle=/u01/backup/2014_06_01_29pa3466_1_1 tag=TAG20140605T140417

comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:45

channel ORA_DISK_1: starting full

datafile backupset

channel ORA_DISK_1: specifying

datafile(s) in backupset

input datafile fno=00002

name=+DATA/fengzi/datafile/undotbs1.dbf

channel ORA_DISK_1: starting piece 1 at

05-JUN-14

channel ORA_DISK_1: finished piece 1 at

05-JUN-14

piece

handle=/u01/backup/2014_06_01_2apa347j_1_1 tag=TAG20140605T140417

comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:26

channel ORA_DISK_1: starting full

datafile backupset

channel ORA_DISK_1: specifying datafile(s)

in backupset

input datafile fno=00006

name=+DATA/fengzi/datafile/users1.dbf

channel ORA_DISK_1: starting piece 1 at

05-JUN-14

channel ORA_DISK_1: finished piece 1 at

05-JUN-14

piece

handle=/u01/backup/2014_06_01_2bpa348d_1_1 tag=TAG20140605T140417

comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:07

Finished backup at 05-JUN-14

Starting Control File and SPFILE

Autobackup at 05-JUN-14

piece

handle=+DATA/fengzi/autobackup/2014_06_05/s_849447979.382.849449239

comment=NONE

Finished Control File and SPFILE

Autobackup at 05-JUN-14

RMAN>