RMAN异地备份方案

1、RMAN 本地数据库异地备份测试方案一 分析：RMAN并不支持客户端连接服务器进行备份，所以仍然需要在服务器上使用RMAN备份，客户要求备份至异地；二 环境：1. 两台win2003 Enterprise edition：主机名si_vm_w2k3，ip:192.168.2.204;备机名PC2 ip:192.168.2.2052. 在si_vm_w2k3上和PC2上同时安装oracle 10.2.0.1.0;3. ORACLE_HOME=C:oracleproduct10.2.0db_1.ORADATA=C:oracleproduct10.2.0oradatalichao;三 操作步骤：1,

2、在PC2上创建共享目录RMAN，在RMAN目录里建子目录logs,并授予administrator权限，保证administrator具备口令为Root1!口令不能为空；2,在si_vm_w2k3确保administrator的口令与PC2的administrator口令相同且为Root1！；3,在si_vm_w2k3映射PC2RMAN目录为Z盘，并明确登录用户为administrator及口令；4,在si_vm_w2k3机器修改ORACLE的两个服务OracleTNSListerner和OracleServiceLICHAO为账户登录：用户名为administrator，口令为Root1！；

3、5,重启si_vm_w2k3机器的两个服务；备份可以备份在本地，有必要时再传到PC2上。创建复制数据库：1,创建口令文件 orapwd file=c:oracleproduct10.2.0db_1databasepwdlichao.ora password=admin entries=102,创建辅助数据库实例：Oradim new sid test4. 配置监听程序在这里我们需要配置的监听有两个分别是原数据库和复制数据库的监听TEST实例的监听Listener.ora：SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = t

4、est) (ORACLE_HOME = C:oracleproduct10.2.0db_1) (SID_NAME = test) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.205)(PORT = 1521) ) )Tnsname.ora：lichao =(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.204)(PORT = 1521) ) (CONNE

5、CT_DATA = (SID = lichao) )test = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.205)(PORT = 1521) ) (CONNECT_DATA = (SID = test) )lichao实例监听配置：Listener.ora：SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = test) (ORACLE_HOME = C:oracleproduct10.2.0db_1) (SID_N

6、AME = lichao) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.204)(PORT = 1521) ) )Tnsname.ora：lichao = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.204)(PORT = 1521) ) (CONNECT_DATA = (SID = lichao) )test = (DESCRIPTION = (A

7、DDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.205)(PORT = 1521) ) (CONNECT_DATA = (SID = test) )配置完监听记得重新启动监听的服务进程，并使用lsnrctl stop、lsnrctl start来重新启动监听5,创建辅助（复制）数据库的目录6,创建辅助（复制）数据库的参数文件主库执行Create pfile from spfile复制pfile到复制数据库，修改相关参数：Adump、bdump、cdump、udump、ddump、db_name和控制文件路径。还需要添加两个参

8、数：db_file_name_convert=(c:oracleproduct10.2.0oradatalichao,c:oracleproduct10.2.0oradatalichao)log_file_name_convert=(c:oracleproduct10.2.0oradatalichao,c:oracleproduct10.2.0oradatalichao)完成以上步骤后我们可以开始创建我们真正想要的参数文件：7,SQLcreate spfile=c:oracleproduct10.2.0db_1databasespfilelichao.ora from pfile=c:abc.

9、ora使用RMAN完全备份原数据库导入数据：创建表空间lnxh_v2： Create tablespace lnxh_v2 datafile C:oracleproduct10.2.0oradatatomlnxh_v2.dbf size 30000m;创建用户：lnxh_v2:create user lnxh_v2 identified by lnxh_v2 default tablespaceLnxh_v2;导入数据 imp userid=lnxh_v2/lnxh_v2 file=c.xxlnxh.dmp log=imp.log fromuser=lnxh_v2 touser=lnxh_v2

10、查看lnxh_v2用户表：SQL select count(table_name) from dba_tables where owner=LNXH_V2;COUNT(TABLE_NAME) - 858 SQL select current_scn from v$database;CURRENT_SCN - RunBackup full database format 192.168.2.205/rman /%U.bak;Backup archivelog all format 192.168.2.205/rman /arc_%U.bak;Copy current controlfile to

11、 192.168.2.205/rman /control_bak.ctl; 8复制库处于nomount状态。9. 创建备份Rman target /RunBackup full database format 192.168.2.205/rman /%U.bak;Backup archivelog all format 192.168.2.205/rman /arc_%U.bak;Copy current controlfile to 192.168.2.205/rman /control_bak.ctl;10.使用rman复制数据库rman target / AUXILIARY sys/ad

12、mintestDUPLICATE TARGET DATABASE TO “test” nofilenamecheck查看复制库lnxh_v2用户表：SQL select count(table_name) from dba_tables where owner=LNXH_V2;COUNT(TABLE_NAME) - 858 SQL select current_scn from v$database;CURRENT_SCN - 启用主库块跟踪：alter database enable block change tracking；建立0级备份RunAllocate channel d1 dev

13、ice type disk format 192.168.2.205/rman/DB_LV_0_%T_%t.rbf;BackupIncremental level 0 database tag LV_0;SQL ALTER SYSTEM ARCHIVE LOG CURRENT;Release channel d1;建立一个1级备份RunAllocate channel d1 type disk;BackupIncremental level 1Format 192.168.2.205/rman/%U(database);Release channel d1;主库：restore databas

14、e preview；还原恢复数据库Rman target /Startup nomountRestore controlfile from 192.168.2.205/rman/auto_sp_%F.rbf;Restore database;Recover database until sequence xx;Alter database open resetlogs;复制库上创建恢复目录数据库Create tablespace rman datafileC:oracleproduct10.2.0oradatatomrman.dbf size 50m;Create user rman_user

15、 identified by rman_user default tablespace rman temporary tablespace temp;Rmanconnect catalog rman_user/rman_userRmancreate catalog tablespace rman;Rmanregister database;登记备份文件和归档日志到RMAN仓库Rmancatalog start withc:rman(如果复制过来的备份文件的路径和主库不同，要让RMAN知道这些文件在哪里。Rman restore database； Recovery database until

16、 scn *；经测试恢复后数据正常；迁移业务数据到metarnet表空间；Create tablespace metarnet datafileY:oracleoradatametarnet.dbf size 4000m;迁移脚本见lnxh.sqlConn lnxh_v2/lnxh_v2Start lnxh.sqlaltertable CONF_NE_IP2PORT_P movetablespacemetarnet;altertable CONF_NE_IP2PORT_V movetablespacemetarnet;altertable CONF_NE_IPMACTABLE movetabl

17、espacemetarnet;altertable CONF_NE_P movetablespacemetarnet;altertable CONF_NE_PORT movetablespacemetarnet;altertable CONF_NE_PORT_P movetablespacemetarnet;altertable CONF_NE_PORT_V movetablespacemetarnet;altertable CONF_NE_PROBE movetablespacemetarnet;迁移完后验证：Lnxh_v2用户登录查询：select distinct(tablespace_

18、name) from user_tables;SQL select distinct(tablespace_name) from user_tables;TABLESPACE_NAME - LNXH_V2 METARNET (由于表空间大小受限，所以部分表迁移未成功,但此操作可以实现业务表从lnxh_v2迁移到metarnet表空间)再次复制数据库到异地机；建立测试数据：主库做一个基于业务表空间metarnet的备份：Run Backup tablesapce metarnet format192.168.2.205/rman/metarnet_%U.bak;复制库上执行：Catalog start withc:rman;报错了无法在目录表空间注册备份文件如下：为做尝试，我在复制库nomount状态下还原控制文件：启动到mount状态：Restore tablespace metarnet；这里提示redolog不同。再次注册备份文件：注册成功试着恢复metarnet表空间用备份再次还原；注册备份文件还原metarn