RMAN异地备份方案

RMAN 本地数据库异地备份测试方案一．分析：RMAN并不支持客户端连接服务器进行备份，所以仍然需要在服务器上使用RMAN备份，客户要求备份至异地；二．环境：1.两台win2003 Enterprise edition：主机名si_vm_w2k3，ip:192.168.2.204;备机名PC2ip:192.168.2.2052.在si_vm_w2k3上和PC2上同时安装oracle 10.2.0.1.0;3.ORACLE_HOME=C:\oracle\product\10.2.0\db_1.ORADA TA=C:\oracle\product\10.2.0\oradata\lichao;三．操作步骤：1,在PC2上创建共享目录RMAN，在RMAN目录里建子目录logs,并授予administrator权限，保证administrator具备口令为Root1!口令不能为空；2,在si_vm_w2k3确保administrator的口令与PC2的administrator口令相同且为Root1！；3,在si_vm_w2k3映射\\PC2\RMAN目录为Z盘，并明确登录用户为administrator及口令；4,在si_vm_w2k3机器修改ORACLE的两个服务OracleTNSListerner和OracleServiceLICHAO为账户登录：用户名为administrator，口令为Root1！；5,重启si_vm_w2k3机器的两个服务；备份可以备份在本地，有必要时再传到PC2上。

创建复制数据库：1,创建口令文件orapwd file=c:\oracle\product\10.2.0\db_1\database\pwdlichao.ora password=admin entries=102,创建辅助数据库实例：Oradim –new –sid test4.配置监听程序在这里我们需要配置的监听有两个分别是原数据库和复制数据库的监听TEST实例的监听Listener.ora：SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = test)(ORACLE_HOME = C:\oracle\product\10.2.0\db_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)) )(CONNECT_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:\oracle\product\10.2.0\db_1)(SID_NAME = 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 =(ADDRESS_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和控制文件路径。

还需要添加两个参数：db_file_name_convert=(¨c:\oracle\product\10.2.0\oradata\lichao¨,¨c:\oracle\product\10.2.0\oradata\lic hao¨)log_file_name_convert=(¨c:\oracle\product\10.2.0\oradata\lichao¨,¨c:\oracle\product\10.2.0\oradata\li chao¨)完成以上步骤后我们可以开始创建我们真正想要的参数文件：7,SQL>create spfile=’c:\oracle\product\10.2.0\db_1\database\spfilelichao.ora’ from pfile=’c:\abc.ora 使用RMAN完全备份原数据库导入数据：创建表空间lnxh_v2：Create tablespace lnxh_v2 datafile‟C:\oracle\product\10.2.0\oradata\tom\lnxh_v2.dbf‟ size 30000m;创建用户：lnxh_v2:create user lnxh_v2 identified by lnxh_v2 default tablespace Lnxh_v2;导入数据imp userid=lnxh_v2/lnxh_v2 file=c.\xx\lnxh.dmp log=imp.log fromuser=lnxh_v2 touser=lnxh_v2查看lnxh_v2用户表：SQL> select count(table_name) from dba_tables where owner='LNXH_V2';COUNT(TABLE_NAME)-----------------858SQL> select current_scn from v$database;CURRENT_SCN-----------820841Run{Backup 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’;}8复制库处于nomount状态。

9. 创建备份Rman target /Run{Backup 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/admin@testDUPLICATE TARGET DATABASE TO “test” nofilenamecheck查看复制库lnxh_v2用户表：SQL> select count(table_name) from dba_tables where owner='LNXH_V2';COUNT(TABLE_NAME)-----------------858SQL> select current_scn from v$database;CURRENT_SCN-----------820859启用主库块跟踪：alter database enable block change tracking；建立0级备份Run{Allocate channel d1 device type disk format …\\192.168.2.205/rman/DB_LV_0_%T_%t.rbf‟;BackupIncremental level 0 database tag …LV_0‟;SQL …AL TER SYSTEM ARCHIVE LOG CURRENT‟;Release channel d1;}建立一个1级备份Run{Allocate channel d1 type disk;BackupIncremental level 1Format …\\192.168.2.205/rman/%U‟(database);Release channel d1;}主库：restore database 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 datafile‘C:\oracle\product\10.2.0\oradata\tom\rman.dbf‟ size 50m;Create user rman_user identified by rman_user default tablespace rmantemporary tablespace temp;Rman>connect catalog rman_user/rman_userRman>create catalog tablespace rman;Rman>register database;登记备份文件和归档日志到RMAN仓库Rman>catalog start with‟c:\rman‟(如果复制过来的备份文件的路径和主库不同，要让RMAN知道这些文件在哪里。