OraFAQ Forum: Server Administration » Help!!!Recover datafile that has been drop offline

Home » RDBMS Server » Server Administration » Help!!!Recover datafile that has been drop offline

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

Help!!!Recover datafile that has been drop offline [message #59562]

Wed, 03 December 2003 22:43

OMEGA
Messages: 2
Registered: December 2003

Junior Member

If i execute the script:
alter database datafile '/erp/TEST/testdata/arx02.dbf' offline drop;
Can i recover this datafile?

Report message to a moderator

Re: Help!!!Recover datafile that has been drop offline [message #59564 is a reply to message #59562]

Thu, 04 December 2003 01:42

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

yes u can recover the datafile if u have valid backup of that file just take that tablespace into offline immediate mode which belongs to that dropped file
the restore the lost datafile and the recover the datafile with the help of recover datafile 'name of datafile'

Report message to a moderator

Re: Help!!!Recover datafile that has been drop offline [message #59571 is a reply to message #59562]

Thu, 04 December 2003 04:34

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

hi i think ur problem has been solved
there is alternative solution for this

if ur database is running in archive log mode and if u have not taken a backup of that file then do the following operation

execute the command

ALTER DATABASE CREATE DATAFILE 'NAME AND LOCATION OF DATAFILE' AS 'NAME AND LOCATION OF DATAFILE'

THEN RECOVER IN USUAL MANNER

Report message to a moderator

Re: Help!!!Recover datafile that has been drop offline [message #59575 is a reply to message #59564]

Thu, 04 December 2003 06:23

OMEGA
Messages: 2
Registered: December 2003

Junior Member

Hi,
Thanks for your response,i just shutdown all instances and use the fellowing comment:
$ sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 4 21:06:32 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> connect internal;
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1359875988 bytes
Fixed Size 73620 bytes
Variable Size 783208448 bytes
Database Buffers 573440000 bytes
Redo Buffers 3153920 bytes
Database mounted.
SQL> ALTER DATABASE CREATE DATAFILE '/erp/TEST/testdata/ard02.dbf' AS '/erp/TEST
/testdata/ard02.dbf';
ALTER DATABASE CREATE DATAFILE '/erp/TEST/testdata/ard02.dbf' AS '/erp/TEST/test
data/ard02.dbf'
*
ERROR at line 1:
ORA-01178: file 361 created before last CREATE CONTROLFILE, cannot recreate
ORA-01110: data file 361: '/erp/TEST/testdata/ard02.dbf'

it's seems need recreate control file,is it?

Report message to a moderator

Re: Help!!!Recover datafile that has been drop offline [message #59585 is a reply to message #59575]

Thu, 04 December 2003 23:07

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

first of all there was no need to shutdown the instance
u execute the alter command when ur databasewas running
so if u have a backup controlfile which u have taken then use that and recover the datbase

Report message to a moderator

Previous Topic:	ORA-27123
Next Topic:	Freespace in LMT's ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:18:34 CDT 2024