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  >  Database  >  Database Admin

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



May 05, 2008 08:07:30 #2
 dbashashi   Member Since: July 2006    Total Comments: 3 

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;

     

 

Back To Question