服务器&存储
2007-08-31 16:50    文章来源：网界网

数据库分离与数据备份

作者：甘荃

技巧五：解决oracle rman不能使用tsm备份到磁带库上的问题，

RMAN> backup incremental level 0 database plus archivelog delete all input tag=W

eekly_level_0_Backup;

Starting backup at 2005-07-26 20:06:36

current log archived

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 07/26/2005 20:06:37

ORA-03113: end-of-file on communication channel

但能够成功备份到磁盘上，执行dsmc，出现了coredump。分析问题应该在tsm上。查看core文件

gjjb>dbx dsmc core

Type 'help' for help.

[using memory image in core]

reading symbolic information ...

IOT/Abort trap in pthread_kill at 0x9000000004f3158 ($t1)

0x9000000004f3158 (pthread_kill+0x9c) e8410028 ld r2,0x28(r1)

(dbx) where

pthread_kill(??, ??) at 0x9000000004f3158

_p_raise(??) at 0x9000000004f2b84

raise.raise(??) at 0x900000000042f64

abort() at 0x9000000000502a4

psAbort__Fv() at 0x100006f8c

psTrapHandler__FiT1P12__sigcontext() at 0x100006f28

strcpy.strcpy() at 0x10000b84c

StrCpy__FPcPCc() at 0x100008d10

最后，把tsm从5.2.2.9升级到5.2.4，dsmc可以正常使用，同时oracle rman成功备份到磁带库上。

 技巧四：Recovering a Backup Made Before a RESETLOGS的步骤

obtain primary key of old incarnation ：LIST INCARNATION OF DATABASE syrun.

RMAN> list incarnation of database syrun;

List of Database Incarnations

DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1 28 SYRUN 3143198795 NO 1 2005-06-18:17:43:39

1 2 SYRUN 3143198795 NO 109807 2005-06-20:00:49:06

1 16715 SYRUN 3143198795 YES 14102235 2005-07-28:11:56:06

1 1428 SYRUN 3143198795 NO 14104660 2005-07-27:16:33:36

RESET DATABASE TO INCARNATION 2;

恢复脚本：

run {

shutdown immediate;

startup nomount;

set until time='2005-07-27:14:03:54';

RESTORE CONTROLFILE;

alter database mount;

restore database;

recover database;

alter database open resetlogs;

}

数据库恢复之后需要执行如下步骤，例如：

ALTER TABLESPACE "GJJTMP" ADD TEMPFILE '/dev/rora_gjjtmp' size 6000M REUSE;

ALTER TABLESPACE "TEMP" ADD TEMPFILE '/dev/rora_tmp' size 250M REUSE

文章来源：Chinabyte

1  2  3  
责任编辑：张鑫

文章评论

发表评论
查看全部
评论加载中...请稍后

精彩专题