Oracle OCP 1Z0-053 Q98(Flashback Database&Resetlogs)
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.
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0-053 Q686(Flashback Table)Oracle
- Oracle OCP 1Z0-053 Q252(Flashback Version Query)Oracle
- Oracle OCP 1Z0-053 Q672(Flashback Data Archive)OracleHive
- Oracle OCP 1Z0-053 Q385(Flashback Table Recovery)Oracle
- Oracle OCP 1Z0-053 (ASM)OracleASM
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0-053 (System Partitioning)Oracle
- Oracle OCP 1Z0-053 Q445Oracle
- Oracle OCP 1Z0 053 Q83(Flashback Database)OracleDatabase
- Oracle 11G OCP 1Z0-053 600Oracle
- Oracle 11G OCP 1Z0-053 581Oracle
- Oracle 11G OCP 1Z0-053 582Oracle
- Oracle 11G OCP 1Z0-053 583Oracle
- Oracle 11G OCP 1Z0-053 584Oracle
- Oracle 11G OCP 1Z0-053 585Oracle
- Oracle 11G OCP 1Z0-053 586Oracle
- Oracle 11G OCP 1Z0-053 587Oracle
- Oracle 11G OCP 1Z0-053 588Oracle
- Oracle 11G OCP 1Z0-053 589Oracle
- Oracle 11G OCP 1Z0-053 590Oracle
- Oracle 11G OCP 1Z0-053 591Oracle
- Oracle 11G OCP 1Z0-053 592Oracle
- Oracle 11G OCP 1Z0-053 593Oracle
- Oracle 11G OCP 1Z0-053 594Oracle
- Oracle 11G OCP 1Z0-053 595Oracle
- Oracle 11G OCP 1Z0-053 596Oracle
- Oracle 11G OCP 1Z0-053 597Oracle
- Oracle 11G OCP 1Z0-053 598Oracle
- Oracle 11G OCP 1Z0-053 563Oracle
- Oracle 11G OCP 1Z0-053 564Oracle
- Oracle 11G OCP 1Z0-053 565Oracle
- Oracle 11G OCP 1Z0-053 566Oracle
- Oracle 11G OCP 1Z0-053 567Oracle
- Oracle 11G OCP 1Z0-053 568Oracle
- Oracle 11G OCP 1Z0-053 569Oracle
- Oracle 11G OCP 1Z0-053 570Oracle
- Oracle 11G OCP 1Z0-053 571Oracle
- Oracle 11G OCP 1Z0-053 572Oracle