What is an online backup?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is an online backup?

Rating:

An online backup is a backup of one or more data files, which is taken while a database is open and the data files are online. Therefore, an online backup is inconsistent and requires recovery before it can be made consistent.

Before taking a user-managed online backup of data files, the tablespace containing the data files must be put in the backup mode by executing the ALTER TABLESPACE...BEGIN BACKUP; statement. When the backup is complete, the tablespace must be taken out of the backup mode by executing the ALTER TABLESPACE...END BACKUP; statement.

However, if the online backup is taken using the Recovery Manager (RMAN), the tablespace does not need to be put in the backup mode.


Rating:



Other articles

Click here to Article home

 
uCertify.com | Our Company | Articles | Privacy | Security | Contact Us | News and Press Release | uCertify India
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.