使用RMAN实现异机备份恢复 WIN平台

最新推荐文章于 2024-04-07 22:32:28 发布
这个就不用说了吧
最新推荐文章于 2024-04-07 22:32:28 发布
阅读量632
点赞数
本文链接：https://blog.csdn.net/fsfsdfsdw/article/details/86564619
版权
本文详细介绍了如何在Windows平台上使用RMAN进行异机备份和恢复操作，涵盖RMAN概述、配置、备份、恢复等多个方面，并提供故障处理和ASM、SQL/PLSQL等相关知识的参考链接。
摘要由CSDN通过智能技术生成
                        
                  --=================================
 
-- 
 使用RMAN实现异机备份恢复(WIN平台)
 
--================================= 
 
    在有些情况下，如数据库服务器处于磁盘空间的压力或成本控制需要将数据文件备份到异机，使用RMAN可以完成该工作。基于Windows平台 
 
所需完成的配置相对简单，仅仅是添加账户与使用新增的帐户来启动数据库服务以及设置共享路径。 
 
    下面给出具体描述。 
 
 一、配置数据库服务器与备份目的主机 
 
    1. 帐户配置(假定有主机A,B 且A为数据库服务器，B为备份目的主机，且能互相ping通)     
 
            如果主机A与主机B使用的Administrator密码相同，且A上的OracleServiceDBNAME服务和OracleOraHome92TNSListener服务都以"本 
 
        地系统账户登陆" 
 
            如果主机A与主机B使用不同的Administrator密码，处于安全考虑不宜设为相同，则则可以分别在主机A与主机B上新建一用户，假 
 
        定在主机A上建立DBA_oracle，密码为ORA_PWD，则在主机B上也建立该用户(用户名可以不同，密码必须相同)，密码同样设置为ORA_PWD 
 
        。将刚建好的用户在各自主机将其加入到Aministrators组 
 
    2. 设定OracleServiceDBNAME服务和OracleOraHome92TNSListener服务的启动帐户。在运行处输入services.msc。在主机A上设定使用此帐 
 
        户登陆，即使用刚刚建立的DBA_oracle，输入密码启动，该设置需要重启后有效 
 
    3. 在主机B上设定共享文件夹，如RMAN_Shared，设置其权限为完全控制(在A上使用\\IP\RMAN_Shared测试是否可写入文件) 
 
 二、查看RMAN的配置与数据库情况        
 
  RMAN> show CONTROLFILE AUTOBACKUP;                                                                                                                                                                                                RMAN 配置参数为:                                                                                                 CONFIGURE CONTROLFILE AUTOBACKUP ON;    -->控制文件自动备份，建议开启                                                                                                                                                             RMAN> show CONTROLFILE AUTOBACKUP FORMAT;                                                                                                                                                                                         RMAN 配置参数为:                                                                                                 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\\192.168.1.151\RMAN_Shared\CONTROL             _%F';                                   -->控制文件备份位置                                                                                                                                                                       RMAN> show SNAPSHOT CONTROLFILE NAME;                                                                                                                                                                                             RMAN 配置参数为:                                                                                                 CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\ORA92\DATABASE\SNCFTESTHH.ORA'; # default   -->快照控制文件位置                                                                                                                 SQL> select * from v$version;    -->数据库的版本，当前演示环境为Oracle 9i                                                                                                                                                         BANNER                                                                                                           ----------------------------------------------------------------                                                 Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production                                                       PL/SQL Release 9.2.0.1.0 - Production                                                                            CORE    9.2.0.1.0       Production                                                                               TNS for 32-bit Windows: Version 9.2.0.1.0 - Production                                                           NLSRTL Version 9.2.0.1.0 - Production                                                                                                                                                                                             SQL> show parameter db_name                                                                                                                                                                                                       NAME                                 TYPE        VALUE                                                           ------------------------------------ ----------- ---------------                                                 db_name                              string      testHH