单项选择题
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file:
1.RESTORE CONTROLFILE;
2.RESTORE DATABASE;
3.ALTER DATABASE MOUNT;
4.SQL ALTER TABLESPACE temp ADD TEMPFILE
5.ALTER DATABASE OPEN RESETLOGS;
6.RECOVER DATABASE;
7.STARTUP NOMOUNT;
In what sequence would you use this process to perform the recovery?()
A. 2, 7, 3, 5, 1, 6, 4
B. 2, 1, 7, 6, 3, 5, 4
C. 7, 1, 3, 2, 6, 5, 4
D. 7, 2, 3, 1, 4, 6, 5
相关考题
-
单项选择题
Youareworkingonadatabase,whereyouhavethreeredologgroups.Whenthedatabaseisdownforabackup,anoperatingsystem(OS)userdeletesalltheredologfilesinagroup.Whatwillhappenwhenyouopenyourdatabase?()
A. The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.
B. Before the instance starts, you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens because two redo log groups still exist.
E. The instance starts and the database opens, but every attempt to write to redo log files fails with an error. -
单项选择题
Youhaveonlytworedologgroupsandthesegroupsgetoverwrittenseveraltimesinaday.Your databaseoperatesinNOARCHIVELOGmodeanduser-managedconsistentbackupsareperformedeverySundaynight.OnThursdaymorning,youfindthatanimportanttablehasbeendroppedandpurged.Withreferencetothisscenario,uptowhatpointintimecanthedataberecovered?()
A. until Thursday morning
B. until that point in time when the database is opened
C. until that point in time when the recovery is performed
D. until last Sunday’s backup
E. until that point in time when the table is dropped and purged
F. until Wednesday evening -
单项选择题
YouconfiguredthelargepoolforOraclebackupandrestoreoperations.Asaresult,whichcomponentwouldrequirelessmemory?()
A. streams pool
B. shared pool
C. log buffer
D. keep buffer cache
E. recycle buffer cache
