單項選擇題

Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）

A.The data files can be recovered till the last committed transaction.
B.The data files can be recovered without shutting down the database.
C.The data file is taken offline automatically； the database remains open.
D.The data files can be recovered to the time of the most recent backup.

你可能感興趣的試題

單項選擇題

You executed the following command to start the database：
SQL> STARTUP
ORACLE instance started.
Total System Global Area 281018368 bytes
Fixed Size 789000 bytes
Variable Size 229635576 bytes
Database Buffers 50331648 bytes
Redo Buffers 262144 bytes
ORA-00205： error in identifying controlfile， check alert log for more info
Which view would you query at this stage to investigate this missing control file？（）

A.V$INSTANCE
B.V$CONTROLFILE
C.DBA_CONTROL_FILES
D.V$DATABASE_PROPERTIES
E.V$CONTROLFILE_RECORD_SECTION

多項選擇題

In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）

A.The database instance aborts.
B.The database operation temporarily halts till the member becomes available.
C.Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D.The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E.The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）

你可能感興趣的試題

In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）