A.A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure.
B.During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files.
C.After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file.
D.At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
您可能感兴趣的试卷
你可能感兴趣的试题
A.ARCHIVELOG mode.
B.NOARCHIVELOG mode.
C.Open database backups.
D.Consistent whole backups.
A.user-managed backups.
B.partial database backups.
C.consistent database backups.
D.inconsistent database backups.
A.Directory server
B.Hostname adaptor
C.TCP/IP host file
D.Connection Manager
E.connecting pooling
F.external procedures
G.listener names and protocol addresses
H.Net Service names in a tnsnames.ora file
I.naming methods the client uses to resolve connect identifiers
A.data files
B.control file
C.password file
D.online redo log files
E.initialization parameter file
A.The dispatcher returns the response to the user.
B.The dispatcher places the request into the request queue.
C.The shared server places the response in the response queue.
D.The response is handed off to the next available dispatcher.
E.A shared server picks up the request from the request queue and processes the request.
You have lost all members of your current redo log file group. You issue this query: SQL> select * from v$log;
GROUP# SEQ# BYTES ARC STATUS FIRST_NAME
1 60 153600 NO INACTIVE 01-03-09:19:34
2 61 153600 NO CURRENT 01-03-09:19:50
You then perform an incomplete recover. You receive this message: ORA-00279:
change 309141...03/09/01 19:50:14 Needed for thread 1
ORA-00289: suggestion : /disk1/archive/arch_61.rdo ORA-00280: change 309043 for thread 1 is in sequence #61 Specify log: {
A.Enter the keyword AUTO.
B.Enter the keyword CANCEL.
C.Press the Enter or Return key.
D.Enter the filename ’/disk1/archive/log2a.rdo’.
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.
There was only one data file on this disk; it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available?()
A.Only bring the tablespace back online.
B.Only recover the tablespace and then bring the tablespace back online.
C.Shut down the database, recover the data file and then start up the database.
D.Issue the ALTER DATABASE RENAME FILE command, recover the tablespace, and then bring the tablespace online.
E.Recover the tablespace, issue the ALTER DATABASE RENAME FILE command, and then bring the tablespace online.
A.Recovery is initiated using SQL*Plus.
B.Database files are backed up using SQL commands.
C.Database files are backed up with Recovery Manager.
D.Database files are restored using Recovery Manager.
E.Database files are backed up using operating system commands.
最新试题
The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()
Which of the following packages maintains information in the recovery catalog? ()
As a result of a media failure, the current online redo log group is corrupted. The database crashes, as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform? ()
Which of the following options would you choose to implement controlled access using remote authentication for your networks?()
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database?()
Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?()
Which of the following roles must be granted to a user to perform a full database import?()
Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state, prior to the load operation?()