Some oracle DBA questions – Part 1

What are things which play major role in designing the backup strategy?
What are RTO, MTBF, and MTTR?
What are the various tape backup solutions available in the market?
What is RAID? What is RAID0? What is RAID1? What is RAID 10?
What is the difference between physical and logical backups?
What is hot backup and what is cold backup?
When do you recommend hot backup? What are the pre-reqs?
How do you generate the begin backup script?
Give me the steps for recovering the full database from cold backup?
Give me the steps for TIME based recovery from the full database from hot backup. ?
Give me the steps for SCN based recovery from the full database from hot backup. ?
Give me the steps for CANCEL based recovery from the full database from hot backup. ?
Give me the steps for recovery with missing archived redo logs?
Give me the steps for recovery with missing online redo logs?
Give me the steps for recovery of missing data file?
Give me the steps for physical standby database creation?
What is db_recovery_file_dest ? When do you need to set this value ?
Give me the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db ?
Tell me about the steps required to enable the RMAN backup for a target database ?
What is the difference between obsolete RMAN backups and expired RMAN backups ?
What is recovery catalog ? Why do you need this ?
How do you install the RMAN recovery catalog ?
Can you skip specific tables when using RMAN DUPLICATE feature ?
How do you clone the database using RMAN software ? Give me the brief steps ? when do you use crosscheck command ?
How do you setup the RMAN tape backups ?
How do you identify the expired,active,obsolete backups ? Which RMAN command you use ?
What is channel ? How do you enable the parallel backups with RMAN ?
What is auxiliary channel in RMAN? When do you need this ?
How do you identify what are the all the target databases that are being backed-up with RMAN database ?
Give me some of the RMAN catalog view names which contains the catalog information ?
What is oracle wallet ? Tell me about the encryption options available with RMAN ?
List advantages of RMAN backups compare to traditional hot backups ?
How do you identify the block corruption in RMAN database ? How do you fix this ?
How do you verify the integrity of the image copy in RMAN environment ?
How do you enable the encryption for RMAN backups ?
What is backup set ?
What is the difference between cumulative incremental and differential incremental backups ?
How do you enable the autobackup for the controlfile using RMAN ?
What is configure command ? When do you use this ?
Give me the steps for setting up the physical stand by database with RMAN ?
Give me the steps for changing the DBID in a cloned environment ?
What is the significance of incarnation and DBID in the RMAN backups ?

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: