Re: Moving database-, control- and logfiles

SPHINX_at_TERRA-I.rhein-ruhr.de schrieb am 15.06.95 um 08:09 unter "Moving database-, control- and logfiles" :

> Now my question: Which is the easiest way to move all the database-files
> to other locations?

Hoi folx,

i got some answers to my question. Here's now the right procedure:

For database and redolog-files:

1. shutdown
2. startup mount
3. copy the files to the new location (os command)
4. alter database rename file '<old_filename>' to '<new_filename>'
5. alter database open
6. after you verified that all is o.k. you can delete the old files.

For control-files:

1. shutdown
2. copy the files to the new location (os command)
3. change the section "control-file" in the init<sid>.ora file
4. startup
5. after you verified that the database is happy you can delete the old files.

Thanx to all for their hints.

Patrick.

E-Mail: SPHINX_at_TERRA-I.rhein-ruhr.de

• Origin: 95 mph? WARP! ## CrossPoint v3.02 ##