OraFAQ Forum: Backup & Recovery » copy *.ORA and *.DBF to other places/disk-partition

Home » RDBMS Server » Backup & Recovery » copy *.ORA and *.DBF to other places/disk-partition

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

copy *.ORA and *.DBF to other places/disk-partition [message #111993]

Tue, 22 March 2005 05:21

Akira_2005
Messages: 2
Registered: March 2005

Junior Member

Dear All,

I created a database in C: drive but currently it's full so I'm copying the *.ORA and *.DBF file to D: drive.
I make those files to be offline and change the path in DBA Studio, when I try to make them online I got message :
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8:'D:\ORADATA\SERVER3\DEVMBS.ORA'

Is there any steps to do this properly ?

Appreciate your advices.....

Warmest Regards,

Akira

Report message to a moderator

Re: copy *.ORA and *.DBF to other places/disk-partition [message #112006 is a reply to message #111993]

Tue, 22 March 2005 06:49

smuth
Messages: 3
Registered: March 2005
Location: Bangkok, THAILAND

Junior Member

The old database file might be corrupt cause of out of disk space.

Regards,
-smuth

-----------
Smuth Nakpansua
Enterprise System Co.,Ltd.
smuth@enterprise-system.com

Report message to a moderator

Re: copy *.ORA and *.DBF to other places/disk-partition [message #112020 is a reply to message #111993]

Tue, 22 March 2005 08:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You need to rename the datafiles using alter tablespace rename datafile command.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dfiles.htm#7558

Report message to a moderator

Re: copy *.ORA and *.DBF to other places/disk-partition [message #112091 is a reply to message #112020]

Tue, 22 March 2005 20:55

Akira_2005
Messages: 2
Registered: March 2005

Junior Member

I have done that command, the steps were :
1. Turn offline the tablespace
2. Run Rename datafile command
3. Try to turn online again ----> here where the error message came from.

I'll try again later, thanx for your advice

Warmest Regards,

Akira

Report message to a moderator

Re: copy *.ORA and *.DBF to other places/disk-partition [message #112129 is a reply to message #111993]

Wed, 23 March 2005 03:04

jzdzg
Messages: 4
Registered: March 2005

Junior Member

how about issue ' recover database ' in sql plus ?you can try it,and reply here.

Report message to a moderator

Previous Topic:	Import & export
Next Topic:	export on linux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 22:18:53 CST 2024