GeekInterview.com
  I am new, Sign me up!
 

RMAN Interview Questions


RMAN Interview Questions

Questions: 49
Comments: 47
 Showing Questions 11-20 of 49 Questions
<< Previous 1 [2] 3 4 5 Next >>
 Sponsored Links

 
 RMAN Interview Questions
Sorting Options :  

Outline the steps for changing the DBID in a cloned environment? 

What is the significance of incarnation and DBID in the RMAN backups? 
Latest Answer: When you have multiple databases you have to set your DBID (Database Id), which is unique to each database. You have to set this before you do any restore operation from RMAN.There is possibility that incarnation may be different of your database. So ...

List atleast 6 advantages of RMAN backups compare to traditional hot backups? 
Latest Answer: RMAN has the following advantages over Traditional backups:1. Ability to perform INCREMENTAL backups2. Ability to Recover one block of datafile3. Ability to automatically backup CONTROLFILE and SPFILE4. Ability to delete the older ARCHIVE REDOLOG files, ...

How do you identify the expired, active, obsolete backups? Which RMAN command you use? 
Latest Answer: You can check by using following commandExpired Backup: List ExpiredThen use report obsolete command, it show the backup that you dont need it and after that use Delete obsolete command,It will delete the backup that you dont need it. ...

How do you enable the autobackup for the controlfile using RMAN? 
Latest Answer: issue command at rman prompt.....    RMAN> configure controlfile autobackup on;also we can configure controlfile backup format......   RMAN> configure controlfile autobackup format for device type disk to    ...

How do you identify what are the all the target databases that are being backed-up with RMAN database? 
Latest Answer: You dont have any view to identifiy whether it is backed up or not . The only option is connect to the target database and give list backup, this will give you the backup information with date and timining. ...

What is the difference between cumulative incremental and differential incremental backups? 
Latest Answer: Differencial backup: This is the default type of incremental backup which backs up all blocks changed after the most recent backup at level n or lower.Cumulative backup: Backup all blocks cahnged after the most recent backup at level n-1 or lower. ...

Explain how to setup the physical stand by database with RMAN? 
Latest Answer: $ Export ORACLE_SID=TEST $ rman target / RMAN> show all;  Using target database controlfile instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS; CONFIGURE BACKUP OPTIMIZATION ...

List the steps required to enable the RMAN backup for a target database? 
Latest Answer: 1. $ rman target / 2. Configure the persistent parameter of RMAN eg :   RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS; old RMAN configuration parameters: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS; new RMAN ...

How do you verify the integrity of the image copy in RMAN environment? 

View page << Previous 1 [2] 3 4 5 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape