Oracle OCP 1Z0-053 Q98(Flashback Database&Resetlogs)

最新推荐文章于 2021-04-06 15:07:02 发布

congsong2560

最新推荐文章于 2021-04-06 15:07:02 发布

阅读量81

点赞数

本文介绍使用Flashback Database操作恢复数据库到过去某个时间点的过程及注意事项。演示了如何正确执行闪回数据库操作，并强调了数据库必须处于已挂载状态且不能打开的重要性。

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

98.You plan to execute the following command to perform a Flashback Database operation in your
database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);
Which two statements are true about this? (Choose two)
A. The database must have multiplexed redo log files
B. The database must be in the MOUNT state to execute the command
C. The database must be in the NOMOUNT state to execute the command
D. The database must be opened in RESTRICTED mode before this operation
E. The database must be opened with the RESETLOGS option after the flashback operation
Answer: BE

验证：
SQL> flashback database to timestamp (sysdate - 1);
flashback database to timestamp (sysdate - 1)
*
ERROR at line 1:
ORA-38757: Database must be mounted and not open to FLASHBACK.

SQL> shutdown immdiate
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 413372416 bytes
Fixed Size 2253784 bytes
Variable Size 314575912 bytes
Database Buffers 88080384 bytes
Redo Buffers 8462336 bytes
Database mounted.
SQL> flashback database to timestamp (sysdate - 1);

Flashback complete.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;
Database altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8520577/viewspace-2062476/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8520577/viewspace-2062476/