Home » RDBMS Server » Backup & Recovery » recovery Senario
icon14.gif  recovery Senario [message #252785] Fri, 20 July 2007 00:15 Go to next message
vgyanchandani
Messages: 5
Registered: May 2007
Location: block no A/276 Room No. 5...
Junior Member
Hello Everybody
Senario:
I have one database.
I take regular cold backup in night.
The database is in archvielog mode
One morining I have created one tablespace named xyz with one datafile autoextend on extent management local
I have created one user and assigned that tablespace to him.
That user created some tables and I have also created one table in that tablespaces.
Tabelspace was created nearly at 10:00 AM
but by mistake I have dropped that tablespace xyz using command:
drop tablespace including contents and datafiles nearly at 4:00 PM on that same day when tablespace was created. Now I want to recover this tablespace along with datafile if possible or atleast I want data in that tablespaces.
Now , I am having in my hand is One cold backup taken last night and database in archive log mode and also I have set SQL_TRACE=true,TIMED_STATISTIC=on
Re: recovery Senario [message #252802 is a reply to message #252785] Fri, 20 July 2007 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
SQL_TRACE=true

This is irrelevant and a bad practice. Do you want to trace each and every session?

There is a scenario in backup and recovery book that explains how to handle such a case. Have a look at it.

Regards
Michel
Re: recovery Senario [message #252822 is a reply to message #252802] Fri, 20 July 2007 02:53 Go to previous messageGo to next message
vgyanchandani
Messages: 5
Registered: May 2007
Location: block no A/276 Room No. 5...
Junior Member
No I don't want to trace the query
I need Tablespace xyz and it's contents backup
Re: recovery Senario [message #252824 is a reply to message #252822] Fri, 20 July 2007 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
There is a scenario in backup and recovery book that explains how to handle such a case. Have a look at it.

There is one to recover the database at the time of drop tablespace.
There is one to recover data using an auxiliary database.

Regards
Michel
Re: recovery Senario [message #252849 is a reply to message #252824] Fri, 20 July 2007 05:16 Go to previous messageGo to next message
vgyanchandani
Messages: 5
Registered: May 2007
Location: block no A/276 Room No. 5...
Junior Member
I have gone through that,There is no such case in oracle books.
I am telling scenario again
I takes a cold backup in night
Next day I created one tablespace containig one datafile in the morning at 10:00 AM
I have allocated this tablespace to a user
User have created some tables on that
I(sysdba) also created one table on that tablespace.
Accidentally, I have drop that tablespace in the evening roughly at 04:00 PM.
Now I want this tablespace along with its content back
My question is can i get backup my tablespace and data.
Re: recovery Senario [message #252850 is a reply to message #252849] Fri, 20 July 2007 05:25 Go to previous messageGo to next message
vgyanchandani
Messages: 5
Registered: May 2007
Location: block no A/276 Room No. 5...
Junior Member
and also I dont have any other backup except cold backup that I have taken last night . But I am having database in archive log mode. Even I don't have standby database.
But I still want my tablespace backup can I?
Re: recovery Senario [message #252858 is a reply to message #252785] Fri, 20 July 2007 07:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Sure it's in the docs, it's called Tablespace Point in Time Recovey (TSPITR).
Re: recovery Senario [message #252877 is a reply to message #252850] Fri, 20 July 2007 08:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
can I?

Yes, you can.

Regards
Michel
Re: recovery Senario [message #253150 is a reply to message #252785] Sun, 22 July 2007 23:58 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
hi,

try this...
Recover database until time 'dd/mm/yyy:hh24:mi:ss' using backup controlfile
Re: recovery Senario [message #253255 is a reply to message #253150] Mon, 23 July 2007 05:14 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
navaneethdba wrote on Mon, 23 July 2007 00:58

Recover database until time 'dd/mm/yyy:hh24:mi:ss' using backup controlfile


Don't think the OP would want to roll the WHOLE database back for ONE tablespace??
Previous Topic: Duplicate DB on another host using different paths
Next Topic: ORA-01180 & ORA-01110 errors with incremental level 0 backup
Goto Forum:
  


Current Time: Tue Dec 06 16:07:33 CST 2016

Total time taken to generate the page: 0.10465 seconds