????OS??Oracle Linux 5u8
????DB??11.2.0.4
????·???????????￡?????http://blog.itpub.net/22621861/viewspace-1431461/
????1. ????????????????????????????????orapw?????
????orapwd file=$ORACLE_HOME/dbs/orapwnewdb password=oracle1 entries=3
????2. ??????????????????????
??????????????????????????????????????????С???????2????б???????
????DB_NAME=jun
????DB_BLOCK_SIZE=8192
????DB_RECOVERY_FILE_DEST=/oracledata/fra
????DB_RECOVERY_FILE_DEST_SIZE=40G
????CONTROL_FILES='/oracledata/JUN/controlfile/control01.ctl'?? '/oracledata/fra/JUN/controlfile/control02.ctl'
????DB_FILE_NAME_CONVERT='/oradata/APR'??'/oracledata/JUN'
????LOG_FILE_NAME_CONVERT='/oradata/APR'??'oracledata/JUN'??'/oradata/fra/APR'??'/oracledata/fra/JUN'
????compatible=11.2.0.4.0
????3. ?????????????t????????
????vi $ORACLE_HOME/network/admin/listener.ora
????SID_LIST_LISTENER =
????(SID_LIST =
????(SID_DESC =
????(GLOBAL_DBNAME = jun)
????(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
????(SID_NAME = jun)
????)
????)
????4. ??????????????????????????????????????????????????±???????????????????????????
????ORA-17628: Oracle error 19505 returned by remote Oracle server
????mkdir -p /oracledata/JUN/controlfile /oracledata/fra/JUN/controlfile
????mkdir -p /oracledata/JUN/datafile
????5. ???????????????
????startup nomount pfile=initjun.ora
????6. ???????????????RMAN
????rman target sys/oracle@apr auxiliary sys/oracle@jun
????RMAN>
????run { allocate auxiliary channel a1 device type disk;
????allocate auxiliary channel a2 device type disk;
????allocate channel t1 type disk;
????allocate channel t2 type disk;
????duplicate target database to jun from active database;
????}
????????