OCP-1Z0-053-V12.02-578题

ocp-178 QUESTION NO: 178 Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the f 阅读详情

578.Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the

SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following

steps to recover your database:

Which is the correct order of these steps in this case?

A. Restore the three database datafiles that were lost.

B. Issue the Startup Mount command to mount the database.

C. Issue the alter database open command.

D. Issue the alter database open resetlogs command.

E. Recover the database using the recover database command.

F. Recover the datafiles with the recover datafile command.

G. Take the datafiles offline.

H. a, b, e, c

I. b, e, d

J. a, b, d, c

K. b, g, c, f

L. a, b, d, f

Answer: A 

答案解析:

参考:http://blog.csdn.net/rlhua/article/details/12622415

如果某个数据文件丢失或损坏,且该文件属于SYSTEM或UNDO表空间,请执行以下任务:
1. 实例可能会也可能不会自动关闭。如果未自动关闭,请使用SHUTDOWN ABORT关闭实例。
2. 装载数据库。
3. 还原并恢复缺失的数据文件。
4. 打开数据库。


题中数据库已关闭,只需要mount数据库,然后还原和恢复,最后打开数据库即可。

题中应B后A


OCP-1Z0-053-V12.02-575 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 log 阅读详情

相关推荐

OCP-1Z0-053-V12.02-179

179.You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database? 1. Take the datafiles that were l

一抹曦阳-Oracle 5949

ocp-175

QUESTION NO: 175 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 on

jiayue's BLOG 1242

OCP-1Z0-053-V12.02-577

577.What methods are available to recover lost control files? (Choose all that apply.) A. Backup control file. B. Emergency control file. C. The create controlfile command. D. The restore controlf

一抹曦阳-Oracle 6925

oracle11g OCP 认证 1Z0-053考试笔记6

502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In th

wlbzy的专栏 5371

ocp-177

QUESTION NO: 177 What methods are available to recover lost control files? (Choose all that apply.)A. Backup control file. B. Emergency control file. C. The create controlfile command. D. The rest

jiayue's BLOG 1296

QUESTION 169 A database has three online redo log groups with one member each. A redo log member wit

QUESTION 169 A database has three online redo log groups with one member each. A redo log member with the status ACTIVE is damaged while the database is running. What is the first step you should t

EVISWANG的博客 975

123.You used the IMMEDIATE option to shut down your database instance. Consider the steps that may o

123.You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occur when a database instance is started and database is opened:

dwj19830118的专栏 812

OCP-1Z0-053-V13.02-709

709. A database has three online redo log groups wi th one member each. A redo log member with the status ACTIVE is damages while the database is running. What is the first step you should take to s

一抹曦阳-Oracle 7959

OCP-1Z0-053-V13.02-684

684. Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.   You are informed that some important tables in  the BILLING tablesp

一抹曦阳-Oracle 9042

OCP-1Z0-053-V12.02-566

566.You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation? A.

一抹曦阳-Oracle 7710

OCP-1Z0-053-V13.02-573

573.Upon starting your database, you receive the following error: SQL> startup ORACLE instance started. Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 byt

一抹曦阳-Oracle 7631

OCP-1Z0-053-V13.02-694

694. As part of archiving the historical data, you want to trans fer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and

一抹曦阳-Oracle 7859

OCP-1Z0-053-V13.02-507

507.Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup fo

一抹曦阳-Oracle 6985

74.The database is running in ARCHIVELOG mode. Examine the initialization parameters and their value

74.The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

dwj19830118的专栏 1951

OCP-1Z0-053-V13.02-703

703. Given below are RMAN commands to enable ba ckup optimization and set  the retention policy:   The USERS tablespace has never been backed up. Y ou take the USERS tablespace offline on Monday. V

一抹曦阳-Oracle 1万+

用Unsloth微调DeepSeek-R1做医学推理:低成本高效训练实战

医学大模型并非简单问答工具,其核心价值在于构建可解释、可追溯的临床决策链路——即从症状、体征到检查、鉴别、确诊的完整Chain-of-Thought推理能力。这一能力依赖高质量的推理路径监督信号与适配医疗语义的微调方法。DeepSeek-R1凭借强化的长程逻辑建模能力成为理想基座,而Unsloth通过4-bit QLoRA与内核级显存优化,使8B级模型可在单张RTX 4090上完成端到端微调,突破消费级硬件限制。结合medical-chain-of-thought数据集提供的专家级推理标注,该方案真正实现‘

congsong2560的博客 536

OCP-1Z0-053-V13.02-693

693. Which two statements are true about an image copy backup? (Choose two.) A. It may only be taken to disk. B. It will contain only the used blocks. C. It will contain all used and unused blocks.

一抹曦阳-Oracle 5622

053 86/581 - restore/recover datafile

目: 86.Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to ...

文档搬运工 458
上一篇: OCP-1Z0-053-V12.02-646题
下一篇: OCP-1Z0-053-V12.02-574题
Riveore
博客等级 码龄19年 1801粉丝 1432原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值