Oracle
Oracle
Oracle
Oracle Database
Database
Database
Database 11g
11g
11g
11g Workshop
Workshop
Workshop
Workshop Administration
Administration
Administration
Administration II
II
II
II
Number : 1Z0-053
Passing Score : 800
Time Limit : 120 min
File Version : 3.2
Sections
Sections
Sections
Sections
1. Flashback Operations & Configuration
2. Backup, Recovery & Recovery Manager (RMAN)
3. Managing Database Performance & Tuning
4. SQL, PL/SQL, Packages, Functions, Jobs & Views
5. Database Architecture & Resource Management, RAC, ASM
6. Initialization, Parameters, File Location & Server Configuration
Exam
Exam
Exam
Exam A
A
A
A
QUESTION
QUESTION
QUESTION
QUESTION 1
1
1
1
What are the prerequisites for performing flashback transactions? (Choose all that apply)
A. Supplemental log must be enabled
B. Supplemental log must be enabled for the primary key
C. Undo retention guarantee for the database must be configured
D. ” EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user
Answer:
Answer:
Answer:
Answer: ABD
Section:
Section:
Section:
Section: Flashback Operations & Configuration
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Section:
Section:
Section:
Section: Flashback Operations & Configuration
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
http://www.oracleflash.com/30/Oracle-11g-Flashback-Transaction-in-OEM-LogMiner-Interfac
e.html
http://books.google.com/books?id=14ZH0eZV6G8C&pg=PA123&lpg=PA123&dq=flashback+
transaction+prerequisite&source=bl&ots=brh9_V-4Wz&sig=4PvpL2uM1xTf2eKkpoKKmaI8R
kY&hl=en&ei=ZSL8TKq0KIugsQOZ7ZT3DQ&sa=X&oi=book_result&ct=result&resnum=2&v
ed=0CB0Q6AEwAQ#v=onepage&q&f=false
QUESTION
QUESTION
QUESTION
QUESTION 2
2
2
2
Your production database is running in archivelog mode and you are using recovery manager
(RMAN) with recovery catalog to perform the database backup at regular intervals. When you
attempt to restart the database instance after a regular maintenance task on Sunday, the
database fails to open displaying the message that the data file belonging to the users
tablespace are corrupted.
The steps to recover the damaged data files are follows:
1. Mount the database
2. Open the database
3. Recover the data file
4. Restore the data file
5. Make the data file offline
6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files?
A. 2, 4, 3
B. 1, 4, 3, 2
C. 2, 5, 4, 3, 6
D. 5, 2, 4, 3, 6
E. 1, 5, 4, 3, 6, 2
Answer:
Answer:
Answer:
Answer: E
Section:
Section:
Section:
Section: Backup, Recovery & Recovery Manager (RMAN)
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Section:
Section:
Section:
Section: Backup, Recovery & Recovery Manager (RMAN)
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
http://ss64.com/ora/rman_recover.html
Steps
Steps
Steps
Steps for
for
for
for Media
Media
Media
Media Recovery:
Recovery:
Recovery:
Recovery:
1. Mount or open the database.
Mount the database when performing whole database recovery,
or open the database when performing online tablespace recovery.
2.
To
perform incomplete recovery,
use the SET UNTIL command to specify the time,
SCN, or log sequence number at which recovery terminates.
Alternatively, specify the UNTIL clause on the RESTORE and RECOVER
commands.
3. Restore the necessary files with the RESTORE command.
4. Recover the datafiles with the RECOVER command.
5. Place the database in its normal state.
For example, open it or bring recovered tablespaces online.
Restore
Restore
Restore
Restore and
and
and
and recover
recover
recover
recover a
a
a
a datafile
datafile
datafile
datafile
RMAN> SQL 'ALTER DATABASE DATAFILE 64 OFFLINE';
RMAN> RESTORE DATAFILE 64;
RMAN> RECOVER DATAFILE 64;
RMAN> SQL 'ALTER DATABASE DATAFILE 64 ONLINE';
QUESTION
QUESTION
QUESTION
QUESTION 3
3
3
3
You
want to perform an RMAN backup of database as a copy. Which two factors will you
consider while performing the backup operation? (Choose two).
A. The backup as copy can only be taken to disk
B. The backup as copy can only be taken to tape
C. Backup can be performed only when the instance is shutdown
D. Backup will constitute all used and unused blocks in the database
Answer:
Answer:
Answer:
Answer: AD
Section:
Section:
Section:
Section: Backup, Recovery & Recovery Manager (RMAN)
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Section:
Section:
Section:
Section: Backup, Recovery & Recovery Manager (RMAN)
QUESTION
QUESTION
QUESTION
QUESTION 4
4
4
4
In your database, the flash recovery area (FRA) is configured as the default for RMAN
backups.
You
executed the following commands to configure the settings in RMAN:
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT
'/home/oracle/disk1/%U';
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT
'/home/oracle/disk2/%U';
You
issue the following RMAN command to backup the database:
RMAN> RUN
2> {
3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk;
4> BACKUP DATABASE;
5> }
Which statement is true about the outcome?
A. Only one channel is allocated and the backup is created in the flash recovery area
B. Only one channel is allocated and the backup is created in the destination specified for channel 1
C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and
Answer:
Answer:
Answer:
Answer: A
Section:
Section:
Section:
Section: Backup, Recovery & Recovery Manager (RMAN)
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Section:
Section:
Section:
Section: Backup, Recovery & Recovery Manager (RMAN)
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
Explanation/Reference:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup004.htm#i1017890
Configuring
Configuring
Configuring
Configuring Disk
Disk
Disk
Disk Devices
Devices
Devices
Devices and
and
and
and Channels:
Channels:
Channels:
Channels:
RMAN channels
channels
channels
channels (connections to server sessions on the target database) perform all RMAN
tasks. By default, RMAN allocates one disk channel for all operations.
The following command configures RMAN to write disk backups to the
/backup
directory
(refer to "Backing Up Database Files and Archived Logs with RMAN").:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT
'/backup/ora_df%t_s%s_s%p';
The format specifier
%t
is replaced with a four byte time stamp,
%s
with the backup set
number, and %p with the backup piece number.
You
can also configure an Automatic Storage Management disk group as your destination, as
in the following example:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '+dgroup1';
QUESTION
QUESTION
QUESTION
QUESTION 5
5
5
5
You
are using recovery Manager (RMAN) with a recovery catalog to backup up your
production database. The backups and the archived redo log files are copied to a tape drive
on a daily basis. The database was open and transactions were recorded in the redo logs.
Because of fire in the building you lost your servers having the production database and the