要利用tsm client schedule，各节点需要装上tsm client端软件
平台：aix4.3.3
数据库版本：oracle8.0.5 EE
TSM Server Version：V4.2
Tivoli Data Protection For Oracle：v2.2
目标库：ora8_sc
catalog库:ora8_sb
1.ora8_sc设置为归档模式
$export ORACLE_SID=ora8_sc
SVRMGR>startup mount
SVRMGR>alter database archivelog;
SVRMGR>archive log start;
SVRMGR>alter database open;
改initora8_sc.ora
log_archive_start = true
log_archive_dest = /scfs/scarch
log_archive_format = sc%s_%t.ARC
重起数据库
查进程：
＃ps -ef |grep arc
VRMGR> connect internal
Connected.
SVRMGR> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /scfs/scarch
Oldest online log sequence 0
Next log sequence to archive 1
Current log sequence 1 |
2.进行rman配置
◆ 创建恢复目录（恢复目录置于库ora8_sb中）：
SVRMGR>connect system/xxxxxx@forsb |
◆ 建立recovery catalog数据库rman_1：
SVRMGR>create tablespace rman_1 datafile
'/sbfs/rman/rman_sc.dbf' size 50M online; |
◆ 在recovery catalog数据库上建rman用户
SVRMGR> create user rman identified by rman default tablespace
rman_1 temporary tablespace temp quota unlimited on rman_1;
Statement processed. |
◆ 授权
SVRMGR> grant recovery_catalog_owner to rman;
Statement processed.
SVRMGR> grant connect,resource to rman;
Statement processed. |
◆ 生成catalog(8.0.5版)
SVRMGR> connect rman/rman@forsb
.SVRMGR> @$ORACLE_HOME/rdbms/admin/catrman.sql |
◆ 注册目标数据库
$ export ORACLE_SID=ora8_sc
$ rman target system
Recovery Manager: Release 8.0.5.2.1 - Production
target database Password: ******
RMAN-06005: connected to target database: ORA8_SC
RMAN> connect rcvcat rman/rman@forsb
RMAN> register database;
RMAN-03022: compiling command: register
RMAN-03023: executing command: register
RMAN-08006: database registered in recovery catalog
RMAN-03023: executing command: full resync
RMAN-08029: snapshot controlfile name set to
default value: ?/dbs/snapcf_@.f
RMAN-08002: starting full resync of recovery catalog
RMAN-08004: full resync completeRMAN-06008:
connected to recovery catalog database |
◆ 列incarnation信息
RMAN> list incarnation of database;
RMAN-03022: compiling command: list
RMAN-06240: List of Database Incarnations
RMAN-06241:DB Key Inc Key DB Name DB ID CUR ResetSCN Reset Time
RMAN-06242:------ ------- ------- ------- --- ------- ----------
RMAN-06243:1 2 ORA8_SC 1832069077 YES 1 05-MAY-03 |
◆ 同步更新恢复目录
RMAN> resync catalog;
RMAN-03022: compiling command: resync
RMAN-03023: executing command: resync
RMAN-08002: starting full resync of recovery catalog
RMAN-08004: full resync complete |
◆ 当用RMAN连接目录数据库时，必须有sysdba权限，创建口令文件
$cd /user/oracle/app/oracle/product/8.0.5/dbs
$ orapwd file=orapwora8_sc password=xxxxx entries=5 |
◆ 在init.ora文件中增加以下参数：
vi /user/oracle/app/oracle/admin/ora8_sc/pfile/initora8_sc.ora
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE |
在init.ora文件中定义(win2k/nt需要在注册表中改才起作用，aix改文件.profile，否则会出现恢复时日期时间格式不对错误)
NLS_LANG=American_America.zhs16cgb231280(语言_地域.字符集)
NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
或改当前会话：
c:\>set nls_lang=American_America.zhs16cgb231280
c:\>set NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
SVRMGR> grant sysdba to system;
SVRMGR> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
INTERNAL TRUE TRUE
SYS TRUE TRUE
SYSTEM TRUE FALSE
3 rows selected.
SVRMGR> exit
Server Manager complete.
$ rman target system/xxxxxx@forsc rcvcat rman/rman@forsb
Recovery Manager: Release 8.0.5.2.1 - Production
RMAN-06005: connected to target database: ORA8_SC
RMAN-06008: connected to recovery catalog database
RMAN> |
3.编写脚本：
在h50a主机oracle用户的$ORACLE_HOME目录下
a)ora8_sc执行脚本 scfull_bk.sh
#!/usr/bin/ksh
ORACLE_HOME=/user/oracle/app/oracle/product/8.0.5;
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH;export PATH
su oracle -c "rman target system/xxxxxx@forsc rcvcat
rman/rman@forsb cmdfile /user/oracle/scfull_bk.scr
msglog /user/oracle/scbkdb.log" |
b)库备份脚本 scfull_bk.scr
run
{allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
backup
format '%d_full_%t_%s_%p'
database;
release channel t1;
}
run
{allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
sql 'alter system archive log current';
backup
format '%d_arch_%t_%s_%p'
archivelog all
delete input;
release channel t1;
}
$ chmod 755 scfull_bk.sh |
4.建立调度
TSM>def sched ora_domain daily_scfullbk_oracle desc=
"Daily Online ora8_sc full Backup" action=command objects=
"/user/oracle/scfull_bk.sh"
starttime=01:30 duration=15 duru=minutes period=1
perunits=day dayofweek=any
TSM>define association ora_domain daily_scfullbk_oracle tdp_h50a |
5.启动调度进程
以root登录，schedule后台运行
#cd /usr/tivoli/tsm/client/ba/bin/
# nohup dsmc schedule 2> /dev/null & |
6.试查备份结果log
#cat /user/oracle/app/oracle/admin/ora8_sb/udump/sbtio.log
…..
SBT-27866 03/29/2003 12:40:05 outl1ps.cpp(203):odsmSess():
# of dsmInit retries = 1
SBT-27866 03/29/2003 12:40:05 outl1ps.cpp(203):sbtinfo():
File ORA8_SB_full_489933283_50_1 is on storage pool BACKUPPOOL
#more /user/oracle/ scbkdb.log |
（责任编辑:西门吹风）
|
| 赛迪网推出“IT博客”，花不到一分钟就完成注册 |
|
【评论】
【推荐】
【大 中 小】
【打印】
【关闭】
|
