You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code?() RMAN>RUN { SET UNTIL SEQUENCE THREAD ; RESTORE DATABASE; RECOVER DATABASE; }
A、 NOMOUNT
B、 MOUNT
C、 OPEN
D、 RESTRICTED
相关问题推荐
-
In which scenario will you create a sorted hash cluster? ()
A、 if the application uses queries joining tables only occasionally
B、 if the full table scan is executed often on only one table of the clustered tables
C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
D、 when you want the data to be returned automatically in the chronological order
-
Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database? ()
AThe database opens normally.
BThe database prompts for a database recovery.
CThe database writer writes to a trace file, indicating that the temporary file is not found.
DThe database gets mounted and throws an error indicating that the temporary file requires recovery.
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option?()
AThis operation resets the SCN for the database.
BThis operation creates a new incarnation of the database.
CThis operation moves all the redo log files to a different location.
DThis operation deletes the old redo log files and creates new redo log files.
EThis operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
-
The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?()
A、 time-based recovery
B、 log sequence recovery
C、 cancel-based recovery
D、 change-based recovery
-
You issued the following command: SQL> DROP TABLE MYTABLE; SQL> SHOW RECYCLEBIN The following output is returned: ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ------------- ------------------------------ --------------- -------------------- MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE 2005-01-13:20:11:31 You want to drop the table, MYTABLE, from the Recycle Bin. Which two commands can you issue to accomplish the desired task?()
ADROP TABLE MYTABLE PURGE;
BPURGE RECYCLEBIN;
CPURGE TABLE MYTABLE;
DPURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0;