Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?() 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.
A、1,3,6,7
B、2,3,6,8
C、1,2,3,6,7
D、1,2,3,6,,7,8
E、2,3,6,5,7
相关问题推荐
-
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
-
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
-
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
A、Oracle Net Manager
B、Listener Control utility
C、Database Configuration Assistant
D、Oracle Net Configuration Assistant
-
You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?()
A、ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
B、ALTER DISKGROUP dg1 UNDROP;
C、ALTER DISKGROUP dg1 UNDROP DISKS;
D、You cannot cancel the pending disk drops.