In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?() (Choose two.)
A2, 6, 4, 5, 3
B1, 2, 4, 5, 3, 6
C1, 2, 4, 6, 3
D1, 2, 7, 5, 3, 6
相关问题推荐
-
Examine the following commands and their output: View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?()
A、 Flashback logging is not enabled for the database.
B、 The changes made to the table are not committed.
C、 Supplemental logging is not enabled for the database.
D、 The database is not configured in ARCHIVELOG mode.
-
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
ARedo logs
BControl file
CThe latest backup of only the damaged data file
DThe latest backup of all the data file in the USERS tablespace
ETemporary files of temporary tablespace
FArchive Logs since the latest backup to point of failure
-
Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job?()
ASET_ATTRIBUTE_NULL
BALTER_JOB
CALTER_JOB_PARAMETERS
DALTER
ESET_ATTRIBUTE
-
The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?()
A、The Oracle database will perform block checking for the index blocks only
B、The Oracle database will not perform block checking for any of the data blocks
C、The Oracle database will perform block checking for the default permanent tablespace only
D、The Oracle database will perform block checking for the data blocks in all user tablespaces
E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
-
Which command will result in a trace file being created with the create controlfile command contained in it?()
A、 alter database backup controlfile
B、 alter database backup controlfile to trace
C、 alter database controlfile backup
D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
E、 alter database begin controlfile backup