OCP-1Z0-053-V12.02-575题_you have lost all your system tablespace datafiles-CSDN博客

本文链接：https://blog.csdn.net/rlhua/article/details/14863713

本文介绍了一种在丢失所有数据库控制文件的情况下使用trace文件进行恢复的方法。通过使用NORESETLOGS版本的CREATE CONTROLFILE命令，可以有效地创建新的控制文件并避免不必要的日志重置。

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

575.You have lost all your database control files. To recover them, you are going to use the results of the

alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.

Which of the following is true regarding your recovery?

A. You will need to open the database with the resetlogs command.

B. All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

C. You will use the resetlogs version of the create controlfile command.

D. You will use the noresetlogs version of the create controlfile command.

E. You will use the trace file to create a backup control file, and then you will recover the database with the

recover database using backup controlfile command

Answer: D

答案解析：

答案解析：http://docs.oracle.com/cd/E11882_01/server.112/e25494/omf.htm#ADMIN11509

CREATE CONTROLFILE Using NORESETLOGS Keyword: Example

The following CREATE CONTROLFILE statement is generated by an ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement for a database with Oracle managed data files and redo log files:

CREATE CONTROLFILE

DATABASE sample

LOGFILE

GROUP 1 ('/u01/oradata/SAMPLE/onlinelog/o1_mf_1_o220rtt9_.log',

'/u02/oradata/SAMPLE/onlinelog/o1_mf_1_v2o0b2i3_.log')

SIZE 100M,

GROUP 2 ('/u01/oradata/SAMPLE/onlinelog/o1_mf_2_p22056iw_.log',

'/u02/oradata/SAMPLE/onlinelog/o1_mf_2_p02rcyg3_.log')

SIZE 100M

NORESETLOGS

DATAFILE '/u01/oradata/SAMPLE/datafile/o1_mf_system_xu34ybm2_.dbf'

SIZE 100M,

'/u01/oradata/SAMPLE/datafile/o1_mf_sysaux_aawbmz51_.dbf'

SIZE 100M,

'/u01/oradata/SAMPLE/datafile/o1_mf_sys_undo_apqbmz51_.dbf'

SIZE 100M

MAXLOGFILES 5

MAXLOGHISTORY 100

MAXDATAFILES 10

MAXINSTANCES 2

ARCHIVELOG;