单项选择题
You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA table space is stored. The database is currently open and you need to recover the data file. You will restore the data file to DISK2.
What is the correct sequence RMAN commands to restore and recover the data file?()
A.A
B.B
C.C
D.D
相关考题
-
多项选择题
WhichtwostatementsregardingthecontrolfileandRecoverManageraretrue?()
A.The control file can grow in size.
B.The control file can store RMAN scripts.
C.CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.
D.The RMAN catalog can exist solely in the control file of the target database. -
单项选择题
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do?()
A.Use the DROP DATAFILE command.
B.Use the DROP TABLESPACE command.
C.Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
D.Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command. -
多项选择题
Examine the statement: SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully?()
A.Oracle Managed Files are used for this instance.
B.The USER_DATA tablespace is managed using FET$/UET$ tables.
C.The COMPATIBLE initialization parameter must be 9.0.0 or higher.
D.Space within segments in the USER_DATA tablespace is managed with freelists.
