Datasheet

Review Questions 49
D. CREATE DISKGROUP dg_alliance1
MAXIMUM REDUNDANCY
failgroup diskcontrol1 DISK ‘c:\oracle\asm_disk\_file_disk1’ NAME file_
disk1
failgroup diskcontrol2 DISK ‘c:\oracle\asm_disk\_file_disk2’ NAME file_
disk2
failgroup diskcontrol2 DISK ‘c:\oracle\asm_disk\_file_disk3’ NAME file_
disk3
failgroup diskcontrol2 DISK ‘c:\oracle\asm_disk\_file_disk4’ NAME file_
disk4;
E. None of the above
10. You want to migrate your database to ASM, so you’ve done a clean shutdown, made a
closed backup of the entire database, noted the location of your control files and online
redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script
to do the conversion. Using the following steps, what is the correct order in which the fol-
lowing RMAN commands should be executed?
1.
STARTUP NOMOUNT
2.
ALTER DATABASE OPEN RESETLOGS
3.
SQL “ALTER DATABASE RENAME ‘logfile1 path’ TO ‘+dgrp4 ‘“ # plus all
other logfiles
4.
SWITCH DATABASE TO COPY
5.
BACKUP AS COPY DATABASE FORMAT ‘+dgrp4’
6.
ALTER DATABASE MOUNT
7.
RESTORE CONTROLFILE FROM ‘controlfile_location’
A. 2, 5, 3, 1, 7, 6, 4
B. 1, 7, 6, 5, 4, 3, 2
C. 5, 1, 2, 7, 4, 6, 3
D. 7, 3, 1, 5, 6, 2, 4
11. How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has
not yet completed?
A. Issue the ALTER DISKGROUP … ADD DISK command.
B. Issue the ALTER DISKGROUP … UNDROP DISKS command.
C. Issue the ALTER DISKGROUP … DROP DISK CANCEL command.
D. Retrieve the disk from the Recycle Bin after the operation completes.
95134c01.indd 49 1/28/09 9:43:47 AM