OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » recovery Senario

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

recovery Senario [message #252785]

Fri, 20 July 2007 00:15

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

Report message to a moderator

Re: recovery Senario [message #252802 is a reply to message #252785]

Fri, 20 July 2007 01:10

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: recovery Senario [message #252822 is a reply to message #252802]

Fri, 20 July 2007 02:53

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

Report message to a moderator

Re: recovery Senario [message #252824 is a reply to message #252822]

Fri, 20 July 2007 03:03

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: recovery Senario [message #252849 is a reply to message #252824]

Fri, 20 July 2007 05:16

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.

Report message to a moderator

Re: recovery Senario [message #252850 is a reply to message #252849]

Fri, 20 July 2007 05:25

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?

Report message to a moderator