The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted.
What steps should you take to recover from this tempfile loss in an efficient manner?()
A. Allow the database to continue running,drop the TEMP tablespace,and then re-create it with new tempfiles
B. Shut down the database, restore and recover the tempfile from backup,and then open the database with RESETLOGS
C. Allow the database to continue running,take the TEMP tablespace offline,drop the missing tempfile,and then create a new tempfile
D. Allow the database to continue running,add a new tempfile to TEMP tablespace with a new name,and drop the tempfile that has been corrupted
您可能感兴趣的试卷
你可能感兴趣的试题
A. The tape I/O performed is asynchronous
B. The tape buffer is allocated from the System Global Area (SGA)
C. The tape buffer is allocated from the Program Global Area (PGA)
D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?()
A. It cancels all pending disk drops within the disk group.
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:
1) Restore an autobackup of the server parameter file.
2) Restore the control file
3) Start the target database instance
4) Mount the database
5) Restore the data files
6) Open the database with RESETLOGS option
7) Recover the data files
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use?()
A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 4, 2, 5, 7, 6
C. 1, 3, 4, 2, 8, 5, 6, 7
D. 1, 3, 2, 4, 6, 5, 7, 8
A. Creating the control file for the duplicate database
B. Restoring the target data files to the duplicate database
C. Performing complete recovery using all available backups
D. Generating a new, unique DBID for the duplicate database
E. Copying the online redo log files from the target database to the duplicate database
A. Configure backup optimization
B. Configure the channel to increase MAXOPENFILES
C. Configure the channel to increase the capacity with the RATE parameter
D. Configure the channel to adjust the tape buffer size with the BLKSIZE option
A. Testing the backup and recovery procedures
B. Testing the upgrade of an Oracle database to a new release
C. Testing the effect of an application changes on database performance
D. Continuously updating archive log files from the target database to support failover
Examine the CREATE DISKGROUP command used to create a disk group:
SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY
DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2;
In which situation would you use this method of disk group creation?()
A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks
A. A job chain can contain a nested chain of jobs
B. The jobs in a job chain cannot have more than one dependency
C. A job of the CHAIN type can be run using event-based or time-based schedules
D. The jobs in a job chain can be executed only by using the events generated by the Scheduler
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).
Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?()
A. Because the FRA disk group will not support dynamic rebalancing
B. Because the FRA disk group is not configured to support mirroring
C. Because disks in the FRA disk group are not formatted at this stage
D. Because the FRA disk group will support only a single size of allocation unit
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?()
A. Complete Recovery with online redo log
B. Complete Recovery with archived redo log
C. Tablespace Point-in-Time Recovery (TSPITR)
D. Incomplete Recovery with system change number (SCN)
最新试题
Which three tasks can be performed using a duplicate database?()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()
Which two statements are true about encrypting RMAN backup?()
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()
Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode?()
Which three statements are true about persistent configuration?()
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
Which command creates an image copy?()
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN).()
You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation?()