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

GeekInterview.com  >  Interview Questions  >  Oracle  >  Backup and Recovery
Go To First  |  Previous Question  |  Next Question 
 Backup and Recovery  |  Question 6 of 37    Print  
Can Full Backup be performed when the database is open ?
No.



  
Total Answers and Comments: 10 Last Update: April 24, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
September 27, 2005 05:17:54   #1  
todearmurali Member Since: September 2005   Contribution: 5    

RE: Can Full Backup be performed when the d...
full backup can be taken with the interaction of oracle where we keep the tablespaces in begin backup mode and the respective datafiles are taken at os.finallt controlfile is taken backup .After that logfile switch should be force for recovery purpose.
 
Is this answer useful? Yes | No
October 11, 2005 11:25:13   #2  
Murugesh.V.Raja        

RE: Can Full Backup be performed when the d...
When the database in ARCHIVE LOG mode
 
Is this answer useful? Yes | No
November 20, 2005 04:51:56   #3  
Srinivas_vemali Member Since: November 2005   Contribution: 1    

RE: Can Full Backup be performed when the d...
Back can be performed. But, it's a hot backup. Database needs to be in Archivemode.
 
Is this answer useful? Yes | No
January 20, 2006 10:42:19   #4  
devesh        

RE: Can Full Backup be performed when the d...

Yes, by using the Rman you have to take full backup when database is opened. But it is not a synchronized backup because its a hot backup.

I have recomended to you go for cold backup.


 
Is this answer useful? Yes | No
February 21, 2006 03:18:34   #5  
rajat dey        

RE: Can Full Backup be performed when the d...
Yes , we can take full backup but this is not advisable it will degrade your performace if your database transaction is more .But using RMAN utility of oracle you can take which is more flexible than traditional full backup (it nothing but online backup ). regrdsrajat dey
 
Is this answer useful? Yes | No
June 06, 2006 06:59:35   #6  
jatinder        

RE: Can Full Backup be performed when the d...
ues we can tabke full backup while database is open. By using hot backup. Tabe backup of all tablespaces using hotback. and take backup on control file useing alter database backup controlfile to trace;and then take backup of pfile using: create pfile from spfile;In this way Full backup can be performed when the database is open;
 
Is this answer useful? Yes | No
March 30, 2007 18:04:19   #7  
Chiranjeevi Manne        

RE: Can Full Backup be performed when the d...
Yes, it is possible only when the database is in Archivelog Mode.
 
Is this answer useful? Yes | No
September 20, 2007 00:58:17   #8  
Mohammed Abdul Afroze        

RE: Can Full Backup be performed when the d...
If the database is in Noarchivelog mode, then it is not possible to take the close backup.

If the database is in Archivelog mode, then it can be taken as Open Backup.

 
Is this answer useful? Yes | No
October 27, 2007 22:13:03   #9  
satyam_2007 Member Since: October 2007   Contribution: 5    

Can Full Backup be performed when the d...
Online backup can be whole and partial, be full and incremental, and be carried out with RMAN or with the operating system commands. But they can only be done if the database is in archivelog mode.

A datafile that is backed up online will not be synchronized with any particlular SCN, nor it is synchronized with the other datafiles or the control files. It is backed up while it is in use: being read from by server processes, and written by DBWn.

 
Is this answer useful? Yes | No
April 24, 2008 22:35:47   #10  
sanjayoracle Member Since: April 2008   Contribution: 4    

RE: Can Full Backup be performed when the database is open ?
NO, we can't. cuz Full Backup means consistent backup and we can take this backup only when our database is close.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




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