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 -