Backup Exec 12 for oracle RAC安装-配置-应用

1、Backup Exec 12.5 for Oracle RAC安装-配置-应用一. Oracle设置（注：如无特别说明，以下操作分别在RAC所有节点执行）由于BE备份Oracle时, 需要Oracle处于归档模式1. 配置Oracle归档模式SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/oralog' scope=spfile;System altered.SQL> ! env | grep ORACLE_SIDORACLE_SID=orclSQL> create pfile='

2、/u01/app/orabak/pfileorcl.ora' from spfile;File created.SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup mount;ORACLE instance started.Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 79694068 bytesDatabase Buff

3、ers 83886080 bytesRedo Buffers 2973696 bytesDatabase mounted.SQL> alter database archivelog;Database altered.SQL> alter database open;Database altered.SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /u01/app/oralogOldest online log sequence

4、26Next log sequence to archive 28Current log sequence 28二. 安装RALUS注意: 在root用户下执行建立解压目录rootpopgo-tsdb #mkdir /opt/ralus解压到/opt/ralusrootpopgo-tsdb # tar zxvf /mnt/hgfs/share/BackupExec/BEWS_12.5.2213_LINUX-UNIX-MAC-SAP_AGENTS.tar.gz -C /opt/ralus安装RALUSrootpopgo-tsdb # /opt/ralus/installralusERROR: V

5、XIF_HOME is invalid. It must point to the root of VxIF. Exiting .rootpopgo-tsdb # cd /opt/ralusrootpopgo-tsdb ralus# ./installralus设置安装RALUS的主机, 即为popgo-tsdbSymantec Backup Exec for Windows Servers Remote Agent for Linux/Unix Servers 12.5.2213Enter the system names separated by spaces on which to in

6、stall RALUS: (popgo-tsdb)Checking system communication: Checking OS version on popgo-tsdb . Linux 2.6.9-55.ELsmp Checking system support for popgo-tsdb . Linux 2.6.9-55.ELsmp supported by RALUSInitial system check completed successfully.Press Return to continue:备份的通信端口检查, 一定要先确认端口是否有被占用Symantec Back

7、up Exec for Windows Servers Remote Agent for Linux/Unix Servers 12.5.2213Checking system installation requirements:Checking RALUS installation requirements on Linux target systems: popgo-tsdbChecking RALUS installation requirements on popgo-tsdb: Checking file system space . required space is availa

8、bleInstallation requirements checks completed successfully.Press Return to continue: Checking for prerequistes . Done Checking for Port 10000 . Done设置介质服务器, 即为BE12.5主机名和IP, 此步一定要设置正确 Remote Agent Media Server ConfigurationTo display the Remote Agent as a selection in a media server's backup sele

9、ction tree, and to be able to specify a local network for use between the Remote Agent and a media server, enter the names or IP addresses of the media servers that you want the Remote Agent to communicate with. An IP Address: XXX.XXX.XXX.XXX A Host Name: COMPUTERNAMEEnter a directory host:192.168.4

10、0.13Do you want to add another name or address for this agent? y, n (n)n再次确认, 如果有错可以直接改. 最好把BE主机名/IP写入/etc/hosts Remote Agent Media Server ConfigurationHostnames and/or IP addresses verification: Address: 192.168.40.13Is this information correct? y, n (y)y设置beoper组及组内用户, 一定把oracle用户加入此组 Remote Agent

11、 User Group SetupTo perform backups, you must have a 'beoper' user group. This user group can be created only if you are not using NIS server. Your system will be scanned to detect a NIS server, group and membership.Press Return to continue: Checking if system uses NIS server: . NoThe instal

12、ler will now check your system for the 'beoper' user group and root membership.Press Return to continue: Checking for 'beoper' user group: . Not Found Checking for 'root' user membership in 'beoper' user group: . Not FoundYou can create 'beoper' user group man

13、ually or you can choose to have it created automatically.Do you want installer to create 'beoper' user group? y, n (y)yDo you want to use specific group ID when creating 'beoper' user group? y, n (n) Creating group 'beoper': . DoneDo you want to add the 'root' user to

14、 'beoper' user group? y, n (y)y Adding 'root' user to 'beoper' user group: . DonePress Return to continue:安装RALUS所需的包Symantec Backup Exec for Windows Servers Remote Agent for Linux/Unix Servers 12.5.2213Checking Symantec Backup Exec for Windows Servers Remote Agent for Linux/

15、Unix Servers on popgo-tsdb: Checking VRTSralus package . not installedPress Return to continue:Symantec Backup Exec for Windows Servers Remote Agent for Linux/Unix Servers 12.5.2213Installing Symantec Backup Exec for Windows Servers Remote Agent for Linux/Unix Servers on popgo-tsdb: Installing VRTSr

16、alus 12.5.2213 on popgo-tsdb . done 1 of 1 stepsSymantec Backup Exec for Windows Servers Remote Agent for Linux/Unix Servers installation completed successfully.Press Return to continue: Copying new initialization scripts . Done Creating RALUS linkedname in rc2.d . Done Creating RALUS linkedname in

17、rc3.d . Done Creating RALUS linkedname in rc5.d . Done Updating RALUS files for beoper . Done安装成功, 并确认RALUS配置参数文件/etc/VRTSralus/ralus.cfg是否生成Symantec Backup Exec for Windows Servers Remote Agent for Linux/Unix Servers 12.5.2213Configuring Symantec Backup Exec for Windows Servers Remote Agent for Lin

18、ux/Unix Servers: Creating configuration files . DoneSymantec Backup Exec for Windows Servers Remote Agent for Linux/Unix Servers configured successfully.Press Return to continue:The response file is saved at: /var/tmp/vxif/installralus1117215008/installralus1117215008.responseThe installralus log is

19、 saved at: /var/tmp/vxif/installralus1117215008/installralus.logrootpopgo-tsdb ralus# id oracleuid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)使用以下命令将用户oracle添加到beoper组：rootpopgo-tsdb ralus# usermod -G dba,beoper oracle在每一个节点上复制/etc/oratab到/etc/VRTSralus/beoratab，并使用vi对/etc/VRTSralus/

20、beoratab进行编辑。 注意：oratab中的实例名称为RAC群集的虚拟实例，请在每个节点上编辑/etc/VRTSralus/beoratab内的实例名，更改为物理节点上所运行的实际实例名。 在本例子中虚拟实例为orcl，在节点1上的物理实例为orcl1，节点2的物理实例为orcl2。下图为在节点1上修改后的配置，在节点2上红色圈起部分应该为orcl2： 三. 配置RALUS及Oracle参数rootpopgo-tsdb # /opt/VRTSralus/bin/AgentConfigSymantec Backup Exec Remote Agent Utility Choose one

21、of the following options: 1. Configure database access 2. Configure Oracle instance information 3. Quit Please enter your selection: 1Configuring machine information Choose one of the following options: 1. Add system credentials for Oracle operations 2. Edit system credentials used for Oracle operat

22、ions 3. Remove system credentials used for Oracle operations 4. View system credentials used for Oracle operations 5. Quit Please enter your selection: 4 No objects have been configured.Configuring machine information Choose one of the following options: 1. Add system credentials for Oracle operatio

23、ns 2. Edit system credentials used for Oracle operations 3. Remove system credentials used for Oracle operations 4. View system credentials used for Oracle operations 5. Quit Please enter your selection: 1 Enter a user name that has local system credentials: oracle Enter the password: Re-enter passw

24、ord: Validating credentials. Do you want to use the full computer name/IP address for Oracle operations? (Y/N): y Enter the full computer name or IP address: 192.168.40.15 -要和设置Oracle服务器身份验证凭证的服务器格式一样. Do you want to use a custom port to connect to the media server during Oracle operations? (Y/N): n

25、 Commit Oracle operation settings to the configuration file? (Y/N): y SUCCESS: Successfully added the entry to the configuration file.Configuring machine information Choose one of the following options: 1. Add system credentials for Oracle operations 2. Edit system credentials used for Oracle operat

26、ions 3. Remove system credentials used for Oracle operations 4. View system credentials used for Oracle operations 5. Quit Please enter your selection: 5Symantec Backup Exec Remote Agent Utility Choose one of the following options: 1. Configure database access 2. Configure Oracle instance informatio

27、n 3. Quit Please enter your selection: 2If this computer is a RAC node, you must perform additional steps for configuration before you continue. Refer to the readme for these additional steps.Configuring the Oracle Agent Choose one of the following options: 1. Add a new Oracle instance to protect 2.

28、 Edit an existing Oracle instance 3. Delete an existing Oracle instance 4. View Oracle instance entries that have been added in the Remote Agent Utility 5. Quit Please enter your selection: 4 No objects have been configured.Configuring the Oracle Agent Choose one of the following options: 1. Add a n

29、ew Oracle instance to protect 2. Edit an existing Oracle instance 3. Delete an existing Oracle instance 4. View Oracle instance entries that have been added in the Remote Agent Utility 5. Quit Please enter your selection: 1 Select an Oracle instance to configure Entry 1. orcl1 Enter the number 0 to

30、go back Enter your selection: 1 Enter the Oracle database SYSDBA user name: sys Enter the Oracle database SYSDBA password: Re-enter password: Validating credentials. Enter the media server name or IP address: 192.168.40.13 Do you use a recovery catalog? (Y/N):n Do you want to use a customized job te

31、mplate? (Y/N): n Commit Oracle operation settings to the configuration file? (Y/N): y Created symbolic link for /opt/VRTSralus/bin/libobk.so at /u01/app/oracle/product/10.2.0/db_1/lib/libobk.so SUCCESS: Successfully added the entry to the configuration file.Configuring the Oracle Agent Choose one of

32、 the following options: 1. Add a new Oracle instance to protect 2. Edit an existing Oracle instance 3. Delete an existing Oracle instance 4. View Oracle instance entries that have been added in the Remote Agent Utility 5. Quit Please enter your selection: 5Symantec Backup Exec Remote Agent Utility C

33、hoose one of the following options: 1. Configure database access 2. Configure Oracle instance information 3. Quit Please enter your selection: 3设置完后, 可再检查RALUS配置参数文件/etc/VRTSralus/ralus.cfg参数是否正确四. 启动RALUS一般用第二种启动方式, 可以看到RALUS后台处理的相应log或/var/VRTSralus Log日志文件夹rootpopgo-tsdb # /etc/init.d/VRTSralus.i

34、nitSymantec Backup Exec Remote Agent for Linux/Unix Servers（此为系统自动启动）Usage: VRTSralus.init start | stop | restart rootpopgo-tsdb # /opt/VRTSralus/bin/beremote -log-console五. Oracle服务器身份验证凭证设置登陆到备份服务器，打开Backup Exec的控制台，从菜单中选择“网络”-“登陆账户”打开“登陆账户管理”窗口，然后点击“新建”按钮，添加用于备份服务器与Oracle服务器操作系统连接的账号，该账号应该与第3步骤中O

35、racle服务器上所添加的帐号一致，在“登陆账户管理”窗口再次点击“新建”按钮，添加用于连接Oracle实例的账号：完成账号添加后，请点击菜单中的“工具”，选择“选项”打开选项属性页。在窗口左边选择Oracle，然后点击右边窗口的“修改列表”按钮打开“Oracle服务器和DB2服务器的身份验证凭证”窗口，然后点击“新建”按钮添加凭证，在“Oracle或DB2服务器”里输入Oracle服务器的主机名，然后在“登陆账户”里下拉选择所创建的用于连接Oracle服务器操作系统的账号：六. 建立BE与oracle的连接（以下操作为初始时做一次即可）启动BE，点击工具栏的“备份”按钮盘的小箭头，从下拉菜单

36、中选择“新建备份作业”，在“资源视图”中展开Oracle Real Application Clusters，但请不要点击RAC群集前面的 + 号，应该使用右键对该Oracle RAC单击，然后从菜单中选择“连接”，参考下图：在弹出的“登陆账户选择”窗口中选择用于连接Oracle RAC系统的账号，通过身份验证后再点击Oracle RAC前的 + 号展开群集： 同样不要先点击Oracle实例前面的 + 号，右键单击该实例，并选择“连接”：在弹出的“登陆账户选择”窗口中选择用于连接Oracle实例的账号，通过身份验证后再点击Oracle实例前的 + 号展开：展开实例后选择需要备份的内容：选择需要

37、备份的内容后，从“备份作业属性”的窗口左边选择“资源凭证”，由于Linux服务器无法验证Windows提交的用户，故点击“全部测试”按钮，测试结果为“此功能没有实现”，但是不影响备份。至此备份Oracle服务器的前提条件均已经满足，您可以继续在该作业属性窗口调整其他作业属性，如“设备和介质”、“备份方法”等。注意：资源中连接服务器的账号跟连接实例的账号有所不同，连接服务器的账号应该为所创建的账号oracle，而连接实例的账号sys，如果账号不正确，可以选中资源后点击“改变”按钮修改。七. 建立备份策略1.全库的完全备份：运行BE，点击备份按钮下的倒三角，选择“新建备份做业”进入备份作业属性窗口

38、，选择：源-选择项-资源收藏夹-Linux/Unix服务器-“计算机名”-Oracle数据库“库名”，在“Oracle数据库”前打上勾，并在“选择项列表名称”输入好记的名字，这里输入“Oracle_full”。选择：目标-设备和介质，在这里选择事先建立好的设备和介质集。选择：设置-Oracle，在备份方法中选择“完全”，勾选“删除备份的归档日志”其它不选。选择：频率-计划-按计划运行。点击“编辑计划详细信息”，进入计划编辑窗口。按如下计划进行：预定周期：点“日”，每个星期日。时间窗口：开始不早于：23：30：00-并且不晚于：23：50：00点击确定，计划将于每个星期日23：30至23：50进

39、行Oracle全备。2.表空间的完全备份：与全库备份相似，修改如下设置即可。名称：data1_full资源：选择DATA1表空间与Archived logsOracle：完全，其它不要勾选。计划：预定周日-选“全置” 时间窗口-开始不早于：23：00：00-并且不晚于：23：30：003.表空间的差异备份：与表空间完全备份相似，修改如下设置即可。名称：data1_cy资源：只选择DATA1表空间Oracle：差异，勾选“不备份已经备份的归档日志”计划：预定周日-选“全置” 时间窗口-开始不早于：07：00：00-并且不晚于：22：30：00 重启时间间隔-勾选“任务的重启间隔”-00：20：00（注：每20分钟一次）建立好以上策略后，可以在BE的“作业监视器”中看到已经建立好的作业在等待计划。八. 进行备份测试在“作业监视器”里分别对要测试的计划作业点击右键，选择“立即运