2023年12月23日发(作者:)
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_ 文件来进行安装。
将安装包使用SSH工具传到Linux系统的/symantec目录中。解压缩后,使用下面命令及过程安装即可。其实过程很简单,没有什么要配置的。
[root@oracleserver]# mkdir /symantec
[root@oracleserver symantec]# tar –zxvf RALUS_RMALS_
[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 5
Checking system support for oracleserver ... Linux 5 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:
制作:Evan 邮箱:370048648@
- 1 -
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:
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
制作:Evan 邮箱:370048648@
- 2 -
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.
Press [Return] to continue:
The response file is saved at:
/var/tmp/vxif/installralus1228114914/se
The installralus log is saved at:
/var/tmp/vxif/installralus1228114914/
配置过程如下:
[root@oracleserver symantec]# cd /etc/init.d/ start {启动Agent服务}
Starting Symantec Backup Exec Remote Agent ......
Starting Symantec Backup Exec Remote Agent: [ OK ]
[root@oracleserver init.d]# vi /etc/rc.d/
加入下面一行,让开机后自动启动。
/etc/init.d/ start
制作:Evan 邮箱:370048648@
- 3 -
安装完成后,重起一下Linux系统。
[root@oracleserver init.d]# vi /etc/VRTSralus/
可以在此文件中,去更改介质服务器(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; {查看当前模式}
制作:Evan 邮箱:370048648@
- 4 -
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/
制作:Evan 邮箱:370048648@
- 5 -
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/dbs/
将下面这行启用。
log_archive_start = true
log_archive_dest = disk$rdbms:[e]
log_archive_format = "T%TS%"
经过上面设定后,退出数据库,重起一次Linux系统,再以oracle用户登录,重新用命令archive log list检查一下,是否为归档日志模式。正式使用的生产环境下,系统是需要打开日志归档功能的。默认Oracle安装完成后,此功能是没有打开的,所以才需要上面步骤去配置它。
三、数据库备份
1、在BE管理控制台上,点击“Tools > Options > Oracle”,新建立一个oracle用户,用于登录Linux数据库服务器,密码就是Linux系统中oracle帐号的密码。如下图,点击“修改列表”。
制作:Evan 邮箱:370048648@
- 6 -
2、新建立一个备份向导,在Linux服务器点击右键,选择“连接为...”如下图。
3、建立一个数据库的帐号与密码。帐号sys,密码即当初Oracle安装时的数据库管理密码。同时,也建立一个oracel帐号,密码即为Linux系统当中此用户的密码。此时建立的两个帐号,将会在备份时用到。如下图
制作:Evan 邮箱:370048648@
- 7 -
4、选择刚刚建立的oracle用户,连接成功后,显示如下图。
5、最后选择备份介质集等信息。在此处就不再描述。
四、数据库恢复
1、再以oracle帐号登录,在Linux Oracel数据库控制台中。下两个命令,将数据库停用,再才可以开始还原动作。
[oracle@oracleserver bin]$ /oracle/10g/bin/sqlplus /nolog
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
制作:Evan 邮箱:370048648@
- 8 -
Variable Size 138413648 bytes
Database Buffers 142606336 bytes
Redo Buffers 2973696 bytes
Database mounted.
2、进入windows当中的BE管理控制台上,选择恢复向导,出现如下图。
2、测试帐号是否成功。如下图
制作:Evan 邮箱:370048648@
- 9 -
3、设定Oracle恢复选项,如下图。
4、最后完成恢复过程。最好是重起一下Linux系统。
五、其它FAQ部分
如果备份部分的第1步没有去设定,则会出现下面的出错信息:
出错信息2如下图:
制作:Evan 邮箱:370048648@
- 10 -
处理方法:在DOS命令提示符下面,输入bemig命令。
C:Program FilesSymantecBackup Exec>
先停用BE所有服务后,下如下命令。待执行完后,再启动所有服务。
C:Program FilesSymantecBackup Exec> -r
制作:Evan 邮箱:370048648@
- 11 -


发布评论