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

最新推荐文章于 2018-12-10 21:26:28 发布

最新推荐文章于 2018-12-10 21:26:28 发布 · 131 阅读

文章标签：

#数据库

本文介绍了当数据库中丢失临时数据文件时的正确恢复步骤。可以通过使用ALTER TABLESPACE命令重新创建临时文件，而不会影响数据库的正常运行。此外，通过实际操作验证，在某些情况下，即使不进行人为干预，数据库也可能自动恢复丢失的临时文件。

572.What is the proper procedure to recover a lost tempfile?

A. Restore the backup copy of the tempfile from the backup media.

B. Re-create the tempfile with the create tempfile command.

C. Copy an existing tempfile from another database.

D. Re-create the tempfile with the create tablespace command.

E. Re-create the tempfile with the alter tablespace command.

Answer: E

临时数据文件丢失，并不会影响到数据库的正常运行。

可以使用altertablespacetempaddtempfile'/u01/app/oracle/oradata/test0924/temp01.dbf'size10m

这样的语句来重新创建临时数据文件。

在我的11.2.0.3环境里，我删除/u01/app/oracle/oradata/test0924/temp01.dbf，之后重新启动数据库，数据库又自动恢复了temp01.dbf。

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

iteye_11788

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

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

wlbzy的专栏

11-27

5309

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

Oracle 11G OCP 1Z0-053 572

cmff98425的博客

11-04

（572）What is the proper procedure to recover a lost tempfile? A. Restore the backup copy of the tempfile from ...

参与评论您还未登录，请先登录后发表或查看评论

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

一抹曦阳-Oracle

11-01

7662

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 ocp 1Z0 053 Q563(archive-log destination)

congsong2560的博客

04-03

147

563.How many individual archive-log destination directories are supported by Oracle Database11g? A. 7 B. 1 C. 1...

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

一抹曦阳-Oracle

10-30

3935

513.What RMAN command is used to execute a tablespace point-in-time recovery? A. recover B. duplicate C. restore D. copy E. None of the above Answer: A 答案解析：参考：http://blog.csdn.net/rlhua/arti

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

一抹曦阳-Oracle

11-01

5510

564.Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the st

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

一抹曦阳-Oracle

02-24

1万+

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 11G OCP 1Z0-053 563

cmff98425的博客

11-03

113

（563）How many individual archive-log destination directories are supported by Oracle Database11g? A. 7 B...

[leetcode]——另一个树的子树

lucky52529的博客

12-10

404

给定两个非空二叉树 s 和 t，检验 s 中是否包含和 t 具有相同结构和节点值的子树。s 的一个子树包括 s 的一个节点和这个节点的所有子孙。s 也可以看做它自身的一棵子树。示例 1: 给定的树 s: 3 / \ 4 5 / 1 2 给定的树 t： 4 / 1 2 返回 true，因为 t 与 s 的一个子树拥有相同的结构和节点值。示例 2: 给定的树 s： 3...

How can I exclude directories from grep -R?

davidwang456的专栏--备份

12-23

776

‘--exclude-dir=dir’ Exclude directories matching the pattern dir from recursive directory searches. Recent versions of GNU Grep (>= 2.5.2) provide: ‘--exclude-dir=dir’ Exclud

ocp-163

jiayue's BLOG

10-07

1471

QUESTION NO: 163 How many individual archive-log destination directories are supported by Oracle Database11g?A. 7 B. 1 C. 10 D. 11 E. 21 Answer: COracle 11g数据库支持多少个人存档日志目标目录？C. 10

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

一抹曦阳-Oracle

03-06

4563

568.Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.) A. Database datafiles B. Control files C. Archived redo logs D. Onl

ocp-81

jiayue's BLOG

10-04

1589

QUESTION NO: 81 Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since

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

一抹曦阳-Oracle

11-10

7964

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-V13.02-486题

一抹曦阳-Oracle

03-04

9716

486.You execute the following Recovery Manager (RMAN) commands in (he following order: BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST; Which (two tasks are performed by these commands? (Choose two

How to Recover Lost Media Packets in WebRTC using Forward Error Correction

mandagod的博客

02-27

481

How to Recover Lost Media Packets in WebRTC using Forward Error Correction BY: LASSE LUMIAHO, VARUN SINGH, 09 NOVEMBER 2016 This is a followup blog post to an earlier post on error resil

ORA_ERROR大全