???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
ORACLE_SID=SY5221; export ORACLE_SID
oracle@2go-devDB01uv:~> chmod u+x mkdir_sy5221.sh
oracle@2go-devDB01uv:~> ./mkdir_sy5221.sh
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11