Thanks Stephane for the update. Actually I cannot wait for long and looking for any goog advice and finally decided to do point in Time recovery and then with export and Import, the problen is been taken care. Actually I cannot shut down the Production Database and especially this database is around 300G with the Tablespace dropped is around 50 Gig.
Thanks Again
Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
http://www.prnewswire.com
(201) 946-5687 [W]
(201) 400-3960 [M]
"We tell your story to the world."
| "Stephane Faroult" <[EMAIL PROTECTED]>
06/02/03 03:37 AM
|
To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: RE: Very Urgent |
I fear there is not much you can do, short of restoring the backups you fortunately have. Dropping the tablespace invalidates many things, updates the control file, etc. I presume that the tablespace was dropped with the 'including contents' clause, which means that for Oracle the data in it simply no longer belongs to the database. A bit too late for generating what would have allowed you to plug the tablespace back into the database.
>----- ------- Original Message ------- -----
>From: :[EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Sent: Mon, 02 Jun 2003 03:19:38
>
>Please Reply Ur Suggestion at the earliest
>
>One of DBA had dropped the Wrong tablespace for the
>PArtitioned table. The
>Datafile exist on the system. How to recover the
>Tablespace as it contains
>crucial data. RMAN backup also available along with
>Archive as well as
>Correct timing of Dropping the Datafile
>
>
>Thanks
Regards,
Stephane Faroult
Oriole
