宿州物流网站建设,一锅汤资源分享网站建设大全,镇江seo,wordpress metakeyoracle --10g 中Duplicate 复制数据库本次实验通过duplicate命令#xff0c;在本机环境中创建一个复制数据库。目标数据库为hongye、复制数据库为catdb。环境别名设置#xff1a;alias sqlrlwrap sqlplus /nologalias rmanrlwrap rmanalias dbscd $ORACLE_HOME/dbsalias rdbc…oracle --10g 中Duplicate 复制数据库本次实验通过duplicate命令在本机环境中创建一个复制数据库。目标数据库为hongye、复制数据库为catdb。环境别名设置alias sqlrlwrap sqlplus /nologalias rmanrlwrap rmanalias dbscd $ORACLE_HOME/dbsalias rdbcd $ORACLE_HOME/rdbms/adminalias uducd $ORACLE_BASE/admin/$ORACLE_SID/udumpalias bducd $ORACLE_BASE/admin/$ORACLE_SID/bdumpalias rmalertrm -f $ORACLE_BASE/admin/$ORACLE_SID/bdump/*;rm -f $ORACLE_BASE/admin/$ORACLE_SID/udump/*详细步骤如下1、构建catdb的初始化参数文件本次实验使用的参数文件是从hongye数据库中创建出来的并做了一些修改。注意参数db_file_name_convert和log_file_name_convert参数这两个参数控制了数据文件和日志文件的重命名关于数据文件的重命名也可以使用set newname命令日志文件的重命名可以在duplicate命令的子句中指定但均没有init参数中的转换方便。db_file_name_convert和log_file_name_convert参数都是使用串替换的方式重命名的通过将目标文件名的指定的字符串替换成指定的字符串从而生成新的文件名本次实验中hongye数据库的数据文件存放在路径为/oracle/oradata/hongye/而catdb的数据文件路径为/oracle/oradata/catdb/所以只要将所有文件名中的hongye替换成catdb就可以了。[oracleORA10G ~]$ dbs[oracleORA10G dbs]$ echo $ORACLE_SIDhongye[oracleORA10G dbs]$ lltotal 6960-rw-rw---- 1 oracle oinstall 1544 Feb 11 22:13 hc_hongye.dat-rw-r----- 1 oracle oinstall 848 Feb 17 19:46 initcatdb.ora-rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora-rw-r----- 1 oracle oinstall 1079 Feb 17 19:21 inithongye.ora-rw-r----- 1 oracle oinstall 2469 Feb 11 20:59 init.ora-rw-r----- 1 oracle oinstall 24 Feb 11 19:20 lkHONGYE-rw-r----- 1 oracle oinstall 1536 Feb 17 19:49 orapwcatdb-rw-r----- 1 oracle oinstall 1536 Feb 15 21:01 orapwhongye-rw-r----- 1 oracle oinstall 7061504 Feb 17 19:20 snapcf_hongye.f-rw-r----- 1 oracle oinstall 3584 Feb 17 19:16 spfilehongye.ora-rw-r----- 1 oracle oinstall 694 Feb 17 19:34 sqlnet.log[oracleORA10G dbs]$ vi initcatdb.ora*.audit_file_dest/oracle/admin/catdb/adump*.background_dump_dest/oracle/admin/catdb/bdump*.compatible10.2.0.5.0*.control_files/oracle/oradata/catdb/control01.ctl*.core_dump_dest/oracle/admin/catdb/cdump*.db_block_size8192*.db_domainoracle.com*.db_file_multiblock_read_count16*.db_namecatdb*.db_recovery_file_dest/oracle/flash_recovery_area*.db_recovery_file_dest_size2147483648*.dispatchers(PROTOCOLTCP) (SERVICEcatdbXDB)*.job_queue_processes10*.nls_date_formatyyyy-mm-dd hh24:mi:ss*.open_cursors30*.pga_aggregate_target16777216*.processes50*.remote_login_passwordfileEXCLUSIVE*.sessions70*.sga_target80M*.undo_managementAUTO*.undo_tablespaceUNDOTBS1*.user_dump_dest/oracle/admin/catdb/udump--文件名的转换参数db_file_name_convert(hongye,catdb)log_file_name_convert(hongye,catdb)~~~~~initcata.ora 25L, 848C written2、创建复制数据库的相关目录包括adump、bdump、cdump、udump、oradata/catdb[oracleORA10G dbs]$ cd /oracle/admin[oracleORA10G dbs]$ mkdir catdb catdb/adump catdb/bdump catdb/cdump catdb/udump[oracleORA10G dbs]$ ll /oracle/admin/total 8drwxr-xr-x 7 oracle oinstall 4096 Feb 17 19:29 catdbdrwxr-x--- 8 oracle oinstall 4096 Feb 11 19:19 hongye[oracleORA10G dbs]$ mkdir /oracle/oradata/catdb/[oracleORA10G dbs]$ ll /oracle/oradata/catdb/total 03、将ORACLE_SID设置为复制数据库的sid那么就不需要额外的配置复制数据库的网络文件了前提是已经配置了目标数据库的网络配置文件二者必须至少要配其一。[oracleORA10G dbs]$ echo $ORACLE_SIDhongye[oracleORA10G dbs]$ export ORACLE_SIDcatdb[oracleORA10G dbs]$ echo $ORACLE_SIDcatdb4、创建复制数据库的密码文件。[oracleORA10G dbs]$ orapwd file$ORACLE_HOME/dbs/orapwcatdbEnter password for SYS:5、登录复制数据库以nomount方式打开数据库。[oracleORA10G dbs]$ sqlSQL*Plus: Release 10.2.0.5.0 - Production on Thu Feb 17 19:50:57 2011Copyright (c) 1982, 2010, Oracle. All Rights Reserved.IDLE conn /as sysdbaConnected to an idle instance.IDLE startup nomount pfile$ORACLE_HOME/dbs/initcatdb.oraORACLE instance started.Total System Global Area 83886080 bytesFixed Size 1272096 bytesVariable Size 58722016 bytesDatabase Buffers 16777216 bytesRedo Buffers 7114752 bytesIDLE exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options6、在RMAN中执行数据库的复制操作。[oracleORA10G dbs]$ rmanRecovery Manager: Release 10.2.0.5.0 - Production on Thu Feb 17 19:51:50 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.RMAN connect target sys/hongye50hongyeconnected to target database: HONGYE (DBID2424037643)RMAN connect auxiliary /connected to auxiliary database: CATDB (not mounted)RMAN duplicate target database to catdb;Starting Duplicate Db at 17-FEB-11using target database control file instead of recovery catalogallocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: sid56 devtypeDISKcontents of Memory Script:{set until scn 1219581;set newname for datafile 1 to/oracle/oradata/catdb/system01.dbf;set newname for datafile 2 to/oracle/oradata/catdb/undotbs01.dbf;set newname for datafile 3 to/oracle/oradata/catdb/sysaux01.dbf;set newname for datafile 4 to/oracle/oradata/catdb/users01.dbf;set newname for datafile 5 to/oracle/oradata/catdb/example01.dbf;restorecheck readonlyclone database;}executing Memory Scriptexecuting command: SET until clauseexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting restore at 17-FEB-11using channel ORA_AUX_DISK_1channel ORA_AUX_DISK_1: starting datafile backupset restorechannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00001 to /oracle/oradata/catdb/system01.dbfrestoring datafile 00002 to /oracle/oradata/catdb/undotbs01.dbfrestoring datafile 00003 to /oracle/oradata/catdb/sysaux01.dbfrestoring datafile 00004 to /oracle/oradata/catdb/users01.dbfrestoring datafile 00005 to /oracle/oradata/catdb/example01.dbfchannel ORA_AUX_DISK_1: reading from backup piece /oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_nnndf_TAG20110217T191915_6ot11mbc_.bkpchannel ORA_AUX_DISK_1: restored backup piece 1piece handle/oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_nnndf_TAG20110217T191915_6ot11mbc_.bkp tagTAG20110217T191915channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:37Finished restore at 17-FEB-11sql statement: CREATE CONTROLFILE REUSE SET DATABASE CATDB RESETLOGS ARCHIVELOGMAXLOGFILES 16MAXLOGMEMBERS 3MAXDATAFILES 100MAXINSTANCES 8MAXLOGHISTORY 292LOGFILEGROUP 1 ( /oracle/oradata/catdb/redo01.log ) SIZE 50 M REUSE,GROUP 2 ( /oracle/oradata/catdb/redo02.log ) SIZE 50 M REUSE,GROUP 3 ( /oracle/oradata/catdb/redo03.log ) SIZE 50 M REUSEDATAFILE/oracle/oradata/catdb/system01.dbfCHARACTER SET WE8ISO8859P1contents of Memory Script:{switch clone datafile all;}executing Memory Scriptdatafile 2 switched to datafile copyinput datafile copy recid1 stamp743370847 filename/oracle/oradata/catdb/undotbs01.dbfdatafile 3 switched to datafile copyinput datafile copy recid2 stamp743370847 filename/oracle/oradata/catdb/sysaux01.dbfdatafile 4 switched to datafile copyinput datafile copy recid3 stamp743370847 filename/oracle/oradata/catdb/users01.dbfdatafile 5 switched to datafile copyinput datafile copy recid4 stamp743370847 filename/oracle/oradata/catdb/example01.dbfcontents of Memory Script:{set until scn 1219581;recoverclone databasedelete archivelog;}executing Memory Scriptexecuting command: SET until clauseStarting recover at 17-FEB-11using channel ORA_AUX_DISK_1starting media recoverychannel ORA_AUX_DISK_1: starting archive log restore to default destinationchannel ORA_AUX_DISK_1: restoring archive logarchive log thread1 sequence2channel ORA_AUX_DISK_1: reading from backup piece /oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_annnn_TAG20110217T192041_6ot14bjm_.bkpchannel ORA_AUX_DISK_1: restored backup piece 1piece handle/oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_annnn_TAG20110217T192041_6ot14bjm_.bkp tagTAG20110217T192041channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02archive log filename/oracle/flash_recovery_area/CATDB/archivelog/2011_02_17/o1_mf_1_2_6ot3332m_.arc thread1 sequence2channel clone_default: deleting archive log(s)archive log filename/oracle/flash_recovery_area/CATDB/archivelog/2011_02_17/o1_mf_1_2_6ot3332m_.arc recid1 stamp743370851media recovery complete, elapsed time: 00:00:03Finished recover at 17-FEB-11contents of Memory Script:{shutdown clone;startup clone nomount ;}executing Memory Scriptdatabase dismountedOracle instance shut downconnected to auxiliary database (not started)Oracle instance startedTotal System Global Area 83886080 bytesFixed Size 1272096 bytesVariable Size 58722016 bytesDatabase Buffers 16777216 bytesRedo Buffers 7114752 bytessql statement: CREATE CONTROLFILE REUSE SET DATABASE CATDB RESETLOGS ARCHIVELOGMAXLOGFILES 16MAXLOGMEMBERS 3MAXDATAFILES 100MAXINSTANCES 8MAXLOGHISTORY 292LOGFILEGROUP 1 ( /oracle/oradata/catdb/redo01.log ) SIZE 50 M REUSE,GROUP 2 ( /oracle/oradata/catdb/redo02.log ) SIZE 50 M REUSE,GROUP 3 ( /oracle/oradata/catdb/redo03.log ) SIZE 50 M REUSEDATAFILE/oracle/oradata/catdb/system01.dbfCHARACTER SET WE8ISO8859P1contents of Memory Script:{set newname for tempfile 1 to/oracle/oradata/catdb/temp01.dbf;set newname for tempfile 2 to/oracle/oradata/catdb/temp02.dbf;switch clone tempfile all;catalog clone datafilecopy /oracle/oradata/catdb/undotbs01.dbf;catalog clone datafilecopy /oracle/oradata/catdb/sysaux01.dbf;catalog clone datafilecopy /oracle/oradata/catdb/users01.dbf;catalog clone datafilecopy /oracle/oradata/catdb/example01.dbf;switch clone datafile all;}executing Memory Scriptexecuting command: SET NEWNAMEexecuting command: SET NEWNAMErenamed temporary file 1 to /oracle/oradata/catdb/temp01.dbf in control filerenamed temporary file 2 to /oracle/oradata/catdb/temp02.dbf in control filecataloged datafile copydatafile copy filename/oracle/oradata/catdb/undotbs01.dbf recid1 stamp743370868cataloged datafile copydatafile copy filename/oracle/oradata/catdb/sysaux01.dbf recid2 stamp743370869cataloged datafile copydatafile copy filename/oracle/oradata/catdb/users01.dbf recid3 stamp743370869cataloged datafile copydatafile copy filename/oracle/oradata/catdb/example01.dbf recid4 stamp743370869datafile 2 switched to datafile copyinput datafile copy recid1 stamp743370868 filename/oracle/oradata/catdb/undotbs01.dbfdatafile 3 switched to datafile copyinput datafile copy recid2 stamp743370869 filename/oracle/oradata/catdb/sysaux01.dbfdatafile 4 switched to datafile copyinput datafile copy recid3 stamp743370869 filename/oracle/oradata/catdb/users01.dbfdatafile 5 switched to datafile copyinput datafile copy recid4 stamp743370869 filename/oracle/oradata/catdb/example01.dbfcontents of Memory Script:{Alter clone database open resetlogs;}executing Memory Scriptdatabase openedFinished Duplicate Db at 17-FEB-11RMAN exitRecovery Manager complete.7、登录复制数据库查看结果。[oracleORA10G dbs]$ sqlSQL*Plus: Release 10.2.0.5.0 - Production on Thu Feb 17 19:55:07 2011Copyright (c) 1982, 2010, Oracle. All Rights Reserved.IDLE conn /as sysdbaConnected.SYS:57catdb select open_mode from v$database;OPEN_MODE----------READ WRITESYS:57catdb get_allfileTYPE FILE_NAME SIZE_MB------------------- ---------------------------------- ----------Datafile ........ /oracle/oradata/catdb/system01.dbf 600Datafile ........ /oracle/oradata/catdb/undotbs01.dbf 405Datafile ........ /oracle/oradata/catdb/sysaux01.dbf 300Datafile ........ /oracle/oradata/catdb/users01.dbf 20Datafile ........ /oracle/oradata/catdb/example01.dbf 100TempFile ........ /oracle/oradata/catdb/temp01.dbf 30TempFile ........ /oracle/oradata/catdb/temp02.dbf 30Logfile ......... /oracle/oradata/catdb/redo03.log 50Logfile ......... /oracle/oradata/catdb/redo02.log 50Logfile ......... /oracle/oradata/catdb/redo01.log 50Controlfile ..... /oracle/oradata/catdb/control01.ctl 711 rows selected.SYS:57catdb
