A. Put the database in hot backup mode and perform an online backup,including backing up the archived redo logs.
B. Just back up the database datafiles without shutting down the database.
C. You will have to wait until you can shut down the database to perform the backup.
D. Mark each datafile as backup in progress, back them up individually,and then mark them as backup not in progress. No archived redo logs will need to be backed up.
E. Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing,you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
您可能感兴趣的试卷
你可能感兴趣的试题
As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query?()
SQL> select group_number, name, state from v$ASM_DISKGROUP;
GROUP_NUMBER NAME STATE
0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED
A. The DGROUP1 disk group was unmounted by another DBA.
B. A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
C. One of the redundant disks (DGROUP1) has been lost in a disk group.
D. This query has no meaning in an ASM instance.
E. A disk associated with a disk group was discovered after the ASM instance initially opened.
You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch.
What do you do?()
A. Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed,bring the disk group online again.
B. Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced,reset the parameter to its original value.
C. You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced, add the disk back into the disk group and allow ASM to rebuild it.
D. If you are using any setting other than REDUNDANCY EXTERNAL for your disk group,you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.
E. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
A. The command fails unless you specify the FORCE option.
B. The command fails unless you specify the REUSE option.
C. The command must be reissued with a more specific discovery string.
D. The other disks, already part of the disk group,are ignored.
A. ADD DIRECTORY
B. DROP DISK
C. RESIZE DISK
D. REBALANCE
E. ADD FAILGROUP
A. Issue the ALTER DISKGROUP ... ADD DISK command.
B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.
C. Issue the ALTER DISKGROU
D. Retrieve the disk from the Recycle Bin after the operation completes.
A. All types of files are spread across all disks in the disk group.
B. Datafiles
C. Redo log files
D. Archived redo log files
E. Control files
A. ORBn
B. OSMB
C. RBAL
D. ASMn
To reference existing ASM files, you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A, the database name is DEV19, and the ASM file that you want to reference is a datafile for the USERS02 tablespace.
Which of the following is a valid ASM filename for this ASM file?()
A. dev19/+DG2A/datafile/users02.701.2
B. +DG2A/dev19/datafile/users02.701.2
C. +DG2A/dev19/users02/datafile.701.2
D. +DG2A·701.2
E. +DG2A/datafile/dev19.users.02.701.2
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.
最新试题
Examine the following RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?()
Which two statements are true about encrypting RMAN backup?()
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?()
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?()
Which three statements are true about persistent configuration?()
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 command creates an image copy?()
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?()
Which two statements are true about a job chain?()
Which option is best practice for creating a recovery catalog owner in the catalog database?()