Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-067

Free Oracle 1Z0-067 Exam Questions (page: 9)

Page 9 of 45
PDF with 264 Questions

Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'
LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

  1. The database instance hangs and the redo log files are not overwritten.
  2. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
  3. The database instance is shutdown immediately.
  4. The destination set by the log_archive_destparameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer(s): D



Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

  1. when the duplicate ... from active database command contains the section size clause
  2. when you perform active database duplication on a database with flashback disabled
  3. when you specify set encryption before the duplicate ... from active database command
  4. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
  5. when you perform active database duplication on a database that has read-onlytablespaces

Answer(s): A,C,D


Reference:

http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298



Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

  1. Tables or table partitions can be recovered by using an auxiliary instance only.
  2. Tables or table partitions with a foreign key cannot be recovered.
  3. Tables or table partitions can be recovered only when the database is in mount state.
  4. Tables or table partitions from the system and sysauxtablespaces cannot be recovered.
  5. Tables with not null constraints cannot be recovered.

Answer(s): D,E


Reference:

http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695(Limitations of Recovering Tables and Table Partitions from RMAN Backups)



Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set D3ID of the target database in RMAN.
2.Start the database instance by using the startup force nomount command in RMAN.
3.Restore the control files from the backup.
4.Mount the database.
5.Restore the SPFILE from the autobackup.
6.Create a PFILE from the recovered SPFILE.
7.Restart the instance in nomount state.
Identify the required steps in the correct order.

  1. 1, 2, 5, 3, 6, 4
  2. 1, 2, 3, 5, 6, 4
  3. 2, 1, 5, 7, 3, 4
  4. 2, 1, 5, 6, 7, 4, 3

Answer(s): D

Explanation:

The correct order to restore the SPFILE and control file and mount the database is:

Start the database instance using the startup force nomount command in RMAN.
Set the D3ID of the target database in RMAN.
Restore the SPFILE from the autobackup.
Create a PFILE from the recovered SPFILE.
Restart the instance in nomount state.
Restore the control files from the backup.
Mount the database.
Step 1 is to start the instance with the force nomount option in RMAN, which allows you to open the database without mounting it.
Step 2 is to set the D3ID in RMAN, this is used to uniquely identify the target database and is required when you connect to the target database in nomount state.
Step 3 is to restore the SPFILE, which contains the initialization parameters for the instance, from the autobackup.
Step 4 is to create a PFILE from the recovered SPFILE, in order to start the instance.
Step 5 is to restart the instance in nomount state using the PFILE created in step 4.
Step 6 is to restore the control file from the backup.
Step 7 is to mount the database.



Viewing page 9 of 45



Post your Comments and Discuss Oracle 1Z0-067 exam prep with other Community members:

1Z0-067 Exam Discussions & Posts