Oracle OCP IZ0-053 Q660(Configure Flashback Database)

abstractcyj發表於2016-03-16
OracleDatabase
660.You want to configure the Flashback Database feature and retain flashback logs for three days.
Presently the database is open and configured in ARCHIVELOG mode.
The following steps must be performed in the correct sequence to do this:
1. Set the retention target:
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
2. Enable Flashback Database:
SQL> ALTER DATABASE FLASHBACK ON;
3. Mount the database:
SQL> STARTUP MOUNT EXCLUSIVE
4. Shutdown the instance:
SQL> SHUTDOWN IMMEDIATE
5. Open the database:
SQL> ALTER DATABASE OPEN;
Choose the correct sequence.
A. 4, 1, 3, 2, 5
B. 4, 3, 1, 2, 5
C. 2, 4, 3, 5, 1
D. 4, 2, 5, 3, 1
Answer: B


驗證：
[oracle@db01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 16 14:20:48 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 20259
Session ID: 143 Serial number: 77
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>  ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
System altered.
SQL> ALTER DATABASE FLASHBACK ON;
Database altered.
SQL> alter database open;
Database altered.
SQL> 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2058179/，如需轉載，請註明出處，否則將追究法律責任。

相關文章