您的位置： 首页-> 电脑文摘-> 数据库类-> Oracle-> 正文

Oracle Rman/tivoli-TDP/下数据恢复到节点
作者：佚名 来源：InterNet 加入时间：2005-1-31
AIX平台：4.3.3

Oracle版本： 8.0.5

从节点RS/6000 h50b备份的数据现恢复到节点43p-db。



43p-db：

一、把43p-db的tdpo_node文件的TDPO_NODE改为 h50b的node name 

# vi /usr/tivoli/tsm/client/oracle/bin/tdpo.opt
TDPO_NODE               tdp_h50b
# cd /usr/tivoli/tsm/client/oracle/bin/
# tdpoconf password 
************************************************************
*       Tivoli Data Protection for Oracle Utility           *
*  Password file initialization/update program              *
*     ROOT privilege needed to update value                 *
*************************************************************
Please enter current password:
Please enter new password:
Please reenter new password for verification:
ANU0260I Password successfully changed.


二、Copy h50B的configora8_sb.ora initora8_sb.ora和口令文件到43p-db相应目录。所有相应的目录都要预先创建好。

三、43p-db的oracle为Startup nomount状态。 

在H50b:
  恢复控制文件
$ export ORACLE_SID=ora8_sb
$ rman target system/passwd1@43p-db rcvcat rman/rman@forjy
Recovery Manager: Release 8.0.5.2.1 - Production

RMAN-06006: connected to target database: ora8_sb (not mounted)
RMAN-06008: connected to recovery catalog database
RMAN> run {
 allocate channel t1 type 'sbt_tape' parms
 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)'; 
 restore controlfile to '/sbfs/ctl01sb.ctl'; 
 release channel t1; 
 allocate channel d1 type disk; 
 replicate controlfile from '/sbfs/ctl01sb.ctl';
 sql 'alter database mount'; 
 release channel d1; 
}
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=12 devtype=SBT_TAPE
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=0 set_stamp=0
RMAN-08021: channel t1: restoring controlfile
RMAN-08505: output filename=/sbfs/ctl01sb.ctl
RMAN-08023: channel t1: restored backup piece 1
RMAN-08511: piece handle=ORA8_SB_full_497711454_17_1 params=NULL
RMAN-08024: channel t1: restore complete
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=12 devtype=DISK
RMAN-03022: compiling command: replicate
RMAN-03023: executing command: replicate
RMAN-08058: replicating controlfile
RMAN-08506: input filename=/sbfs/ctl01sb.ctl
RMAN-08505: output filename=/sbfs/sbdata1/ctl02sb.ctl
RMAN-08505: output filename=/sbfs/sbdata2/ctl03sb.ctl
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter database mount
RMAN-03023: executing command: sql
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1
RMAN>exit
Recovery Manager complete.


四、获取最近ARCHIVED REDO LOGS线程中最小的SCN号，进行不完全恢复。 

在h50b上
SQL> SELECT min(scn) FROM (SELECT max(next_change#) scn
FROM v$archived_log GROUP BY thread#);
  MIN(SCN)
----------
  99561745


五、恢复数据文件 

$  rman target system/passwd1@43p-db rcvcat rman/rman@forjy
Recovery Manager: Release 8.0.5.2.1 - Production
RMAN-06005: connected to target database: ORA8_SB
RMAN-06008: connected to recovery catalog database
RMAN> run {
set until scn= 99561745;
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
restore database;
recover database;
release channel t1;
sql "alter database open resetlogs";
}
RMAN-03022: compiling command: set
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=10 devtype=SBT_TAPE
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=17 set_stamp=497711454
RMAN-08019: channel t1: restoring datafile 1
RMAN-08509: destination for restore of datafile 1:
　　/sbfs/system01sb.dbf
RMAN-08019: channel t1: restoring datafile 2
RMAN-08509: destination for restore of datafile 2:
　　/sbfs/rbs01sb.dbf
RMAN-08019: channel t1: restoring datafile 3
RMAN-08509: destination for restore of datafile 3:
　　/sbfs/temp01sb.dbf
RMAN-08019: channel t1: restoring datafile 4
RMAN-08509: destination for restore of datafile 4:
　　/sbfs/tools01sb.dbf
RMAN-08019: channel t1: restoring datafile 5
RMAN-08509: destination for restore of datafile 5:
　　/sbfs/users01sb.dbf
RMAN-08019: channel t1: restoring datafile 6
RMAN-08509: destination for restore of datafile 6:
　　/sbfs/sb01.dbf
RMAN-08019: channel t1: restoring datafile 7
RMAN-08509: destination for restore of datafile 7:
　　/sbfs/isb01.dbf
RMAN-08019: channel t1: restoring datafile 8
RMAN-08509: destination for restore of datafile 8:
　　/sbfs/rman/rman_sc.dbf
RMAN-08023: channel t1: restored backup piece 1
RMAN-08511: piece handle=ORA8_SB_full_497711454_17_1 params=NULL
RMAN-08024: channel t1: restore complete
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: recover
RMAN-03022: compiling command: recover(1)
RMAN-03023: executing command: partial resync
RMAN-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-08060: unable to find archivelog
RMAN-08510: archivelog thread=1 sequence=12
RMAN-03022: compiling command: recover(4)
RMAN-03023: executing command: recover(4)
RMAN-08017: 
　　channel t1: starting archivelog restore to default destination
RMAN-08022: channel t1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=12
RMAN-08023: channel t1: restored backup piece 1
RMAN-08511: piece handle=ORA8_SB_arch_497711757_18_1 params=NULL
RMAN-08024: channel t1: restore complete
RMAN-08515: archivelog 
　　filename=/user/oracle/app/oracle/product/8.0.5/dbs/arch1_12.dbf 
　　thread=1 sequence=12
RMAN-08055: media recovery complete
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter database open resetlogs
RMAN-03023: executing command: sql
RMAN>


[文章录入员:nancy]

相关文章：
  • 夺取月薪之冠－Oracle认证!
  • Oracle数据安全面面观(2)
  • Oracle数据安全面面观(1)
  • Oracle10g数据库的创建
  • Oracle新技术对Linux意味着什么？
  • 在Oracle里设置访问多个SQL Server
  • 深入分析Oracle数据库日志文件
  • 在ORACLE里用存储过程定期分割表
  • 用Linux完成Oracle自动物理备份
  • SQL Server到Oracle连接服务器的实现
    •      		相关软件:
  • 利用 DBCA建立 Oracle 9i 资料库
  • Oracle 数据库DBA管理手册
  • Oracle 管理员手册
  • Oracle 官方文档CHM合集-SQL参考手册
  • Oracle WebServer 中文手册
  • Oracle 9i 数据库管理员指南
  • Oracle 9i 数据库管理实务讲座
  • Oracle 9I 入门基础(第02部分)
  • Oracle 9I 入门基础(第01部分)
  • Oracle 9i 官方教材
    • ::PCBOOKCN'ADS::


    ::Oracle::
    ACCESS
    MS SQL
    MySQL
    Oracle
    Foxpro
    PowerBuilder
    Sybase
    其它
    ::阅读排行::
    ·Oracle 常用技巧和脚本
    ·Oracle常用数据字典
    ·Oracle8 数据类型
    ·Oracle 8.1.6 for...
    ·Oracle 基本知识
    ·安装Oracle后，经常使用的修...
    ·怎样快速查出Oracle数据库中...
    ·深入分析Oracle数据库日志文...
    ·Oracle 8.0.4 for...
    ·Oracle10g数据库的创建