-
Hi Guru's ,
Here is my problem ..One of my disk crashed . It got one datafile trans.dbf . I can't startup my database ..since it is missing . How can I recreate the file . We don't need the objects in that file . We don't have real production objects in that tablespace . This tablespace trans got only one datafile trans.dbf . I know it is my bad management that I don't have backup for this datafile . Can you help to recover my database.
Raghu
-
start the database with mount
take the missing datafile offline
open the database
-
Thanks for the reply . Can you pass the correct syntax to move the datafile offline;
I am trying
alter database datafile ' ' offline;
I am getting error ..nonexistent logfile,datafile,control file
Raghu
-
alter database datafile ' / / /tbspace1.dbf' offline
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
offline/online work if you are in archivelog mode. Otherwise, you receive ORA-01145 error: offline immediate disallowed unless media recovery enabled. I don't believe raghud is in archivelog mode - is that correct?
-
specify the missing datafile with full path
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
raghud,
Perform an offline drop of the datafile(s) associated with that datafile and tablespace...
Start the instance
mount the controlfiles
alter database datafile 'fully qualified datafile name' offline drop;
open database
-
many thanks for the reply .
now I am getting error 'offline immediate disallowed unless media recovery enabled' ...
Raghu
-
alter database datafile 'fully qualified datafile name' offline drop;
getting nonexistent datafile,logfile and tempfile
Raghu
-
yes true ..It is my another biggest mistake I am not running on archievelog mode ..
Raghu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|