小木虫 --- 500万硕博科研人员喜爱的学术科研平台
&&查看话题
请高手们帮忙分析一下，非常感谢！
新手用CASTEP计算能带时，遇到两个问题，见图。图1中算出的带结构非常平缓；图中analysis时，PDOS不能选，请教是什么原因？
La Band Structure.jpg
无标题.png
算的时候选了calculate PDOS，但是还是显示不出来
谢谢您的回帖，坐标范围是很大，请教：在哪里可以改变坐标呢？
用的是单胞模型，体系中的原子数确实很多。
研究生必备与500万研究生在线互动！
扫描下载送金币查看: 1052|回复: 5
请教高手们
论坛徽章:2
想学习关于RMAN的相关知识，可是没有专门的文档，请各位高手能否给小弟一份详细的文档。
主要是关于如何创建恢复目录、如何在数据文件丢失的情况下做恢复比较详细的。谢谢！！！！
论坛徽章:7
oracle document
论坛徽章:2
ORACLE 的文档看起来太麻烦了。也太多了，无从下手，有没有高手们总结出来的经验共享一下呀，谢谢
论坛徽章:2
论坛徽章:5
4.2.2 RMAN备份方案
RMAN也可以进行联机备份，而且备份与恢复方法将比OS备份更简单可靠。
1、连接数据库，创建测试表并插入记录
SQL*Plus: Release 8.1.6.0.0 - Production on Tue May 6 13:46:32 2003
(c) Copyright 1999 Oracle Corporation.&&All rights reserved.
SQL& connect internal/
Connected.
SQL& create table test(a int)
Table created
SQL& insert into test values(1);
1 row inserted
Commit complete
2、备份数据库表空间users
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN& connect rcvcat rman/rman@back
RMAN-06008: connected to recovery catalog database
RMAN& connect target internal/virpure
RMAN-06005: connected to target database: TEST (DBID=)
RMAN& run{
2& allocate channel c1
3& backup tag 'tsuser' format 'd:\backup\tsuser_%u_%s_%p'
5& release channel c1;
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=16 devtype=DISK
RMAN-03022: compiling command: backup
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting full datafile backupset
RMAN-08502: set_count=5 set_stamp= creation_time=16-MAY-03
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00003 name=D:\ORACLE\ORADATA\TEST\USER01.DBF
RMAN-08013: channel c1: piece 1 created
RMAN-08503: piece handle=D:\BACKUP\TSUSER_05EN93AC_5_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:01
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1
3、继续在测试表中插入记录
SQL& insert into test values(2);
1 row inserted
Commit complete
SQL& select *
& && && && && && && && & A
---------------------------------------
& && && && && && && && & 1
& && && && && && && && & 2
SQL& alter s
System altered.
1* alter s
System altered.
4、关闭数据库，模拟丢失数据文件
Database closed.
Database dismounted.
ORACLE instance shut down
C:\&del D:\ORACLE\ORADATA\TEST\USER01.DBF
5、启动数据库，检查错误
SQL& startup
ORACLE instance started.
Total System Global Area&& bytes
Fixed Size& && && && && && &&&70924 bytes
Variable Size& && && && &&& bytes
Database Buffers& && && &&& bytes
Redo Buffers& && && && && && &77824 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: 'D:\ORACLE\ORADATA\TEST\USER01.DBF'
6、先打开数据库
SQL& alter database datafile 3
Database altered.
Database altered.
7、恢复该表空间
恢复脚本可以是恢复单个数据文件
allocate channel c1
restore datafile 3;
recover datafile 3;
sql 'alter database datafile 3 online';
release channel c1;
也可以是,恢复表空间
allocate channel c1
sql 'alter database datafile 3 online';
release channel c1;
过程如下：
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN& connect rcvcat rman/rman@back
RMAN-06008: connected to recovery catalog database
RMAN& connect target internal/virpure
RMAN-06005: connected to target database: TEST (DBID=)
RMAN& run{
2& allocate channel c1
3& restore datafile 3;
4& recover datafile 3;
5& sql 'alter database datafile 3 online';
6& release channel c1;
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=13 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel c1: starting datafile backupset restore
RMAN-08502: set_count=5 set_stamp= creation_time=16-MAY-03
RMAN-08089: channel c1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00003 to D:\ORACLE\ORADATA\TEST\USER01.DBF
RMAN-08023: channel c1: restored backup piece 1
RMAN-08511: piece handle=D:\BACKUP\TSUSER_05EN93AC_5_1 tag=TSUSER params=NULL
RMAN-08024: channel c1: 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-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-03022: compiling command: recover(4)
RMAN-06050: archivelog thread 1 sequence 332 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00332.ARC
RMAN-06050: archivelog thread 1 sequence 333 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00333.ARC
RMAN-06050: archivelog thread 1 sequence 334 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00334.ARC
RMAN-03023: executing command: recover(4)
RMAN-08515: archivelog filename=D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00332.ARC thread=1 sequence=332
RMAN-08055: media recovery complete
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter database datafile 3 online
RMAN-03023: executing command: sql
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1
8、检查数据是否完整
Database altered.
SQL& select *
& && && && && && && && & A
---------------------------------------
& && && && && && && && & 1
& && && && && && && && & 2
1、RMAN也可以实现单个表空间或数据文件的恢复，恢复过程可以在mount下或open方式下，如果在open方式下恢复，可以减少down机时间
2、如果损坏的是一个数据文件，建议offline并在open方式下恢复
3、这里可以看到，RMAN进行数据文件与表空间恢复的时候，代码都比较简单，而且能保证备份与恢复的可靠性，所以建议采用RMAN的备份与恢复
论坛徽章:5
4.3.2 RMAN备份方案
RMAN备份归档模式下损坏（丢失）多个数据文件，进行整个数据库的恢复
1、连接数据库，创建测试表并插入记录
SQL*Plus: Release 8.1.6.0.0 - Production on Tue May 6 13:46:32 2003
(c) Copyright 1999 Oracle Corporation.&&All rights reserved.
SQL& connect internal/
Connected.
SQL& create table test(a int);
Table created
SQL& insert into test values(1);
1 row inserted
Commit complete
2、备份数据库
DOS下 C:&\ rman cmdfile=bakup.rcv msglog=backup.
以下是backup.log内容。
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN& #& &&&script:bakup.rcv
2& #& &&&creater:chenjiping
3& #& &&&date:5.8.2003
4& #& &&&desc:backup all database datafile in archive with rman
6& #connect database
7& connect rcvcat rman/rman@
8& connect target internal/
10& #start backup database
12& allocate channel c1
13& backup full tag 'dbfull' format 'd:\backup\full%u_%s_%p' database
14& include
15& sql 'alter system archive log current';
16& release channel c1;
RMAN-06008: connected to recovery catalog database
RMAN-06005: connected to target database: TEST (DBID=)
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=15 devtype=DISK
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting full datafile backupset
RMAN-08502: set_count=4 set_stamp= creation_time=15-MAY-03
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00002 name=D:\ORACLE\ORADATA\TEST\RBS01.DBF
RMAN-08522: input datafile fno=00001 name=D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00005 name=D:\ORACLE\ORADATA\TEST\TOOLS01.DBF
RMAN-08522: input datafile fno=00004 name=D:\ORACLE\ORADATA\TEST\TEMP01.DBF
RMAN-08522: input datafile fno=00006 name=D:\ORACLE\ORADATA\TEST\INDX01.DBF
RMAN-08522: input datafile fno=00003 name=D:\ORACLE\ORADATA\TEST\USER01.DBF
RMAN-08013: channel c1: piece 1 created
RMAN-08503: piece handle=D:\BACKUP\FULL04EN5UG0_4_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:01:16
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter system archive log current
RMAN-03023: executing command: sql
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1
Recovery Manager complete.
到这里表示备份成功。
3、继续在测试表中插入记录
SQL& insert into test values(2);
1 row inserted
Commit complete
SQL& select *
& && && && && && && && & A
---------------------------------------
& && && && && && && && & 1
& && && && && && && && & 2
SQL& alter s
System altered.
SQL& alter s
System altered.
4、关闭数据库，模拟丢失数据文件
Database closed.
Database dismounted.
ORACLE instance shut down
C:\&del D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
C:\&del D:\ORACLE\ORADATA\TEST\INDX01.DBF
C:\&del D:\ORACLE\ORADATA\TEST\TOOLS01.DBF
C:\&del D:\ORACLE\ORADATA\TEST\RBS01.DBF
5、启动数据库，检查错误
SQL& STARTUP
ORACLE instance started.
Total System Global Area&& bytes
Fixed Size& && && && && && &&&70924 bytes
Variable Size& && && && &&& bytes
Database Buffers& && && &&& bytes
Redo Buffers& && && && && && &77824 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF'
查询v$recover_file
SQL& select * from v$recover_
& &&&FILE# ONLINE&&ERROR& && && && && &&&CHANGE# TIME
---------- ------- ------------------ ---------- -----------
& && && &1 ONLINE&&FILE NOT FOUND& && && && &&&0
& && && &2 ONLINE&&FILE NOT FOUND& && && && &&&0
& && && &5 ONLINE&&FILE NOT FOUND& && && && &&&0
& && && &6 ONLINE&&FILE NOT FOUND& && && && &&&0
可以知道有四个数据文件需要恢复
6、利用RMAN进行恢复
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN& connect rcvcat rman/rman@back
RMAN-06008: connected to recovery catalog database
RMAN& connect target internal/virpure
RMAN-06005: connected to target database: TEST (DBID=)
RMAN& run{
2& allocate channel c1
5& sql 'alter database open';
6& release channel c1;
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=17 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel c1: starting datafile backupset restore
RMAN-08502: set_count=4 set_stamp= creation_time=15-MAY-03
RMAN-08089: channel c1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
RMAN-08523: restoring datafile 00002 to D:\ORACLE\ORADATA\TEST\RBS01.DBF
RMAN-08523: restoring datafile 00003 to D:\ORACLE\ORADATA\TEST\USER01.DBF
RMAN-08523: restoring datafile 00004 to D:\ORACLE\ORADATA\TEST\TEMP01.DBF
RMAN-08523: restoring datafile 00005 to D:\ORACLE\ORADATA\TEST\TOOLS01.DBF
RMAN-08523: restoring datafile 00006 to D:\ORACLE\ORADATA\TEST\INDX01.DBF
RMAN-08023: channel c1: restored backup piece 1
RMAN-08511: piece handle=D:\BACKUP\FULL04EN5UG0_4_1 tag=DBFULL params=NULL
RMAN-08024: channel c1: 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-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-03022: compiling command: recover(4)
RMAN-06050: archivelog thread 1 sequence 327 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00327.ARC
RMAN-06050: archivelog thread 1 sequence 328 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00328.ARC
RMAN-06050: archivelog thread 1 sequence 329 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00329.ARC
RMAN-06050: archivelog thread 1 sequence 330 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00330.ARC
RMAN-03023: executing command: recover(4)
RMAN-08515: archivelog filename=D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00327.ARC thread=1 sequence=327
RMAN-08515: archivelog filename=D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00328.ARC thread=1 sequence=328
RMAN-08055: media recovery complete
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter database open
RMAN-03023: executing command: sql
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1
7、检查数据库的数据（完全恢复）
SQL& select *
& && && && && && && && & A
---------------------------------------
& && && && && && && && & 1
& && && && && && && && & 2
1、只要有备份与归档存在，RMAN也可以实现数据库的完全恢复（不丢失数据）
2、同OS备份数据库恢复，适合于丢失大量数据文件，或包含系统数据文件在内的数据库的恢复
3、目标数据库在mount下进行，如果恢复成功，再打开数据库。
4、RMAN的备份与恢复命令相对比较简单并可靠，建议有条件的话，都采用RMAN进行数据库的备份。
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号UG6.0画了一段圆弧。放大之后曲线变成了一小段一小段的折线。请教高手们，怎么设置UG一下能显示好一些。_百度知道
UG6.0画了一段圆弧。放大之后曲线变成了一小段一小段的折线。请教高手们，怎么设置UG一下能显示好一些。
提问者采纳
放大后选择
视图--操作--重新生成工作视图
搞定，谢谢
提问者评价
其他类似问题
为您推荐：
其他1条回答
这个没事 属于正常 打印出来没有影响 你可以把你画的曲线复制一下 再看就不是折线了
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁各位老大 我想学习autoCAD，谁能帮我下，很多命令我都不知道，能给我吗还有快捷键一起，谢谢了！_百度知道
各位老大 我想学习autoCAD，谁能帮我下，很多命令我都不知道，能给我吗还有快捷键一起，谢谢了！
只要师兄们答得好，我愿意加分！谢谢了！
提问者采纳
把你号给我，Q上聊，有不会的可以问我。
我的QQ号是
其他类似问题
为您推荐：
其他3条回答
我是AutoCAD教师，可惜你不是安徽六安的。要不可以直接来听课。
2：先上网下载个视频教程先看一遍，没书本详细但利于速成，不要认为人家讲的基本命令自己都会其实画个线、偏移下、设个样式等这些而都是最重要的！到最后你会知道，画一图30%时间，用基本命令改图占70%，用的越熟你画的越快！
3：做笔记，相当关键，学会一个命令记一个，不用很详细。记得多了你会知道这很重要。
4：多像别人请教，有时一些简单方法你是摸不出来的，别人给你一点就透！
5：如果你是初学者，别研究什么三维作图等复杂命令，把基本的用熟你就够了。
6：有不会的命令或地方还是上网搜一下，应该可以很快解决。
7：每天两小时，一个月你就熟了，别以为CAD是什么很难的东西！
8：还是那句话，最基本命令是最总要的，用熟它！
以上是我作图一年的心得，希望对你有些帮助。^_^
七个命令让你成为CAD高手
一、绘制基本图形对象
1、几个基本常用的命令
1.1、鼠标操作
通常情况下左键代表选择功能，右键代表确定“回车”功能。如果是3D鼠标，则滚动键起缩放作用。拖拽操作是按住鼠标左键不放拖动鼠标。但是在窗口选择时从左往右拖拽和从右往左拖拽有所不同。
窗选：左图从左往右拖拽选中实线框内的物体，只选中了左边的柱子。
框选：右图从右往左拖拽选中虚线框内的物体和交叉的物体，选中了右边的柱子和梁。
1.2、Esc取消操作：当正在执行命令的过程中，敲击Esc键可以中止命令的操作。
1.3、撤销放弃操作：autocad支持无限次撤销操作，单击撤销按钮 或输入u,回车。
1.4、AutoCAD中，空格键和鼠标右键等同回车键，都是确认命令，经常用到。
1.5、经常查看命令区域的提示，...
autocad的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁查看: 1054|回复: 5
请教高手们
论坛徽章:2
想学习关于RMAN的相关知识，可是没有专门的文档，请各位高手能否给小弟一份详细的文档。
主要是关于如何创建恢复目录、如何在数据文件丢失的情况下做恢复比较详细的。谢谢！！！！
论坛徽章:7
oracle document
论坛徽章:2
ORACLE 的文档看起来太麻烦了。也太多了，无从下手，有没有高手们总结出来的经验共享一下呀，谢谢
论坛徽章:2
论坛徽章:5
4.2.2 RMAN备份方案
RMAN也可以进行联机备份，而且备份与恢复方法将比OS备份更简单可靠。
1、连接数据库，创建测试表并插入记录
SQL*Plus: Release 8.1.6.0.0 - Production on Tue May 6 13:46:32 2003
(c) Copyright 1999 Oracle Corporation.&&All rights reserved.
SQL& connect internal/
Connected.
SQL& create table test(a int)
Table created
SQL& insert into test values(1);
1 row inserted
Commit complete
2、备份数据库表空间users
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN& connect rcvcat rman/rman@back
RMAN-06008: connected to recovery catalog database
RMAN& connect target internal/virpure
RMAN-06005: connected to target database: TEST (DBID=)
RMAN& run{
2& allocate channel c1
3& backup tag 'tsuser' format 'd:\backup\tsuser_%u_%s_%p'
5& release channel c1;
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=16 devtype=DISK
RMAN-03022: compiling command: backup
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting full datafile backupset
RMAN-08502: set_count=5 set_stamp= creation_time=16-MAY-03
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00003 name=D:\ORACLE\ORADATA\TEST\USER01.DBF
RMAN-08013: channel c1: piece 1 created
RMAN-08503: piece handle=D:\BACKUP\TSUSER_05EN93AC_5_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:01
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1
3、继续在测试表中插入记录
SQL& insert into test values(2);
1 row inserted
Commit complete
SQL& select *
& && && && && && && && & A
---------------------------------------
& && && && && && && && & 1
& && && && && && && && & 2
SQL& alter s
System altered.
1* alter s
System altered.
4、关闭数据库，模拟丢失数据文件
Database closed.
Database dismounted.
ORACLE instance shut down
C:\&del D:\ORACLE\ORADATA\TEST\USER01.DBF
5、启动数据库，检查错误
SQL& startup
ORACLE instance started.
Total System Global Area&& bytes
Fixed Size& && && && && && &&&70924 bytes
Variable Size& && && && &&& bytes
Database Buffers& && && &&& bytes
Redo Buffers& && && && && && &77824 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: 'D:\ORACLE\ORADATA\TEST\USER01.DBF'
6、先打开数据库
SQL& alter database datafile 3
Database altered.
Database altered.
7、恢复该表空间
恢复脚本可以是恢复单个数据文件
allocate channel c1
restore datafile 3;
recover datafile 3;
sql 'alter database datafile 3 online';
release channel c1;
也可以是,恢复表空间
allocate channel c1
sql 'alter database datafile 3 online';
release channel c1;
过程如下：
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN& connect rcvcat rman/rman@back
RMAN-06008: connected to recovery catalog database
RMAN& connect target internal/virpure
RMAN-06005: connected to target database: TEST (DBID=)
RMAN& run{
2& allocate channel c1
3& restore datafile 3;
4& recover datafile 3;
5& sql 'alter database datafile 3 online';
6& release channel c1;
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=13 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel c1: starting datafile backupset restore
RMAN-08502: set_count=5 set_stamp= creation_time=16-MAY-03
RMAN-08089: channel c1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00003 to D:\ORACLE\ORADATA\TEST\USER01.DBF
RMAN-08023: channel c1: restored backup piece 1
RMAN-08511: piece handle=D:\BACKUP\TSUSER_05EN93AC_5_1 tag=TSUSER params=NULL
RMAN-08024: channel c1: 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-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-03022: compiling command: recover(4)
RMAN-06050: archivelog thread 1 sequence 332 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00332.ARC
RMAN-06050: archivelog thread 1 sequence 333 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00333.ARC
RMAN-06050: archivelog thread 1 sequence 334 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00334.ARC
RMAN-03023: executing command: recover(4)
RMAN-08515: archivelog filename=D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00332.ARC thread=1 sequence=332
RMAN-08055: media recovery complete
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter database datafile 3 online
RMAN-03023: executing command: sql
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1
8、检查数据是否完整
Database altered.
SQL& select *
& && && && && && && && & A
---------------------------------------
& && && && && && && && & 1
& && && && && && && && & 2
1、RMAN也可以实现单个表空间或数据文件的恢复，恢复过程可以在mount下或open方式下，如果在open方式下恢复，可以减少down机时间
2、如果损坏的是一个数据文件，建议offline并在open方式下恢复
3、这里可以看到，RMAN进行数据文件与表空间恢复的时候，代码都比较简单，而且能保证备份与恢复的可靠性，所以建议采用RMAN的备份与恢复
论坛徽章:5
4.3.2 RMAN备份方案
RMAN备份归档模式下损坏（丢失）多个数据文件，进行整个数据库的恢复
1、连接数据库，创建测试表并插入记录
SQL*Plus: Release 8.1.6.0.0 - Production on Tue May 6 13:46:32 2003
(c) Copyright 1999 Oracle Corporation.&&All rights reserved.
SQL& connect internal/
Connected.
SQL& create table test(a int);
Table created
SQL& insert into test values(1);
1 row inserted
Commit complete
2、备份数据库
DOS下 C:&\ rman cmdfile=bakup.rcv msglog=backup.
以下是backup.log内容。
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN& #& &&&script:bakup.rcv
2& #& &&&creater:chenjiping
3& #& &&&date:5.8.2003
4& #& &&&desc:backup all database datafile in archive with rman
6& #connect database
7& connect rcvcat rman/rman@
8& connect target internal/
10& #start backup database
12& allocate channel c1
13& backup full tag 'dbfull' format 'd:\backup\full%u_%s_%p' database
14& include
15& sql 'alter system archive log current';
16& release channel c1;
RMAN-06008: connected to recovery catalog database
RMAN-06005: connected to target database: TEST (DBID=)
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=15 devtype=DISK
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting full datafile backupset
RMAN-08502: set_count=4 set_stamp= creation_time=15-MAY-03
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00002 name=D:\ORACLE\ORADATA\TEST\RBS01.DBF
RMAN-08522: input datafile fno=00001 name=D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00005 name=D:\ORACLE\ORADATA\TEST\TOOLS01.DBF
RMAN-08522: input datafile fno=00004 name=D:\ORACLE\ORADATA\TEST\TEMP01.DBF
RMAN-08522: input datafile fno=00006 name=D:\ORACLE\ORADATA\TEST\INDX01.DBF
RMAN-08522: input datafile fno=00003 name=D:\ORACLE\ORADATA\TEST\USER01.DBF
RMAN-08013: channel c1: piece 1 created
RMAN-08503: piece handle=D:\BACKUP\FULL04EN5UG0_4_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:01:16
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter system archive log current
RMAN-03023: executing command: sql
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1
Recovery Manager complete.
到这里表示备份成功。
3、继续在测试表中插入记录
SQL& insert into test values(2);
1 row inserted
Commit complete
SQL& select *
& && && && && && && && & A
---------------------------------------
& && && && && && && && & 1
& && && && && && && && & 2
SQL& alter s
System altered.
SQL& alter s
System altered.
4、关闭数据库，模拟丢失数据文件
Database closed.
Database dismounted.
ORACLE instance shut down
C:\&del D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
C:\&del D:\ORACLE\ORADATA\TEST\INDX01.DBF
C:\&del D:\ORACLE\ORADATA\TEST\TOOLS01.DBF
C:\&del D:\ORACLE\ORADATA\TEST\RBS01.DBF
5、启动数据库，检查错误
SQL& STARTUP
ORACLE instance started.
Total System Global Area&& bytes
Fixed Size& && && && && && &&&70924 bytes
Variable Size& && && && &&& bytes
Database Buffers& && && &&& bytes
Redo Buffers& && && && && && &77824 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF'
查询v$recover_file
SQL& select * from v$recover_
& &&&FILE# ONLINE&&ERROR& && && && && &&&CHANGE# TIME
---------- ------- ------------------ ---------- -----------
& && && &1 ONLINE&&FILE NOT FOUND& && && && &&&0
& && && &2 ONLINE&&FILE NOT FOUND& && && && &&&0
& && && &5 ONLINE&&FILE NOT FOUND& && && && &&&0
& && && &6 ONLINE&&FILE NOT FOUND& && && && &&&0
可以知道有四个数据文件需要恢复
6、利用RMAN进行恢复
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN& connect rcvcat rman/rman@back
RMAN-06008: connected to recovery catalog database
RMAN& connect target internal/virpure
RMAN-06005: connected to target database: TEST (DBID=)
RMAN& run{
2& allocate channel c1
5& sql 'alter database open';
6& release channel c1;
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=17 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel c1: starting datafile backupset restore
RMAN-08502: set_count=4 set_stamp= creation_time=15-MAY-03
RMAN-08089: channel c1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
RMAN-08523: restoring datafile 00002 to D:\ORACLE\ORADATA\TEST\RBS01.DBF
RMAN-08523: restoring datafile 00003 to D:\ORACLE\ORADATA\TEST\USER01.DBF
RMAN-08523: restoring datafile 00004 to D:\ORACLE\ORADATA\TEST\TEMP01.DBF
RMAN-08523: restoring datafile 00005 to D:\ORACLE\ORADATA\TEST\TOOLS01.DBF
RMAN-08523: restoring datafile 00006 to D:\ORACLE\ORADATA\TEST\INDX01.DBF
RMAN-08023: channel c1: restored backup piece 1
RMAN-08511: piece handle=D:\BACKUP\FULL04EN5UG0_4_1 tag=DBFULL params=NULL
RMAN-08024: channel c1: 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-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-03022: compiling command: recover(4)
RMAN-06050: archivelog thread 1 sequence 327 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00327.ARC
RMAN-06050: archivelog thread 1 sequence 328 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00328.ARC
RMAN-06050: archivelog thread 1 sequence 329 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00329.ARC
RMAN-06050: archivelog thread 1 sequence 330 is already on disk as file D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00330.ARC
RMAN-03023: executing command: recover(4)
RMAN-08515: archivelog filename=D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00327.ARC thread=1 sequence=327
RMAN-08515: archivelog filename=D:\ORACLE\ORADATA\TEST\ARCHIVE\TESTT001S00328.ARC thread=1 sequence=328
RMAN-08055: media recovery complete
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter database open
RMAN-03023: executing command: sql
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1
7、检查数据库的数据（完全恢复）
SQL& select *
& && && && && && && && & A
---------------------------------------
& && && && && && && && & 1
& && && && && && && && & 2
1、只要有备份与归档存在，RMAN也可以实现数据库的完全恢复（不丢失数据）
2、同OS备份数据库恢复，适合于丢失大量数据文件，或包含系统数据文件在内的数据库的恢复
3、目标数据库在mount下进行，如果恢复成功，再打开数据库。
4、RMAN的备份与恢复命令相对比较简单并可靠，建议有条件的话，都采用RMAN进行数据库的备份。
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号