2,668
社区成员
发帖
与我相关
我的任务
分享100分求助OCA题目解答(十二)。
One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator,
asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows? Choose two.
A. Use a flashback query to retrieve the rows that were deleted
B. Use convential incremental export and then import the affected object
C.Shutdown the database in NORMAL mode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.Use Tablespace Point in Time Recovery (TSPITR) method to recover the table and the data
F.Use Oracle DataPumpt with flashback_time option to entable flashback export and then import the affected object.
【答案是B、E。A为什么不行，B是什么含义，export和import也能恢复数据？，Tablespace Point in Time Recovery是什么，跟闪回有什么不同？D是什么含义？】
asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows? Choose two.
A. Use a flashback query to retrieve the rows that were deleted
B. Use convential incremental export and then import the affected object
C.Shutdown the database in NORMAL mode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.Use Tablespace Point in Time Recovery (TSPITR) method to recover the table and the data
F.Use Oracle DataPumpt with flashback_time option to entable flashback export and then import the affected object.
【答案是B、E。A为什么不行，B是什么含义，export和import也能恢复数据？，Tablespace Point in Time Recovery是什么，跟闪回有什么不同？D是什么含义？】
...全文
请发表友善的回复…
发表回复
suphy23 2008-11-27
- 打赏
- 举报
楼上的回答的真好，学习了~~~
xiaoxiao1984 2008-10-16
- 打赏
- 举报
[Quote=引用楼主 Xviewee 的帖子:]
One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator,
asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows? Choose two.
A. Use a flashback query to retrieve the rows that were deleted
B. Use convential incremental export and then import the affected object
C.Shutdown the database in NORMAL mode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.Use Tablespace Point in Time Recovery (TSPITR) method to recover the table and the data
F.Use Oracle DataPumpt with flashback_time option to entable flashback export and then import the affected object
[/Quote]
a, 损失了system/undo tablespace的数据不能用 falshback恢复
b, 使用传统的增量导出备份可以进行恢复
c，重启了数据库，不满足题目要求的不影响其他用户的要求
d, DBMS_META不存在，存在DBMS_METADATA
e, 使用表空间基于时间点可以进行恢复
f，DataPumpt?? （datapump数据泵，猜测楼主打错了）使用flashback_SCN或者flashback_time把数据导出进行恢复，同样不适用于system/undo tablespace，例如，system tablespace中对象大都属于SYS用户，而SYS用户是不能够使用数据泵进行Flashback恢复的，相关的ORA错误有ORA-8185，ORA-39135等。
One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator,
asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows? Choose two.
A. Use a flashback query to retrieve the rows that were deleted
B. Use convential incremental export and then import the affected object
C.Shutdown the database in NORMAL mode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.Use Tablespace Point in Time Recovery (TSPITR) method to recover the table and the data
F.Use Oracle DataPumpt with flashback_time option to entable flashback export and then import the affected object
[/Quote]
a, 损失了system/undo tablespace的数据不能用 falshback恢复
b, 使用传统的增量导出备份可以进行恢复
c，重启了数据库，不满足题目要求的不影响其他用户的要求
d, DBMS_META不存在，存在DBMS_METADATA
e, 使用表空间基于时间点可以进行恢复
f，DataPumpt?? （datapump数据泵，猜测楼主打错了）使用flashback_SCN或者flashback_time把数据导出进行恢复，同样不适用于system/undo tablespace，例如，system tablespace中对象大都属于SYS用户，而SYS用户是不能够使用数据泵进行Flashback恢复的，相关的ORA错误有ORA-8185，ORA-39135等。
IdealStudio 2008-10-15
- 打赏
- 举报
4楼的回答不错,欣赏啊
wiler 2008-10-14
- 打赏
- 举报
csdn的反应怎么这么慢了，害我连续两次回复
wiler 2008-10-14
- 打赏
- 举报
Tablespace Point in Time Recovery 是表空间时间点恢复
通过归档数据库的归档日志恢复
通过归档数据库的归档日志恢复
wiler 2008-10-14
- 打赏
- 举报
Tablespace Point in Time Recovery 是表空间时间点恢复
通过归档数据库的归档日志恢复
通过归档数据库的归档日志恢复
oracledbalgtu 2008-10-13
- 打赏
- 举报
a.不一定能够恢复,取决于删除数据量/undo大小的限制.如果删除数据较少,且undo没有被重复利用,就可以把数据查出来,再insert到数据表中.所以此方法有恢复的可能而已.
b.用exp的导出恢复,也未必可以,因为最后一次exp和delete数据之间的数据无法恢复,除非最后一次exp后,删除表的数据没有变化.
c.在此不可能恢复数据.
d.在此无法实现数据恢复.
e.这是通用的数据意外删除后的恢复方法,完全可以.
f.在此无法实现数据恢复.
A. Use a flashback query to retrieve the rows that were deleted
B. Use convential incremental export and then import the affected object
C.Shutdown the database in NORMAL mode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.Use Tablespace Point in Time Recovery (TSPITR) method to recover the table and the data
F.Use Oracle DataPumpt with flashback_time option to entable flashback export and then import the affected object.
[Quote=引用楼主 Xviewee 的帖子:]
One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator,
asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows? Choose two.
A. Use a flashback query to retrieve the rows that were deleted
…
[/Quote]
b.用exp的导出恢复,也未必可以,因为最后一次exp和delete数据之间的数据无法恢复,除非最后一次exp后,删除表的数据没有变化.
c.在此不可能恢复数据.
d.在此无法实现数据恢复.
e.这是通用的数据意外删除后的恢复方法,完全可以.
f.在此无法实现数据恢复.
A. Use a flashback query to retrieve the rows that were deleted
B. Use convential incremental export and then import the affected object
C.Shutdown the database in NORMAL mode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.Use Tablespace Point in Time Recovery (TSPITR) method to recover the table and the data
F.Use Oracle DataPumpt with flashback_time option to entable flashback export and then import the affected object.
[Quote=引用楼主 Xviewee 的帖子:]
One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator,
asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows? Choose two.
A. Use a flashback query to retrieve the rows that were deleted
…
[/Quote]
客家族_Shark曾_小凡仙 2008-10-13
- 打赏
- 举报
【答案是B、E。A为什么不行，B是什么含义，export和import也能恢复数据？，Tablespace Point in Time Recovery是什么，跟闪回有什么不同？D是什么含义？】
B 是逻辑导出是增量导出
A 只是查讯出来
D Use DBMS_META package to reconstruct the object using undo segments 这句就知道恢复是对象而不是数据
Tablespace Point in Time Recovery 看英文就明白是表空间时间点恢复
B 是逻辑导出是增量导出
A 只是查讯出来
D Use DBMS_META package to reconstruct the object using undo segments 这句就知道恢复是对象而不是数据
Tablespace Point in Time Recovery 看英文就明白是表空间时间点恢复
cumtdai 2008-10-07
- 打赏
- 举报
oca考试都是英文的吗？
BlueskyWide 2008-10-06
- 打赏
- 举报
试着回答：
A. Use a flashback query to retrieve the rows that were deleted
-- drop user test和drop table table_test可以使用flash back 技术，但题目中只是删除表中的所有行，并提交，表并未删除，所以不适用。
B. Use convential（楼主可能写错了，是conventional） incremental export and then import the affected object
--exp和imp是常用的导入和导出技术，当然能恢复。但恢复不了从exp到删除之间所做的工作。
C.Shutdown the database in NORMAL mode and restart the database instance
--误出错后，这样做大都是在销毁证据。
D.Use DBMS_META package to reconstruct the object using undo segments
--这个没听说过。
E.Use Tablespace Point in Time Recovery (TSPITR) method to recover the table and the data
-- TSPITR这种模式实际上是对表空间使用不同的时间点进行备份，没用过，应该可以。
F.Use Oracle DataPumpt with flashback_time option to entable flashback export and then import the affected object.
--DataPumpt,没听说过。
A. Use a flashback query to retrieve the rows that were deleted
-- drop user test和drop table table_test可以使用flash back 技术，但题目中只是删除表中的所有行，并提交，表并未删除，所以不适用。
B. Use convential（楼主可能写错了，是conventional） incremental export and then import the affected object
--exp和imp是常用的导入和导出技术，当然能恢复。但恢复不了从exp到删除之间所做的工作。
C.Shutdown the database in NORMAL mode and restart the database instance
--误出错后，这样做大都是在销毁证据。
D.Use DBMS_META package to reconstruct the object using undo segments
--这个没听说过。
E.Use Tablespace Point in Time Recovery (TSPITR) method to recover the table and the data
-- TSPITR这种模式实际上是对表空间使用不同的时间点进行备份，没用过，应该可以。
F.Use Oracle DataPumpt with flashback_time option to entable flashback export and then import the affected object.
--DataPumpt,没听说过。
dawugui 2008-10-05
- 打赏
- 举报
英文的?我帮顶!
vc555 2008-10-05
- 打赏
- 举报
1.B就是用以前的逻辑导出来IMP该表数据，这个可行。exp，imp当然能恢复数据了。
2.Tablespace Point in Time Recovery：表空间时间点闪回。这个与普通flashback的区别就在于flashback是在指定的表空间上进行。
3.D选项。没听说过oracle有dbms_meta包，只知道有dbms_metadata包和dbms_flashback包。
4.A不行。因为flashback query只是你把这些数据从undo段查询出来而已，并没有物理地插入到表中。别的会话看的还是空表。
2.Tablespace Point in Time Recovery：表空间时间点闪回。这个与普通flashback的区别就在于flashback是在指定的表空间上进行。
3.D选项。没听说过oracle有dbms_meta包，只知道有dbms_metadata包和dbms_flashback包。
4.A不行。因为flashback query只是你把这些数据从undo段查询出来而已，并没有物理地插入到表中。别的会话看的还是空表。
無名VF 2008-10-05
- 打赏
- 举报
不懂 帮顶 学习.....
