OCP 1Z0 052 76
来源:互联网 发布:js window.resize 编辑:程序博客网 时间:2024/06/06 03:43
76. Which statement is true about a whole consistent database backup on a database running in
ARCHIVELOG mode?
A.The backup will consist of used data blocks only.
B.The database must be shut down to accomplish the backup.
C.The backup can be accomplished without shutting down the database.
D.The backup will contain all database files that have never been backed up.
Answer: B
见文档是一致性备份的例子http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta006.htm#RCMRF90004
ARCHIVELOG mode?
A.The backup will consist of used data blocks only.
B.The database must be shut down to accomplish the backup.
C.The backup can be accomplished without shutting down the database.
D.The backup will contain all database files that have never been backed up.
Answer: B
当在open模式下时,数据是变动的,这时data file的scn为空,备份的数据不是一致的。
SQL> SELECT file#, last_change# FROM v$datafile; FILE# LAST_CHANGE#---------- ------------ 1 2 3 4 5 6 6 rows selected
见文档是一致性备份的例子http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta006.htm#RCMRF90004
Example 2-13 Making a Consistent Database Backup
Assume that the database is open and you want to make a consistent backup of the whole database. This example shuts down the database consistently, mounts the database, makes a consistent whole database backup, and then opens the database.
SHUTDOWN IMMEDIATE;STARTUP MOUNT;BACKUP DATABASE PLUS ARCHIVELOG;# Now that the backup is complete, open the database.ALTER DATABASE OPEN;
Example 2-14 Mounting the Database After Restoring the Control File
This example restores the control file, mounts it, and performs recovery. Finally, the example resets the online redo log.
STARTUP FORCE NOMOUNT;RESTORE CONTROLFILE FROM AUTOBACKUP;ALTER DATABASE MOUNT;# You must run the RECOVER command after restoring a control file even if no # datafiles require recovery.RECOVER DEVICE TYPE DISK DATABASE;ALTER DATABASE OPEN RESETLOGS;
0 0
- OCP 1Z0 052 76
- OCP 1Z0 052 1
- OCP 1Z0 051 76
- OCP 1Z0 053 76
- OCP 1Z0 052 2
- OCP 1Z0 052 3
- OCP 1Z0 052 4
- OCP 1Z0 052 5
- OCP 1Z0 052 6
- OCP 1Z0 052 7
- OCP 1Z0 052 8
- OCP 1Z0 052 9
- OCP 1Z0 052 10
- OCP 1Z0 052 11
- OCP 1Z0 052 12
- OCP 1Z0 052 13
- OCP 1Z0 052 14
- OCP 1Z0 052 15
- cocos2dx android游戏防破解总结
- 如何判断多边形的点列是否逆时针方向
- Javascript实现简单的选项卡
- 并查集——Ubiquitous Religions
- 软件工程师成长历程
- OCP 1Z0 052 76
- 资讯综合模板-顶部导航处修改
- 如何做到高效学习?
- 许我海誓山盟,我也无法给
- const的内部链接属性
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ mysql.sock
- const、static、内部链接属性和外部链接属性整理
- android-魔法泡泡-泡泡动画分析
- 一直在CSDN各大神博客逛,今天我也开通了属于我自己的博客~~~~~