單項選擇題

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.
How would you recover the lost redo log member？（）

A.import the database from the last export
B.restore all the members in the group from the last backup
C.drop the lost member from the database， and then add a new member to the group
D.restore all the database files from the backup， and then perform a complete recovery
E.restore all the database files from the backup， and then perform an incomplete recovery

你可能感興趣的試題

單項選擇題

A user executes a query on the EMP table， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal
*
ERROR at line 1：
ORA01157： cannot identify/lock data file 201 see DBWR trace file
ORA01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’
What is a possible reason？（）

A.The tempfile belonging to the default temporary tablespace is missing.
B.The database is opened in restricted mode， so queries are not allowed.
C.The default temporary tablespace required to execute the query is offline.
D.The default temporary tablespace required to execute the query is dropped.
E.The default temporary tablespace required to execute the query is readonly.

多項選擇題

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A.The database opens normally.
B.The database prompts for a database recovery.
C.The database writer writes to a trace file， indicating that the temporary file is not found.
D.The database gets mounted and throws an error indicating that the temporary file requires recovery.

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

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member？（）

你可能感興趣的試題

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）

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

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.
How would you recover the lost redo log member？（）

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）