You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.
Which information is NOT required during the migration process?()
A. Database Identifier (DBID)
B. names and location of datafiles
C. names and location of control files
D. names and location of online redo log files
您可能感兴趣的试卷
你可能感兴趣的试题
A. ASMB
B. ARBn
C. RBAL in the ASM instance
D. RBAL in the database instance
Consider the following configuration:
/devices/diskP1 is a member of disk group grp1.
/devices/diskP2 is a member of disk group grp1.
/devices/diskP3 is a member of disk group grp1.
/devices/diskP4 is a candidate disk.
/devices/diskQ1 is a member of disk group grp2.
/devices/diskQ2 is a member of disk group grp2.
/devices/diskQ3 is a member of disk group grp2.
/devices/diskQ4 is a candidate disk.
Which command will add the disk /devices/diskP4 to the disk group, grp1?()
A. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP1’, ADD DISK ’/devices/diskP4’;
B. ALTER DISKGROUP grp1 ADD DISK ’/devices/disk*4’;
C. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP*’;
D. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskQ*’, ADD DISK ’/devices/diskP*’;
A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. LARGE_POOL_SIZE
A. CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc(datafile)’;
B. CREATE TABLESPACE DATA1 DATAFILE ’+grp1’;
C. CREATE TABLESPACE DATA1 DATAFILE ’+data1(tempfile)’;
D. CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’;
A. The database will not start.
B. The database will start but will not retain the undo data in the undo segment.
C. The database will start, and the undo segment will contain the undo data for at least one hour.
D. The database will start, and the undo segment will retain the undo data for at least 15 minutes.
A. The database must be in the ARCHIVELOG mode.
B. The automatic memory tuning must be enabled.
C. The change tracking feature must be enabled.
D. The automatic memory tuning must be disabled.
A. Memory Advisor
B. Segment Advisor
C. Undo Advisor
D. SQL Tuning Advisor
A.ADDM
B.AWR
C.Cursor Cache
D.SQL Tuning Sets
E.Flash Recovery Area
A.DBMS_SERVER_ALERT
B.DBMS_ADVISOR
C.DBMS_RESOURCE_MANAGER
D.DBMS_REPAIR
A. SQL Tuning Advisor
B. SQL Access Advisor
C. Undo Advisor
D. Segment Advisor
最新试题
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
You lost the PRODSTD tablespace, which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace?()
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to recreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to recreate the indexes?()
You lost the index tablespace in your database. You are not able to use tablespace pointintime recovery on the index tablespace. What could be the reason for this?()
View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true?()
You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()
You performed a backup of the flash recovery area by using the following command for the first time:RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()
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?()