OCP-IZO-053_QUESTION390_ Flashback Database recovery point parameters
QUESTION NO: 390
Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)
A. SCN
B. Timestamp
C. Named recovery point
D. Transaction ID
E. Session ID
【題目示意】
此題考查有關於Flashback Database recovery point的相關知識。
【解析】
在閃回整個資料庫的時候,指定一個過去的時間點,SCN,或者日誌序列號。
【實驗】
1)啟用資料庫閃回功能:
SYS@ENMOEDU > startup mount;
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1345380 bytes
Variable Size 306186396 bytes
Database Buffers 109051904 bytes
Redo Buffers 6086656 bytes
Database mounted.
SYS@ENMOEDU > alter database flashback on;
SYS@ENMOEDU > select FLASHBACK_ON from v$database;
FLASHBACK_ON
------------------
YES
2)基於時間點的資料庫閃回
SYS@ENMOEDU > select count(*) from t1;
COUNT(*)
----------
72152
SYS@ENMOEDU > select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') tm from dual;
TM
-------------------
2014-02-01 20:19:09
SYS@ENMOEDU > drop table t1;
Table dropped.
SYS@ENMOEDU > shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ENMOEDU > startup mount;
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1345380 bytes
Variable Size 306186396 bytes
Database Buffers 109051904 bytes
Redo Buffers 6086656 bytes
Database mounted.
SYS@ENMOEDU > flashback database to timestamp to_timestamp('2014-02-01 20:19:09','yyyy-mm-dd hh24:mi:ss');
Flashback complete.
SYS@ENMOEDU > alter database open read only;
SYS@ENMOEDU > shutdown
SYS@ENMOEDU > startup mount;
SYS@ENMOEDU > alter database open resetlogs;
Database altered.
SYS@ENMOEDU > select count(*) from t1;
COUNT(*)
----------
72152
3)基於SCN的閃回:
SYS@ENMOEDU > select count(*) from t1;
COUNT(*)
----------
72152
SYS@ENMOEDU > select current_scn from v$database;
CURRENT_SCN
-----------
915934
SYS@ENMOEDU > drop table t1;
Table dropped.
SYS@ENMOEDU > shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ENMOEDU > startup mount;
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1345380 bytes
Variable Size 310380700 bytes
Database Buffers 104857600 bytes
Redo Buffers 6086656 bytes
Database mounted.
SYS@ENMOEDU > flashback database to scn 915934;
Flashback complete.
SYS@ENMOEDU > alter database open read only;
SYS@ENMOEDU > shutdown
SYS@ENMOEDU > startup mount;
SYS@ENMOEDU > alter database open resetlogs;
Database altered.
SYS@ENMOEDU > select count(*) from t1;
COUNT(*)
----------
72152
4)基於時點的閃回
SYS@ENMOEDU > select count(*) from t1;
COUNT(*)
----------
72152
SYS@ENMOEDU > create restore point before_changes;
Restore point created.
SYS@ENMOEDU > drop table t1;
Table dropped.
SYS@ENMOEDU > shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ENMOEDU > startup mount
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1345380 bytes
Variable Size 310380700 bytes
Database Buffers 104857600 bytes
Redo Buffers 6086656 bytes
Database mounted.
SYS@ENMOEDU > flashback database to restore point before_changes;
Flashback complete.
SYS@ENMOEDU > alter database open read only;
SYS@ENMOEDU > shutdown
SYS@ENMOEDU > startup mount;
SYS@ENMOEDU > alter database open resetlogs;
Database altered.
SYS@ENMOEDU > select count(*) from t1;
COUNT(*)
----------
72152
【小結】
所以閃回過去的時間點可以有SCN,Timestamp,Named recovery point三個引數決定。因此選擇ABC
【答案】 ABC
相關參考
file:///D:/oracle/11g手冊_01/backup.112/e10642/rcmquick.htm#BABBHDFJ
The end
DB_SUN
2014.2.1
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29435844/viewspace-1076844/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Impact of Database Recovery and Flashback Database on the TDE Wallet_1327519.1Database
- db_recovery_file_dest_size, v$flashback_database_logfile,v$restore_point引發的血案.DatabaseREST
- Flashback DatabaseDatabase
- v$nls_parameters和nls_database_parametersDatabase
- Oracle OCP 1Z0 053 Q390(Flashback database&Named restore point)OracleDatabaseREST
- flashback技術之---flashback databaseDatabase
- Performing Tablespace Point-in-Time Recovery with Recovery Manager(轉)ORM
- flashback database 方法Database
- 配置Flashback DatabaseDatabase
- flashback系列文章三(flashback database)Database
- RMAN: Tablespace Point In Time Recovery (TSPITR)
- 關於flashback databaseDatabase
- How to enable the flashback database:Database
- 測試flashback databaseDatabase
- flashback database測試Database
- oracle flashback特性(3.2)--Flashback Database操作示例OracleDatabase
- flashback總結一之Flashback_DatabaseDatabase
- Enhanced Tablespace Point-In-Time Recovery (TSPITR)
- 應用oracle flashback--Flashback Database介紹OracleDatabase
- 啟用flashback database 功能Database
- [Flashback]Flashback Database閃回資料庫實驗Database資料庫
- Flashback database與flashback table使用條件區別Database
- 【徵文】應用oracle flashback(3.2)--Flashback Database操作示例OracleDatabase
- oracle 之recovery directory databaseOracleDatabase
- Oracle -- flashback database基於ARC+flashback_log還是flashback_logOracleDatabase
- oracle 10g flashback databaseOracle 10gDatabase
- flashback drop/query/table/database/archiveDatabaseHive
- flashback database 結合 data guardDatabase
- Oracle 閃回特性(FLASHBACK DATABASE)OracleDatabase
- 10.2 flashback database 測試!Database
- 【Flashback】Flashback Database閃回資料庫功能實驗Database資料庫
- flashback database如何選擇需要應用的flashback logDatabase
- 全面學習oracle flashback特性(3.2)--Flashback Database操作示例OracleDatabase
- 【Flashback】啟用Flashback Database閃回資料庫功能Database資料庫
- 【Flashback】Flashback Database閃回資料庫功能實踐Database資料庫
- ORA-38760: This database instance failed to turn on flashback databaseDatabaseAI
- 對於Database recovery的理解Database
- Flashback Database 閃回資料庫Database資料庫