一. 分析:RMAN并不支持客户端连接服务器进行备份,所以仍然需要在服务器上使用RMAN备份,客户要求备份至异地;[@more@]一. 分析:RMAN并不支持客户端连接服务器进行备份,所以仍然需要在服务器上使用RMAN备份,客户要求备份至异地;
二. 环境:
1. 两台win2003 Enterprise edition:主机名si_vm_w2k3,ip:192.168.2.204;备机名PC2 ip:192.168.2.205
2. 在si_vm_w2k3上和PC2上同时安装oracle 10.2.0.1.0;
3. ORACLE_HOME=C:oracleproduct10.2.0db_1.ORADATA=C:oracleproduct10.2.0oradatalichao;
三. 操作步骤:
1, 在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!;
5,重启si_vm_w2k3机器的两个服务;
备份可以备份在本地,有必要时再传到PC2上。
创建复制数据库:
1,创建口令文件 orapwd file=c:oracleproduct10.2.0db_1databasepwdlichao.ora password=admin entries=10
2,创建辅助数据库实例:
Oradim –new –sid test
4. 配置监听程序
在这里我们需要配置的监听有两个分别是原数据库和复制数据库的监听
TEST实例的监听
Listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test)
(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))
)
(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:oracleproduct10.2.0db_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:oracleproduct10.2.0oradatalichao¨,¨c:oracleproduct10.2.0oradatalichao¨)
log_file_name_convert=(¨c:oracleproduct10.2.0oradatalichao¨,¨c:oracleproduct10.2.0oradatalichao¨)
完成以上步骤后我们可以开始创建我们真正想要的参数文件:
7,SQL>create spfile=’c:oracleproduct10.2.0db_1databasespfilelichao.ora’ from pfile=’c:abc.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 tablespace
Lnxh_v2;
导入数据 imp userid=lnxh_v2/lnxh_v2 file=c.xxlnxh.dmp log=imp.log fromuser=lnxh_v2 touser=lnxh_v2
查看lnxh_v2用户表:
SQL> select count(table_name) from dba_tables where wner='LNXH_V2';
COUNT(TABLE_NAME)
-----------------
858
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
820841