???RMAN???????????

???????????? ???????[ 2013/6/20 11:12:43 ] ????????

?????????????????ж???????????????????RMAN?????????RMAN??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????С???????????????RMAN?????Oracle 10g??????????

??????????????

????1???????????

????2??ftp?????????????

????3??????????????????

????4?????????????pfile??spfile?????RMAN????????pfile????????????

????5????????????

????6????????????

????7??OPEN ?????

??????????????????????????????????????????????????????????????????

????????????????????

????a??????????????????л??????????????????dumpλ???datafileλ??????archiveλ????

??????????????????·?????????RMAN???????set newname for datafile ??????μ????????

????b????????pfile????????????????pfile??spfile???????????л???nomount??

????c?????????????????????????????????л???mount???????????????????????????mount

????d??mount??????????????л????restore??????

????e?????????????????????л????recovery????????restore??recover?????????????????????????????

????f??????open?????

??????????????

????1????????????

????????????????????????????????????汾?Oracle 10g R2(10.2.0.3)???????????suse 10 +Sp3

???????????????й??????????ο???linux ??RMAN????shell?????http://blog.csdn.net/robinson_0612/article/details/8029245

????2??ftp???е????????????????????????

????????????????ftp????????????scp??????????

??????????ftp???????????????????????

oracle@2go-devDB01uv:/u02/database/SY5221_RMAN/20121013> ls -hltr
total 9.4G
-rw-r--r-- 1 oracle oinstall 3.0K 2012-10-16 09:48 initSY5221.ora
-rw-r--r-- 1 oracle oinstall 2.7G 2012-10-16 10:02 SY5221_lev0_201210130630_4unnkjvi_1_1
-rw-r--r-- 1 oracle oinstall 3.1G 2012-10-16 10:04 SY5221_lev0_201210130630_4vnnkjvi_1_1
-rw-r--r-- 1 oracle oinstall 938M 2012-10-16 10:07 SY5221_lev0_201210130630_arc_51nnkk2h_1_1
-rw-r--r-- 1 oracle oinstall 935M 2012-10-16 10:08 SY5221_lev0_201210130630_arc_52nnkk2h_1_1
-rw-r--r-- 1 oracle oinstall 930M 2012-10-16 10:10 SY5221_lev0_201210130630_arc_53nnkk31_1_1
-rw-r--r-- 1 oracle oinstall 15M 2012-10-16 10:10 SY5221_lev0_cntl_bak_c-1468911009-20121013-00
-rw-r--r-- 1 oracle oinstall 15M 2012-10-16 10:10 SY5221_lev0_cntl_bak_c-1468911009-20121013-01
-rw-r--r-- 1 oracle oinstall 910M 2012-10-16 10:11 SY5221_lev0_201210130630_arc_54nnkk32_1_1

????3??????????????????oracle?????

oracle@2go-devDB01uv:~> more mkdir_sy5221.sh
mkdir -p /u02/database/SY5221/flash_recovery_area
mkdir -p /u02/database/SY5221
mkdir -p /u02/database/SY5221/archive
mkdir -p /u02/database/SY5221/backup
mkdir -p /u02/database/SY5221/bdump
mkdir -p /u02/database/SY5221/cdump
mkdir -p /u02/database/SY5221/udump
mkdir -p /u02/database/SY5221/controlf
mkdir -p /u02/database/SY5221/oradata
mkdir -p /u02/database/SY5221/redolog
mkdir -p /u02/database/SY5221/undo
mkdir -p /u02/database/SY5221/temp
mkdir -p /u02/database/SY5221/ref_data
mkdir -p /u02/database/SY5221/BNR
mkdir -p /u02/database/SY5221/BNR/full
mkdir -p /u02/database/SY5221/BNR/dump
mkdir -p /u02/database/SY5221/dbcreatelogs