GeekInterview.com
  I am new, Sign me up!
 

Oracle Backup and Recovery Interview Questions


Oracle Backup and Recovery Interview Questions

Questions: 42
Comments: 171
 Oracle Backup and Recovery Tags
 Showing Questions 1-10 of 42 Questions
[1] 2 3 4 5 Next >>
 Sponsored Links

 
 Oracle Backup and Recovery Interview Questions
Sorting Options :  

Why more redos are generated when the database is in begin backup mode? 
Latest Answer: As soon as you issue SQL> Alter database begin backup;This command freezes the datafile headers as well as controlfile headers, but the headers of redolog files are free. Hence if any of the transaction is performed after the online backup command. ...
Read Answers (3) | Asked by : md.sarf

Why is the header of datafile and information of control file different at the time of inconsistant backup? 
Latest Answer: When we start datafile backup with begin backup command which will freeze the datafile headers and SCN cannot be updated only in controlfile SCN will update.  This process is till end backup. ...

Suppose you have two servers, one at 2nd floor and another on 3rd floor,If you have to configure the server on 3rd floor while sitting on 2nd floor how Will you do it? 
Latest Answer: If both are same domain, connect to ftp and ssh or scp / remote desktop connection/netmeetigs/vncserver. ...
Read Answers (2) | Asked by : harit79

How we you identify if a table was exported in its life time? 
Latest Answer: Refer cumulative or an incremental backup (export )we have a parameter (RECORD) & the default parameter is yes & is to track the incremental backup of a table so those backup (export) information will get update in the following sys ...

Is it possible to take backup of catalog database using RMAN? If Yes, How? 
Latest Answer: Yes, Schedule a Schema level Export backup of the RMAN Catalog Database in Task Scheduler or CRON Exporting the Recovery Catalog This example uses the Original Export utility described in Oracle Database Utilities to create a logical export of the recovery ...

What are the steps to creating a password authentication file? 
Latest Answer: There are two types of authenticationsOS levelDB levelFor OS level authentication:1. Shutdown the database2. Set OS_AUTHENT_PREFIX=' '    in init.ora file3.$ connect  '/ as sysdba'4. > startup5.> create user  ...
Read Answers (1) | Asked by : Archy

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery 
Latest Answer: In this situation you're not able to recover the database. Of course, it can be done by using nonsupported and nondocumented parameter "_ALLOW_RESETLOGS_CORRUPTED" but you HAVE NOT to use it without Oracle Support's suggestion If your ...

What is configure command? When do you use this? 
Latest Answer: show all; command at RMAN will show all configure command in default or update configuration mode ...

What is recovery catalog? Why do you need this? 
Latest Answer: When we specify Catalog - RMAN uses recovery catalog database to store RMAN metadata. ...

Detail script of backup using RMAN in both mode catalog and nocatalog  
Latest Answer: Full Backup in the sense taking up the whole database backup into a specific folder or a path but we cant take any jobs as backup and SQL Server logins also we cant take. ...
Read Answers (2) | Asked by : khadri4u
Tags : Backup

View page [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