-> You work as a database administrator at TestKing.com. Your database is open and
running in ARCHIVELOGmode. You take RMAN full backups every
Sunday night. On Monday morning, while querying the
user1.employeestable, you receive the following error
01578: ORACLE data block corrupted (file # 5, block # 51)
ORA-01110: data file 5:
You need to rectify the corruption while ensuring the following:
The data file should remain online.
The mean time to recover (MTTR) should be minimal.
You are not using a backup control file and all the archived logs are accessible.
Which option would you choose?
A. flash back the corrupted blocks
B. use the DBMS_REPAIR package
C. use the RMAN TSPITR command
D. use the RMAN BLOCKRECOVER command
E. use the RESTORE DATABASE and RECOVER DATABASE commands
F. investigate the time at which the corruption occurred and perform a point-in-time
Because RMAN BLOCKRECOVER can help recovery when Database online(no downtime) and to recover MTTR.
-> You are working on an Oracle Database 10g database. You enabled the Flashback
Database feature. Which two statements regarding flashback logs are true? (Choose
A. Flashback logs are not archived.
B. Flashback logs are maintained in redo log files.
C. Flashback logs are maintained in the Flash Recovery Area.
D. Flashback logs are used to maintain Flashback Database related errors.
E. Flashback logs need to be cleared manually after you disable Flashback Database.
Answer: A, C
A: Flashback logs aren't archived, B: Flashback log aren't maintained in redo log files, C: Flashback logs are maintained in the Flashback Recovery Area (db_recovery_file_dest), E: Flashback log clear auto after you disable Flashback Database
-> In your production database you want to use an Automatic Storage Management
(ASM) instance to manage the database files.
Which option would you use to migrate the database files from a non-ASM instance
to an ASM instance?
A. Oracle Migration Assistant
B. Recovery Manager (RMAN)
C. Oracle Data Pump Export and Import
D. conventional Oracle Export and Import
E. operating system utilities to copy the files to the ASM instance
RMAN is only solution migrate database file from non-ASM to ASM
-> Using Oracle Scheduler you have scheduled two jobs, JOB_Aand JOB_B, to
run at 9:00 p.m. every Friday. You want both the jobs to
use a single resource plan, WEEKEND_PLAN.
Which task must have already been performed to enable you to achieve this
A. A window must have been created with the WEEKEND_PLAN resource plan.
B. A program must have been created with the WEEKEND_PLAN resource plan.
C. A job class must have been created with the WEEKEND_PLAN resource plan.
D. A window group must have been created with the WEEKEND_PLAN resource plan.
windows have used resource plan
job class haven't used resource plan but use resource consumer group
-> You defined the Recovery Manager (RMAN) retention policy to recovery window of
7 days by executing the following command:
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7
When a backup is performed, what would be the status of this backup after seven
A. The backup would be marked as invalid.
B. The backup would be marked as obsolete.
C. The backup would be removed from the media.
D. The backup would be removed from the RMAN repository.
Because "RECOVERY WINDOW OF 7" status after 7 days was only obsolete.