论坛 › Oracle › ramn数据库迁移

superdebug 发表于 2011-12-22 08:54

ramn数据库迁移

<DIV>
<DIV>使用RMAN 复制数据库 LMJ 到 系统 CLON 上为JJJ 数据库:<BR><BR>1) 在源数据库 LMJ 上利用RMAN 全备份数据库:<BR>&nbsp; &nbsp;&nbsp;&nbsp;#: rman catalogrman/rman@rmantargetsys/oracle@lmj<BR>&nbsp; &nbsp;&nbsp;&nbsp;rman&gt; run { allocate channel c1 device type disk;<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;backup format '/u1/backup/db_%T_%s_%p.dbf'<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;database tag='db_full';<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;backup format '/u1/backup/arc_%T_%s_%p.dbf'<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;archivelog all delete input tag='arc_full';<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;backup format '/u1/backup/dbcontrol.bak'<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;current controlfile;<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; }<BR>&nbsp;&nbsp;2) 在复制库 CLON 上建立相应的目录:(目录结构和源库保持一致)<BR>&nbsp; &nbsp;&nbsp; &nbsp;A: mkdir -p /u1/oracle/admin/jjj/adump<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;mkdir -p /u1/oracle/admin/jjj/bdump&nbsp;&nbsp;<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;mkdir -p /u1/oracle/admin/jjj/cdump&nbsp;&nbsp;<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;mkdir -p /u1/oracle/admin/jjj/udump&nbsp;&nbsp;<BR>&nbsp; &nbsp;&nbsp; &nbsp;B: mkdir /u1/oracle/oradata/jjj<BR>&nbsp; &nbsp;&nbsp; &nbsp;C: mkdir /u1/backup (存放从源库COPY 过来的备份集)<BR>&nbsp; &nbsp;&nbsp; &nbsp;D: orapwd file=$ORACLE_HOME/dbs/orapwlmj password=oracle entries=10<BR>&nbsp; &nbsp;&nbsp; &nbsp;E: scp @test:/$ORACLE_HOME/dbs/initlmj.ora /u1/oracle/product/10.2.0/db_1/dbs/<BR>&nbsp; &nbsp;&nbsp; &nbsp;F: sqlplus / as sysdba<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;startup nomount ;<BR>&nbsp; &nbsp;&nbsp; &nbsp;G: scp @test:/u1/backup/*&nbsp; &nbsp;/u1/backup<BR>&nbsp;&nbsp;3) 在复制库 CLON 上配置监听 <BR>&nbsp; &nbsp;&nbsp; &nbsp;A:&nbsp;&nbsp;rman --&gt; 源库的IP,源库的服务RMAN ;<BR>&nbsp; &nbsp;&nbsp; &nbsp;B:&nbsp;&nbsp;lmj&nbsp;&nbsp;--&gt; 源库的IP,源库的服务lmj ;<BR>&nbsp;&nbsp;4) 在CLON 上开始复制库:<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;#: rman catalogrman/rman@rmantargetsys/oracle@lmj( 先连接到源数据库和恢复目录数据库)<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;rman&gt;&nbsp;&nbsp;connect auxiliary /; (连接到本地数据库进行恢复)<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;rman&gt;&nbsp;&nbsp;list backupset ; ( 找到可以恢复的最后一个SEQ ,假如是 4)<BR><BR>run {<BR>allocate auxiliary channel c1 device type disk;<BR>set newname for datafile 1 to '/u1/oracle/oradata/jjj/system01.dbf';<BR>set newname for datafile 2 to '/u1/oracle/oradata/jjj/undotbs01.dbf';<BR>set newname for datafile 3 to '/u1/oracle/oradata/jjj/sysaux01.dbf';<BR>set newname for datafile 4 to '/u1/oracle/oradata/jjj/users01.dbf';<BR>set newname for tempfile 1 to '/u1/oracle/oradata/jjj/temp01.dbf';<BR>duplicate target database to jjj logfile<BR>group 1 ('/u1/oracle/oradata/jjj/redo01.log') size 50m reuse,<BR>group 2 ('/u1/oracle/oradata/jjj/redo02.log') size 50m reuse,<BR>group 3 ( '/u1/oracle/oradata/jjj/redo03.log') size 50m reuse;<BR>}</DIV></DIV>

查看完整版本: ramn数据库迁移