Oracle OCP IZ0-053 Q660(Configure Flashback Database)
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>
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 10g flashback databaseOracle 10gDatabase
- Oracle OCP(35):Database 安裝OracleDatabase
- Oracle OCP(38):Database 物理結構OracleDatabase
- Oracle 19c Database Configure the HTTPS Port for EM ExpressOracleDatabaseHTTPExpress
- Oracle OCP(37):Database 體系結構OracleDatabase
- 在Oracle DG Standby庫上啟用flashback database功能OracleDatabase
- ORACLE 閃回檢視v$flashback_database_log/statOracleDatabase
- Oracle OCP(39):Database 記憶體結構OracleDatabase記憶體
- 【Flashback】Flashback Database閃回資料庫功能實驗Database資料庫
- 【FLASHBACK】Oracle flashback data archive 介紹OracleHive
- [20210722]ORA-38760與flashback database.txtDatabase
- ORACLE Flashback Query偽列Oracle
- Flashback database必須要有之前的archivelog嗎?DatabaseHive
- 【OCP最新題庫解析(052)--題9】You want to install Oracle 11g databaseOracleDatabase
- Oracle OCP(56)Oracle
- oracle ocp 19c考題8,科目082考試題-logical and physical database structuresOracleDatabaseStruct
- Oracle 備份恢復之 FlashbackOracle
- ORACLE database vaultOracleDatabase
- Oracle clone databaseOracleDatabase
- Oracle OCP(23):序列Oracle
- Oracle OCP(29):PROFILEOracle
- Oracle OCP(54):EXPOracle
- Oracle OCP(54):IMPOracle
- Oracle OCP(57):IMPDPOracle
- Oracle OCP(44):LSNRCTLOracle
- Oracle OCP(28):USEROracle
- Oracle OCP(25):索引Oracle索引
- Oracle OCP(30):ROLEOracle
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Oracle閃回技術--Flashback Version QueryOracle
- Oracle Database Scheduler整理OracleDatabase
- Oracle Physical Database LimitsOracleDatabaseMIT
- Oracle OCP(33):官方文件Oracle
- Oracle OCP(20):建立表Oracle
- Oracle OCP(21):管理表Oracle
- Oracle OCP(12):ROLLUP & CUBEOracle
- Oracle OCP(48):UNDO TABLESPACEOracle
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- Oracle OCP(24):檢視Oracle