做网站在线视频如何添加,网站优化标签,文学网站模板,哈尔滨市建设网站通常要迁移一个数据库#xff0c;我们会使用1 冷备份#xff0c;整个数据库迁移#xff0c;2 rman duplicate 功能进行复制到本机或者复制到异机#xff0c;前面两种都必须先在目标库上安装软件。这里测试另外一种方法#xff1a;对于单实例数据库#xff0c;复制整个ora…通常要迁移一个数据库我们会使用1 冷备份整个数据库迁移2 rman duplicate 功能进行复制到本机或者复制到异机前面两种都必须先在目标库上安装软件。这里测试另外一种方法对于单实例数据库复制整个oracle 10g 数据库到另一个服务器relink 之后可以重新使用。。查看源库数据库库文件在$ORACLE_BASE 目录下的分布oracleyangDB1:/opt/oraclell总计 36drwxrwx--- 3 oracle oinstall 4096 08-06 16:22 10.2.0drwxr-x--- 4 oracle oinstall 4096 08-17 17:10 admindrwxrwxr-x 3 oracle oinstall 4096 08-06 15:14 extapidrwxr-x--- 4 oracle oinstall 4096 08-17 18:32 flash_recovery_areadrwxr-x--- 4 oracle oinstall 4096 08-17 17:10 oradatadrwxrwxr-x 6 oracle oinstall 4096 08-06 16:28 oraInventorydrwxr-xr-x 2 oracle oinstall 4096 08-17 17:49 pri_archdrwxr-xr-x 2 oracle oinstall 4096 08-11 13:27 std_arch -standby文件不用drwxr-xr-x 2 oracle oinstall 4096 08-17 18:31 yqldb_arch-上一个实验文件不用将数据库文件拷贝到目标库记得将目标库设置和源库一样的结构否则会报错oracleyangDB1:/opt/oraclescp -r flash_recovery_area 10.250.7.230:/opt/oracleoracleyangDB1:/opt/oraclescp -r admin 10.250.7.230:/opt/oracleoracleyangDB1:/opt/oraclescp -r oraInventory 10.250.7.230:/opt/oracleoracleyangDB1:/opt/oraclescp -r 10.2.0 10.250.7.230:/opt/oracleoracleyangDB1:/opt/oraclescp -r oradata/orcl/ 10.250.7.230:/opt/oracle/oradata/在目标库上oracleyangDB2:/opt/oracle/10.2.0/orcl/rdbms/liblsbbed dmwdm.o hormc.o kciwcx.o kprnts.o ksnnni.o libodm10.a maxmem.o s0exudrv.o shou.o ssbbded.o sulmain.o xsyeolap.obifile.bbd dumpsga.o hormd.o kcsm.o kprwts.o ksnnt2.o libperfsrv10.a nmliblist s0impdrv.o sjsex.o sskfeded.o tg4pwd.o zsmsdrv.oconfig.c env_rdbms.mk horm.o kfod.o kpucb.o ktd.o libqsmashr.a opimai.o s0kudbv.o skfedpt.o sskfoded.o tstshm.oconfig.o genezi.o hormt.o kgupc.o kpudfo.o kxmnsd.o libskgxns.a osh.o s0kuzr.o skfodpt.o sskrmed.o ttcoerr.ocursize.o genksms.o hout.o kgutc.o kpundf.o kxmwsd.o libskgxpd.a par.bbd s0kvpf.o skrmpt.o sskrned.o ttcsoi.odbfsize.o hoaoci.o hsxaora.o kkpoban.o ksms.o kzlnlbac.o libskgxpu.a rfscom.o s0udexp.o skrnpt.o sskrsed.o wpspldrv.odefopt.o hoat.o ins_rdbms.mk kkxntp.o ksnkcs.o libdbtools10.a libxdb.a rfsd.o s0udimp.o skrspt.o ssoraed.o xaondy.odmndm.o hoax.o jox.o kkxwtp.o ksnkkpo.o libdsga10.a log.bbd rfsin.o sbbdpt.o sllfls.o sstrced.o xaonsl.odmndmse.o homts.o joxoff.o kopc.o ksnktd.o libknlopt.a mapsga.o rfsxc.o shorm.o srfsd.o strcpt.o xsnoolap.o先执行relink oracle然后make -f ins_rdbms.mk installoracleyangDB2:/opt/oracle/10.2.0/orcl/rdbms/librelink oracleoracleyangDB2:/opt/oracle/10.2.0/orcl/rdbms/libmake -f ins_rdbms.mk install验证SQL startupORACLE instance started.Total System Global Area 1224736768 bytesFixed Size 2020384 bytesVariable Size 318770144 bytesDatabase Buffers 889192448 bytesRedo Buffers 14753792 bytesDatabase mounted.Database opened.SQL conn yang/yangConnected.SQL col tname for a15SQL col tabtype for a10SQL select * from tab;TNAME TABTYPE CLUSTERID--------------- ---------- ----------YANGB TABLEYANGTAB TABLEYANGOBJ TABLEYANGUSER TABLEOBJECTS TABLEA TABLE6 rows selected.SQL select instance_name from v$instance;INSTANCE_NAME------------------------------------orcl遇到的问题第一次启动的时候遇到ORA-00205SQL startup pfile/tmp/initorcl.ora;ORACLE instance started.Total System Global Area 1224736768 bytesFixed Size 2020384 bytesVariable Size 318770144 bytesDatabase Buffers 889192448 bytesRedo Buffers 14753792 bytesORA-00205: error in identifying control file, check alert log for more info检查告警日志文件发现如下错误Errors in file /opt/oracle/admin/orcl/udump/orcl_ora_705.trc:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: /opt/oracle/oradata/orcl/redo01.logORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3Sat Aug 6 16:29:12 2011Errors in file /opt/oracle/admin/orcl/udump/orcl_ora_705.trc:ORA-00313: open failed for members of log group 2 of thread 1ORA-00312: online log 2 thread 1: /opt/oracle/oradata/orcl/redo02.logORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directory提示没有对应的文件或者目录。查看数据文件发现拷贝的时候是拷贝到/opt/oracle/ 目录下的而不是/opt/oracle/orcl 目录下将数据文件移动到orcl目录下oracleyangDB2:/opt/oracle/oradatalscontrol01.ctl control02.ctl control03.ctl example01.dbf redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbforacleyangDB2:/opt/oracle/oradatamkdir orcloracleyangDB2:/opt/oracle/oradatamv *.ctl orcloracleyangDB2:/opt/oracle/oradatamv *.dbf orcloracleyangDB2:/opt/oracle/oradatalsorcl redo01.log redo02.log redo03.logoracleyangDB2:/opt/oracle/oradatamv *.log orcloracleyangDB2:/opt/oracle/oradatacd orcloracleyangDB2:/opt/oracle/oradatalloracleyangDB2:/opt/oracle/oradata/orclll总计 1541672-rw-r----- 1 oracle oinstall 7061504 08-17 21:40 control01.ctl-rw-r----- 1 oracle oinstall 7061504 08-17 21:40 control02.ctl-rw-r----- 1 oracle oinstall 7061504 08-17 21:40 control03.ctl-rw-r----- 1 oracle oinstall 104865792 08-17 21:09 example01.dbf-rw-r----- 1 oracle oinstall 52429312 08-17 21:09 redo01.log-rw-r----- 1 oracle oinstall 52429312 08-17 21:40 redo02.log-rw-r----- 1 oracle oinstall 52429312 08-17 21:09 redo03.log-rw-r----- 1 oracle oinstall 335552512 08-17 21:38 sysaux01.dbf-rw-r----- 1 oracle oinstall 513810432 08-17 21:39 system01.dbf-rw-r----- 1 oracle oinstall 20979712 08-17 20:59 temp01.dbf-rw-r----- 1 oracle oinstall 41951232 08-17 21:39 undotbs01.dbf-rw-r----- 1 oracle oinstall 381427712 08-17 21:09 users01.dbf再次验证okoracleyangDB2:/opt/oracle/oradata/orclexport ORCLE_SIDorcloracleyangDB2:/opt/oracle/oradata/orclsqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 17 21:09:19 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL conn /as sysdbaConnected.SQL startupORACLE instance started.Total System Global Area 1224736768 bytesFixed Size 2020384 bytesVariable Size 318770144 bytesDatabase Buffers 889192448 bytesRedo Buffers 14753792 bytesDatabase mounted.Database opened.SQL conn yang/yangConnected.
