GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Database  >  Database Admin
Go To First  |  Previous Question  |  Next Question 
 Database Admin  |  Question 47 of 69    Print  
How to use "ALTER DATABASE BEGIN BACKUP;" command in Oracle 9i.

  
Total Answers and Comments: 4 Last Update: October 06, 2009     Asked by: support dba 8910 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: senapati99
 
sql>alter tablespace <tablespace_name> begin backup;
copy all the datafile,redolog file,
from querying v$datafile,v$controlfile
after backing up end the command.
sql>alter tablespace <tablespace_name> end backup;
repeat this for all tablespaces

Above answer was rated as good by the following members:
madaninterview
December 17, 2007 23:53:21   #1  
senapati99 Member Since: December 2007   Contribution: 3    

RE: How to use "ALTER DATABASE BEGIN BACKUP;" command in Oracle 9i.
sql>alter tablespace <tablespace_name> begin backup;
copy all the datafile redolog file
from querying v$datafile v$controlfile
after backing up end the command.
sql>alter tablespace <tablespace_name> end backup;
repeat this for all tablespaces

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
May 20, 2008 08:07:30   #2  
dbashashi Member Since: July 2006   Contribution: 7    

RE: How to use "ALTER DATABASE BEGIN BACKUP;" command in Oracle 9i.

In oracle 9i we have some limitation with reqard to Backing up entire dataabase in one go. First we will have to take the database in mount stage (not open) in order to take the back up and that too one tablespace at a time.
like:-

sql>alter tablespace <tablespace_name> begin backup;

copy all the datafile
querying v$datafile v$controlfile

after backing up the said tablespace End the command as:

sql>alter tablespace <tablespace_name> end backup;


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 2Overall Rating: -2    
October 04, 2009 10:54:54   #3  
narendra05 Member Since: October 2009   Contribution: 3    

RE: How to use "ALTER DATABASE BEGIN BACKUP;" command in Oracle 9i.

We use alter database begin backup to copy datafile from one location to
another using host command copy / cp (based on environment).

The command is already posted

Alter tablespace < tablespace name >

Begin backup

Copy the datafile to another location

After copy alter tablespace < tablespace name >

End backup;

This would tell database that backup has complete its much simpler if the same
things are done using RMAN.


 
Is this answer useful? Yes | No
October 06, 2009 04:11:27   #4  
tykarthick Member Since: October 2009   Contribution: 9    

RE: How to use "ALTER DATABASE BEGIN BACKUP;" command in Oracle 9i.
Sql>alter database begin backup;

The above query is used to freeze the header of all datafiles belongs to tablespace in that particular database.
Freeze means lock i.e during backup no data's will be get in the datafiles.
To release the headers from freeze by using the following query

Sql>alter database end backup;

so the datas inserted during the backup is stored in database buffer cache after the end backup it will write.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
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