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

2014-11-24 12:27:40 · 作者: · 浏览: 2
iece

backup piecehandle=/disk1/recovery/PROD/autobackup/2012_10_26/o1_mf_s_797680992_88mw2mnf_.bkprecid=335 stamp=797681235

deleted backup piece

backup piecehandle=/disk1/recovery/PROD/autobackup/2012_10_26/o1_mf_s_797682372_88mx65co_.bkprecid=339 stamp=797682373

deleted backup piece

backup piecehandle=/disk1/recovery/PROD/autobackup/2012_10_26/o1_mf_s_797694184_88n8qcjf_.bkprecid=340 stamp=797694187

deleted backup piece

backup piecehandle=/disk1/recovery/PROD/autobackup/2012_10_26/o1_mf_s_797694788_88n9b64r_.bkprecid=341 stamp=797694790

deleted backup piece

backup piecehandle=/disk1/recovery/PROD/autobackup/2012_10_26/o1_mf_s_797695808_88nbb1lm_.bkprecid=342 stamp=797695809

Deleted 7 objects

RMAN> list copy;

\

RMAN> delete copy;

\

Do you really want to delete the above objects(enter YES or NO) yes

deleted archive log

archive logfilename=/disk1/arch1/arch_1_4_797613178.log recid=853 stamp=797680899

deleted archive log

archive logfilename=/disk1/arch1/arch_1_5_797613178.log recid=854 stamp=797680902

deleted archive log

archive logfilename=/disk1/arch1/arch_1_6_797613178.log recid=855 stamp=797680911

deleted archive log

archive logfilename=/disk1/arch1/arch_1_7_797613178.log recid=856 stamp=797686101

deleted archive log

archive logfilename=/disk1/arch1/arch_1_8_797613178.log recid=857 stamp=797765967

deleted archive log

archive logfilename=/disk1/arch1/arch_1_9_797613178.log recid=858 stamp=797769330

deleted archive log

archive logfilename=/disk1/arch1/arch_1_10_797613178.log recid=859 stamp=797779367

deleted archive log

archive logfilename=/disk1/arch1/arch_1_11_797613178.log recid=860 stamp=797781258

deleted archive log

archive logfilename=/disk1/arch1/arch_1_12_797613178.log recid=861 stamp=797782326

deleted archive log

archive logfilename=/disk1/arch1/arch_1_13_797613178.log recid=862 stamp=797785426

deleted archive log

archive logfilename=/disk1/arch1/arch_1_14_797613178.log recid=863 stamp=797786840

deleted archive log

archive log filename=/disk1/arch1/arch_1_15_797613178.logrecid=864 stamp=797852200

deleted archive log

archive logfilename=/disk1/arch1/arch_1_16_797613178.log recid=865 stamp=798037031

deleted archive log

archive logfilename=/disk1/arch1/arch_1_17_797613178.log recid=866 stamp=798242772

deleted archive log

archive logfilename=/disk1/arch1/arch_1_18_797613178.log recid=867 stamp=847641900

Deleted 15 objects

RMAN> list copy;

specification does not match any archive log inthe recovery catalog

RMAN> sql'alter system switch logfile';

sql statement: alter system switch logfile

RMAN> sql'alter system switch logfile';

sql statement: alter system switch logfile

//接下来,做一个冷备

RMAN> run{

2> shutdown immediate;

3> startup mount;

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

5> alter database open;

6> }

\

RMAN> quit

[oracle@rh55 ~]$ mkdir -p /disk2/backup

[oracle@rh55 ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Productionon Thu May 15 16:51:57 2014

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

connected to target database: PROD(DBID=199802235, not open)

注意:先不要按下面执行,先看看后边的“更正”!

RMAN> run{

2> shutdown immediate;

3> startup mount;

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

5> alter database open