Oracle 8 - How to move Data files to a new device

[jorge_velasquez]

Hi Experts,

I want to move my Oracle 8 data files from my old directories to a new external device and then start SAP.

Operative system Windows NT.

Any clue?

Regards.

Edited by: jorge velasquez on Sep 16, 2011 10:46 AM

[Former Member]

Use alter database rename file command, We did it manually but you can try brtools as well.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/1e/5f863f06593a17e10000000a114084/content.htm

http://askanantha.blogspot.com/2008/02/running-out-of-space-want-to-move.html

/thread/2154172 [original link is broken]

• And I agree with Eric.

Thanks

Edited by: Database&SAP on Sep 16, 2011 8:59 PM

[jorge_velasquez]

Hi,

I watched the threats you posted, and are very helpful.

I moved the datafiles then If I want to move also the RedoLogs and Orilogs the commands are the same?

sqlplus /as sysdba

startup mount ;

alter database rename file 'd:\...\datafile1.dbf' to newlocation;

Regards

[former_member204746]

for mirrlog/origlog:

refer to http://download.oracle.com/docs/cd/B10500_01/server.920/a96521/onlineredo.htm#512

[jorge_velasquez]

Hi Eric,

It´s the same command as when moving Datafiles.

ALTER DATABASE

RENAME FILE '/diska/logs/log1a.rdo', '/diska/logs/log2a.rdo'

TO '/diskc/logs/log1c.rdo', '/diskc/logs/log2c.rdo';

The only issue could be when moving the control file, in this case I have to set control_file parameter in sqlplus and if are the same directories just startup, if not modify it with new directories and then alter database open;

Am I right?

[former_member204746]

you can take a backup control file and re-create it. everyone I know does this when doing a system copy... the same strategy should work to move this file. you also need to adapt SPFILE... or probably pfile as you are still using ORacle 8.

[former_member204746]

Hi,

you can use SAPDBA.

but Windows NT and Oracle 8 are out of support since many years.

also, moving datafiles to an external disk (USB) is not a good idea. You will find that USB drives are slower than internal drives.