Home » RDBMS Server » Backup & Recovery » recovery Of the database when a data file of undo table-space is deleted (merged 3) (oracle 9i(9.2.0), os- linux (RHEL3))
recovery Of the database when a data file of undo table-space is deleted (merged 3) [message #422380] Wed, 16 September 2009 00:04 Go to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
Hi,
My database is up and during a transaction data file of undo tablespace is deleted.
what is the effect of data file deletion on the database?
so how i can recover the database.
please send me steps to recover the database and effect of data file deletion on database.

please help someone on urgent basis.

thanks
Surya Kant Nirala
Re: recovery Of the database when a data file of undo table-space is deleted [message #422382 is a reply to message #422380] Wed, 16 September 2009 00:07 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
>please help someone on urgent basis.
Please explain why it is urgent for me to solve this problem for you now.

Take a HOT backup & do NOT shutdown database.
recovery Of the database when a data file of undo table-space is deleted [message #422383 is a reply to message #422380] Wed, 16 September 2009 00:10 Go to previous messageGo to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
Hi,
My database is up and during a transaction data file of undo tablespace is deleted.
what is the effect of data file deletion on the database?
so how i can recover the database.
please send me steps to recover the database and effect of data file deletion on database.

please help someone on urgent basis.

thanks
Surya Kant Nirala
Re: recovery Of the database when a data file of undo table-space is deleted [message #422384 is a reply to message #422383] Wed, 16 September 2009 00:13 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
>please help someone on urgent basis.
Stop spamming this forum!
recovery Of the database when a data file of undo table-space is deleted [message #422385 is a reply to message #422380] Wed, 16 September 2009 00:14 Go to previous messageGo to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
Hi,
My database is up and during a transaction data file of undo tablespace is deleted.
what is the effect of data file deletion on the database?
so how i can recover the database.
please send me steps to recover the database and effect of data file deletion on database.

please help someone on urgent basis.

thanks
Surya Kant Nirala
Re: recovery Of the database when a data file of undo table-space is deleted [message #422386 is a reply to message #422385] Wed, 16 September 2009 00:17 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
suryakantnirala wrote on Tue, 15 September 2009 22:14
Hi,
My database is up and during a transaction data file of undo tablespace is deleted.
what is the effect of data file deletion on the database?
so how i can recover the database.
please send me steps to recover the database and effect of data file deletion on database.

please help someone on urgent basis.

thanks
Surya Kant Nirala


>(oracle 9i(9.2.0), os- linux (RHEL3))
Both are obsoleted & you should join them!
Re: recovery Of the database when a data file of undo table-space is deleted (merged 3) [message #422388 is a reply to message #422380] Wed, 16 September 2009 00:38 Go to previous messageGo to next message
Michel Cadot
Messages: 59131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
so how i can recover the database.

How do you backup it?

Regards
Michel
Re: recovery Of the database when a data file of undo table-space is deleted (merged 3) [message #422391 is a reply to message #422380] Wed, 16 September 2009 00:46 Go to previous messageGo to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
database is in archivelog mode and i have 10 days earlier cold backup.
Also tell me the effect of data file deletion (of undo tablespace) on database because at the time of deletion database is up and use proceed his transaction.
Re: recovery Of the database when a data file of undo table-space is deleted (merged 3) [message #422392 is a reply to message #422380] Wed, 16 September 2009 00:55 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
Partially I am curious how/why you noticed undo got deleted?
With Linux & open files, "deleted" files only go missing after they are actually closed.
So while DB is open, life continues.
Take HOT backup, As Soon As Possible NOW!
Re: recovery Of the database when a data file of undo table-space is deleted (merged 3) [message #422395 is a reply to message #422380] Wed, 16 September 2009 01:14 Go to previous message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
I got your point.
Thanks for helping me.
Previous Topic: Unable to register database in recovery catalog in RMAN
Next Topic: duplicate database for standby fails
Goto Forum:
  


Current Time: Thu Sep 18 13:25:02 CDT 2014

Total time taken to generate the page: 0.10346 seconds