單項(xiàng)選擇題

Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

A.recovery cannot be performed because a backup was not performed after the last incomplete recovery
B.restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
C.restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
D.restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

你可能感興趣的試題

單項(xiàng)選擇題

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.
In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

A.loss of a tempfile
B.loss of a system data file
C.loss of one of the control files
D.loss of one of the tablespaces
E.loss of a member from each redo log group
F.loss of the only member of an unarchived redo log group

單項(xiàng)選擇題

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to
’LOG%t_%s_%r.dbf’.
Why is %r used in the file name format？（）

A.to uniquely identify the archived log files with the restore operation
B.to uniquely identify the archived log files with the redo log group number
C.to uniquely identify the archived log files for each incarnation of the database
D.to uniquely identify the archived log files with the number of recovery operations performed

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

你可能感興趣的試題

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format？（）

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

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.
In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to
’LOG%t_%s_%r.dbf’.
Why is %r used in the file name format？（）