Symantec Backup Exec 12.5备份Linux下的Oracle 10G
测试环境:
VMware Workstation V6.5.1,Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
Linux CentOS V5.5 32位版本。Windows 2003 R2+SP2 安装BE V12.5,IP为172.18.12.211。
Intel Core2 P8700 2.53G CPU ,1G内存,硬盘40G。采用虚拟机的安装方式。
一、Linux RALUS 安装与配置
Linux系统中,首先需要安装的就是RALUS(Symantec Remote Agent for Linux or Unix Server)。装好它后,Symantec BE备份软件才可以发现Linux系统,从而进行备份。
注意:
1、安装前,如果您的Linux系统使用了webmin程序,请将它的管理端口改掉,由默认的10000 port改为88好了。
2、在Linux里面,使用命令 rpm -qa |grep compat查询一下,看compat-libstdc++-33-3.2.3-61 包是否有安装。
3、确认Windows Symantec BE V12.5里面有“Remote Media Agent for Linux Servers”和“Agent for Oracle on Window or Linux Servers”的许可证安装在里面了。
建议使用Backup Exec 2010R2 DVD光盘里面的RALUS_RMALS_RAMS-4164. 文件来进行安装。
将安装包使用SSH工具传到Linux系统的/symantec目录中。解压缩后,使用下面命令及过程安装即可。其实过程很简单,没有什么要配置的。
[root@oracleserver]# mkdir /symantec
[root@oracleserver symantec]# tar –zxvf  RALUS_RMALS_RAMS-4164.
[root@oracleserver symantec]# ./installralus
Symantec Backup Exec Remote Agent for Linux/Unix Servers 13.0.4164
Enter the system names separated by spaces on which to install RALUS: (oracleserver)
Checking system communication:
Checking OS version on oracleserver .............. Linux 2.6.18-194.el5
Checking system support for oracleserver ... Linux 2.6.18-194.el5 supported by RALUS
Initial system check completed successfully.
Press [Return] to continue:
Symantec Backup Exec Remote Agent for Linux/Unix Servers 13.0.4164
installralus will install the following RALUS packages on Linux target system: oracleserver
VRTSralus        Symantec Backup Exec Remote Agent for Linux/Unix Servers
Press [Return] to continue:
Symantec Backup Exec Remote Agent for Linux/Unix Servers 13.0.4164
Checking system installation requirements:
Checking RALUS installation requirements on Linux target systems: oracleserver
Checking RALUS installation requirements on oracleserver:
Checking file system space ................ required space is available
Installation requirements checks completed successfully.
Press [Return] to continue:
Checking for prerequisites ....................................... Done
Checking for Port 10000 .......................................... Done
Remote Agent Media Server Configuration
To display the Remote Agent as a selection in a media server's backup selection 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 on 'oracleserver' to communicate with.          An IP Address: XXX.XXX.XXX.XXX
A Host Name: COMPUTERNAME
Enter a directory host:172.18.12.211
Do you want to add another name or address for this agent? [y, n] (n)n
Remote Agent Media Server Configuration
Hostnames and/or IP addresses verification for 'oracleserver':
Address: 172.18.12.211
Is this information correct? [y, n] (y)y
Remote Agent User Group Setup
To 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 'oracleserver' will be scanned to detect a NIS server, group and membership.
Press [Return] to continue:
Checking if system uses NIS server: ............................... No
The installer 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 Found
You can create 'beoper' user group manually or you can choose to have it created automatically.
Do you want installer to create 'beoper' user group on 'oracleserver'? [y, n] (y)y
Do you want to use specific group ID when creating 'beoper' user group? [y, n] (n)y
Enter group ID for 'beoper' user group:400
Creating group 'beoper'with group ID '400': ...................... Done
Do you want to add the 'root' user to 'beoper' user group? [y, n] (y)y
Adding 'root' user to 'beoper' user group: ...................... Done
Press [Return] to continue:
Symantec Backup Exec Remote Agent for Linux/Unix Servers 13.0.4164
Checking Symantec Backup Exec Remote Agent for Linux/Unix Servers on oracleserver:
Checking VRTSralus package .............................. not installed
Press [Return] to continue:
Symantec Backup Exec Remote Agent for Linux/Unix Servers 13.0.4164
Installing Symantec Backup Exec Remote Agent for Linux/Unix Servers on oracleserver:
Installing VRTSralus 13.0.4164 on oracleserver ...... done 1 of 1 steps
Symantec Backup Exec Remote Agent for Linux/Unix Servers installation completed successfully.  Press [Return] to continue:
Copying new initialization scripts ............................... Done
Updating RALUS files for beoper .................................. Done
Symantec Backup Exec Remote Agent for Linux/Unix Servers 13.0.4164
Configuring Symantec Backup Exec Remote Agent for Linux/Unix Servers:
Creating configuration files on oracleserver ..................... Done
Symantec Backup Exec Remote Agent for Linux/Unix Servers configured successfully.
linux安装数据库oraclePress [Return] to continue:
The response file is saved at:
/var/tmp/vxif/sponse
The installralus log is saved at:
/var/tmp/vxif/installralus1228114914/installralus.log
配置过程如下:
[root@oracleserver symantec]# cd /etc/init.d/VRTSralus.init start{启动Agent服务}
Starting Symantec Backup Exec Remote Agent ......
Starting Symantec Backup Exec Remote Agent:                              [  OK  ]
[root@oracleserver init.d]# vi /etc/rc.d/rc.local
加入下面一行,让开机后自动启动。
/etc/init.d/VRTSralus.init start
安装完成后,重起一下Linux系统。
[root@oracleserver init.d]#  vi  /etc/VRTSralus/ralus.cfg
可以在此文件中,去更改介质服务器(BE)的IP地址。
二、Linux Oracel配置
以root用户登录进Linux系统中,将oracle用户加入到beoper组里面。
[root@oracleserver ~]# vi /etc/group
oinstall:x:501:oracle
beoper:x:400:root,oracle
[root@oracleserver ~]#id oracle
uid=501(oracle) gid=400(beoper) groups=400(beoper),501(oinstall),502(dba)
再次用SSH以oracle用户登录系统。执行下面命令
[oracle@oracleserver bin]$ /oracle/10g/bin/sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 28 15:03:43 2010
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> conn sys/oracle as sysdba
Connected.
SQL> shutdown immediate{关闭数据库}
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size            117442128 bytes
Database Buffers          163577856 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> archive log list; {查看当前模式}
Database log mode              No Archive Mode
Automatic archival            Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence    17
Current log sequence          19
SQL> alter database force logging;
Database altered.
SQL> alter database archivelog; {设定数据库为归档日志模式}
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;  {确定数据库为归档日志模式}
Database log mode              Archive Mode
Automatic archival            Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence    19
Next log sequence to archive  21
Current log sequence          21
注意,以下两项必须显示是这样子的。
Database log mode            Archive Mode
Automatic archival            Enabled
SQL> alter system archive log start;  {设定数据库为自动归档日志模式}
System altered.
SQL> show parameter db_recovery;{10g使用db_recovery_file_dest来作为归档日志的存放地} NAME                                TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /oracle/flash_recovery_area/
db_recovery_file_dest_size          big integer 2G
SQL> alter system set db_recovery_file_dest_size=21474836480;{设定日志大小为20G,不设定也可} System altered.
修改配置文件,让自动归档日志模式自动起动。
[root@oracleserver 10g]# vi /oracle/10g/a
将下面这行启用。
log_archive_start = true
log_archive_dest = disk$rdbms:[oracle.archive]
log_archive_format = "T%TS%S.ARC"
经过上面设定后,退出数据库,重起一次Linux系统,再以oracle用户登录,重新用命令archive log list检查一下,是否为归档日志模式。正式使用的生产环境下,系统是需要打开日志归档功能的。默认Oracle安装完成后,此功能是没有打开的,所以才需要上面步骤去配置它。
三、数据库备份
1、在BE管理控制台上,点击“Tools > Options > Oracle”,新建立一个oracle用户,用于登录Linux数据库服务器,密码就是Linux系统中oracle帐号的密码。如下图,点击“修改列表”。