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

GeekInterview.com > Interview Questions > Database > Database Admin

Print |

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

December 12, 2007 23:53:21	#1
senapati99	Member Since: December 2007 Total Comments: 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