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