GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

Oracle Backup and Recovery Interview Questions


Oracle Backup and Recovery Interview Questions

Questions: 37
Comments: 142
 Oracle Backup and Recovery Tags
 Showing Questions 31-37 of 37 Questions
<< Previous 1 2 3 [4] 
 Sponsored Links

 
 Oracle Backup and Recovery Interview Questions
Sorting Options :  

A   Partial  Backup  is any operating system backup short of a full backup, taken while the database is open or shut down. 
Latest Answer: A partial backup is an operating system backup of part of a database. The backup of an individual tablespace's datafiles or the backup of a control file are examples of partial backups. Partial backups are useful only when the database is in ARCHIVELOG ...
Tags : Backup

The On-line Redo Log is a set of tow or more on-line redo files that record all committed  changes  made  to  the  database. Whenever a transaction is committed,  the  
Latest Answer: Redo logs records all the changes to the database  whether commited or uncommited. How does it know whether you are committing or rolling back till you commit it. Oracle always thinks positively that everything is going to be commited and writes to the ...

A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members. 
Latest Answer: mirrored redologfile is the same copy of redologfile,when lgwr writes in the redologfile the same will be in the mirrored redofile.it is useful when original redo is corrupt database  can recover from mirrored redologfile. ...

Archived  Redo  Log  consists  of Redo Log files that have         archived before being reused. 
Latest Answer: Answer:  The archived redo log  consists of archived redo logfile copies that have archived before being reused. ...

What  are  the  advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
Complete database recovery from disk failure is possible only in ARCHIVELOG mode.Online database backup is possible only in ARCHIVELOG     mode. 

The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch. 
Latest Answer: log switch occurs when current redo logfile gets full and lgwr writes redo to next redo logfile.Even we can perform log switch with the command alsobefore we execute the sql execute following statementSQL> select status from v$log;STATUS----------------UNUSEDUNUSEDCURRENT------>active ...

Rolling forward to recover data that has not been recorded in data files, yet  has  been recorded  in the on-line redo log, including the contents of rollback segments. Rolling back 
Latest Answer: Steps involve in recovery1.Restore backup datafiles2.Recover using Archive log files 3.apply partial backup 4.recover using redo log files ...

View page << Previous 1 2 3 [4] 

Ask A Question
Go Top
 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
Sponsored Links

 
Free White Papers & Software


Vulnerability Management
for Dummies eBook

 


 

Request Your Copy
 



Free: 60-Day Trial
Microsoft Office Project

 


 

Request Now
 



The 7 Things that
IT Security Professionals
MUST KNOW!

 


 

Request Your Free eBook

 
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape