RSS
热门关键字： 　数据挖掘 　数据仓库 　人工智能 　数据挖掘导论 　搜索引擎
首页>相关研究方向>数据仓库>Oracle数据库>

Oracle Rman/tivoli
Visited times , Welcome to Data Mining Forum & Data Mining Expert

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> 数据挖掘研究院

（责任编辑:西门吹风）

数据挖掘研究院

最全面的服务器导购资讯，形成全方位的服务器导购平台
【
[数据挖掘专家] [数据挖掘研究院] [数据挖掘论坛] [数据挖掘实验室]
上一篇：Oracle PL/SQL游标的学习
下一篇：Oracle SQL 内置函数的使用方法及结果
最新评论共有 0 位网友发表了评论 , 查看所有评论
发表评论( 不能超过250字，需审核，请自觉遵守互联网相关政策法规。 )
匿名?
数据挖掘网站导航 数据挖掘论坛导航
  • 数据挖掘工具
  • 数据挖掘论坛
  • DataCruncher - Cognos
  • MineSet - MathSoft
  • Intelligent Miner - GainSmarts
  • Sqlserver - SAS - Clementine
  • CART - Weka - WizSoft
  • NeuroShell - ModelQuest
  • data mining tools - Darwin
  • 数据挖掘交友
  • 数据挖掘博客
    		•
  • 数据挖掘工具
  • 数据挖掘资源
  • 数据挖掘技术算法
  • 数据挖掘相关期刊、会议
  • 研究院联盟合作专区
  • 数据挖掘基础与相关技术
  • 数据挖掘厂商与就业
  • 数据挖掘研究者乐园
  • 知名厂商数据挖掘工具资料
  • 国内数据挖掘实验室
  • Foreign Data Mining Lab
    		•
    热点关注
  • IBM放出“毒蛇”欲一统数据库市场
  • Oracle Delivers New Release of PeopleToo
  • Oracle: Separating Numbers and Letters
  • DBA from Crisis to Confidence
  • [Oracle]创建索引对SQL语句执行的影响
  • Oracle9i数据挖掘介绍
  • Oracle TimesTen In-Memory Database
  • Oracle 10G数据库的特性简介
  • Oracle RAC Administration - Part 13: Cac
  • 用Oracle分层管理器实现有效存储数据
    		•
    论坛最新话题
  • Foundations of Statistical Natural Langu
  • Game Theory meet Data Mining: A Recent P
  • System Building: How does it help or hin
  • 数据挖掘与Clementine培训
  • 新手报到
  • 求 SASEM 客户流失预测分析
  • 数据挖掘工程师/搜索研究院—北京——无线
  • 数据挖掘入门介绍（如何着手数据挖掘）
  • Information Overload Survey Results
  • The INEX 2005 Workshop on Element Retrie
    • 相关资讯
  • Oracle 10g Backup Guide: A Small County
  • Oracle 10G数据库的特性简介
  • Oracle TimesTen In-Memory Database
  • Oracle9i数据挖掘介绍
  • Low–Cost, High–Performance Data Securi
  • Oracle DML Error Logging
  • ORACLE问题，每天10问（十一）
  • 浅析Oracle和SqlServer存储过程的调试、出
  • Oracle数据的异地自动备份
  • Oracle数据库在一台机器配置两个listener
    		•
    数据挖掘实验室资料
  • 数据挖掘博客地址
  • 数据挖掘实验室网站地址
  • Prepare for Medicare audits by using dat
  • 注册成为SAS用户与爱好者俱乐部会员
  • 水南梅
  • 明日烟
  • 新人报道
  • 下载
  • 厦门服务器托管,450元/月—0592-5177319 高
  • 买空间送域名--0592-5177319 高静
    • 关于我们 - 联系方式 - 版权申明 - 友情链接 - 交流空间 - 同徽科技
    增值电信业务经营许可证编号：皖B2-20040042 文网文编号：[2005]027号