053(七十二）

最新推荐文章于 2025-08-22 11:10:38 发布

转载最新推荐文章于 2025-08-22 11:10:38 发布 · 68 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/huanhuanang/p/5472618.html

文章标签：

#数据库

本文详细介绍了在Oracle数据库环境中进行数据库复制和故障恢复的关键步骤。包括如何使用RMAN命令进行活动数据库复制到目标数据库，以及如何通过重置数据库到前一次快照来恢复数据库。同时，文章还探讨了如何确定表空间是否完全独立于时间点恢复，并提供了完整的灾难恢复流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

356、

356.Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?
A. Set oracle_sid=orcl 
rman target=sys/robert auxname=sys/Robert@orcl2 
create duplicate target database to neworcl from active database nofilenamecheck spfile 
set control_files 'c:\oracle\oradata\neworcl\control01.ctl','c:\oracle\oradata\neworcl\control02.ctl' 
set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' 
set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
B. Set oracle_sid=orcl 
rman target=sys/robert auxname=sys/Robert@orcl2 
duplicate target database nofilenamecheck spfile 
set control_files 'c:\oracle\oradata\neworcl\control01.ctl', 'c:\oracle\oradata\neworcl\control02.ctl' 
set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' 
set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
C. Set oracle_sid=orcl 
rman target=sys/robert auxname=sys/Robert@orcl2 
duplicate target database to neworcl nofilenamecheck spfile 
set control_files 'c:\oracle\oradata\neworcl\control01.ctl','c:\oracle\oradata\neworcl\control02.ctl' 
set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' 
set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
D. Set oracle_sid=orcl 
rman target=sys/robert auxname=sys/Robert 
duplicate target database to neworcl from active database nofilenamecheck spfile 
set control_files 'c:\oracle\oradata\neworcl\control01.ctl','c:\oracle\oradata\neworcl\control02.ctl' 
set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' 
set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
E. Set oracle_sid=orcl 
rman target=sys/robert auxname=sys/Robert@orcl2 
duplicate target database to neworcl from active database nofilenamecheck spfile 
set control_files 'c:\oracle\oradata\neworcl\control01.ctl','c:\oracle\oradata\neworcl\control02.ctl' 
set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' 
set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';

357、

357.How many database instances are used during a database-duplication process?
A. One
B. Two
C. Three
D. Four
E. Five

358、

358.What command is used to reset a database to a previous incarnation?
A. reset incarnation
B. incarnation reset
C. reset database to incarnation
D. reset database incarnation
E. reset databse incarnation number

359、

359.What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?
A. TS_CHECK
B. TPITR_CHECK
C. TS_PITR_CHECK
D. CHECK_TSPITR
E. PITR_TS_CHECK

360、

360.When performing a full database disaster recovery with RMAN, in what order would you execute these steps?
A. Restore the control file from autobackups.
B. Run the RMAN restore and recover command.
C. Restore the database spfile from autobackups.
D. Make the RMAN backup set pieces available.
E. Open the database with the alter database open resetlogs command.
F. Open the database with the alter database open command.
G. a, b, c, d, e, f
H. c, d, a, b, f
I. d, c, a, b, f
J. d, b, d, c, e
K. d, c, a, b, e