Re: Best way to rebuild a database

        Have you considered moving the datafiles and then using ALTER TABLESPACE RENAME DATAFILE?         Make a good backup of your control file.

	Bring up Oracle in a window and ALTER TABLESPACE OFFLINE.
	In a 2nd window use the Unix cp command to move  the datafiles for 
the tablespace.
	Back to the Oracle window and rename the datafiles 
	ALTER TABLESPACE ONLINE.

	Repeat for each tablespace.

	You could also create a script to do the job.


	Since you will have a backup of the controlfile and haven't disturbed 
the original 
	datafiles this is a safe approach and should be fairly quick.

	

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 7/12/00, 6:17:25 PM, "Jake Hsien" <jhsien_at_viva.com> wrote regarding Best way to rebuild a database:

> We're running Oracle 8.1.5 and Veritas Volume Manager on Solaris 2.7
 in a
> cluster on two E3500s. The volume manager took a dump last night and
> remapped all of the volumes to one spare disk that we had. Therefore

Oracle
> is on one large volume right now and as you can imagine the I/O is
 very
> intensive. We will have to reformat and re-strip the disk arrays to
 spread
> Oracle's datafiles. What would be the best way to keep our current
 data,
> should we do a full database export, or a full schema export since all
 

of
> the production objects belong to one schema. Any better suggestions
 out
> there?
Received on Thu Jul 13 2000 - 00:00:00 CDT