025考试回忆

王朝other·作者佚名  2008-05-19
窄屏简体版  字體: |||超大  

60个题, 42pass。 I passed with 47/60.

Sestion:

Ora Recovery Structure and Process 5

Ora Backup and Recvery Configration 7

Physical BK without RMAN8

Complete Rec without RMAN5

Incomp Ora Rec with Archiving3

Ora Export and import Utl3

Additional Rec Issues3

Ora Utl for Troubleshooting4

Ora RMAN Overview2

Ora Rec Catalog...6

BK using RMAN5

Restoration and Rec using RMAN4

Ora Standby DB5

1. 从Primary DB 到standby DB传送archived log时,有哪两中方法(2)

a. may confige Primary DB to send archived log automaticly;

b. may confige Standby DB to send archived log automaticly;

c. Standby DB may get from Primary DB auto when it is running in managed recovery mode;

2. alter database clone database; 该command的目的:(2or3?)

a 实现TSPITR;

b 可以transport tablespace

c 可以在export时指定参数transport_tablespace

3. archive log 可以deff的个数受那些限制

log_archive_min_sucessed

mandonary 的个数

4. logminer 的functions:

可以分析在线的log

可以把结果放在V$中

可以生成redo的sql文本

可以分析出跟执行的sql一样的语句

5. 还有一个连接target DB和catalog的语法题

6. diffrence between onlogging clause used in single DB envoriment and in standby envoriment?

7. use RMAN to restore a datafile, place all steps in correct order.

check db status

list and see all database files

newname

switch

recover

backup whole db

8. 异步i/o的使用配置, 我直接空着了

9. RC 的备份应作为备份策略考虑进去

10 RMAN 在noarchivelog模式下, 需要备份的文件

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航