OraFAQ Forum: Backup & Recovery » To retrieve the dropped tables

Home » RDBMS Server » Backup & Recovery » To retrieve the dropped tables (11.2.0.2.5 , Solaris 10)

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

To retrieve the dropped tables [message #558319]

Wed, 20 June 2012 15:36

getzeeshan
Messages: 65
Registered: July 2008

Member

One of the developer dropped 18 tables by mistake on USER@db schema. Developer asked whether I can restore those tables, but unfortunately they are not in the recycle bin. Developer is re-creating the table now though. But I am just curious whether we need to change these parameters (db_recycle_cache_size) in order support any similar requests in the future.

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recycle_cache_size big integer 0
recyclebin string on

===================

Regards
Zee

Report message to a moderator

Re: To retrieve the dropped tables [message #558322 is a reply to message #558319]

Wed, 20 June 2012 15:47

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know the answer to your question.

However, by mistake, 18 tables? One table is dropped by mistake (Awww, shit!), but 18?!? That was diarrhea.

Report message to a moderator

Re: To retrieve the dropped tables [message #558323 is a reply to message #558322]

Wed, 20 June 2012 15:51

getzeeshan
Messages: 65
Registered: July 2008

Member

I know my friend its diarrhea but Im concerned about future such epidemic diseases

Im trying to find some preventive methods to work on it.

Report message to a moderator

Re: To retrieve the dropped tables [message #558326 is a reply to message #558323]

Wed, 20 June 2012 16:16

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Don't let sloppy developers close to your database. I hope it wasn't production system!

Anyway, I'd rather not maunder as - obviously - I don't have anything smart to say. Sorry for not being able to help; I'm sure someone else will, just be patient. Good luck!

Report message to a moderator

Re: To retrieve the dropped tables [message #558329 is a reply to message #558326]

Wed, 20 June 2012 17:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But I am just curious whether we need to change these parameters (db_recycle_cache_size) in order support any similar requests in the future.

Consider changing/replacing the duh-veloper instead

Report message to a moderator

Re: To retrieve the dropped tables [message #558330 is a reply to message #558329]

Wed, 20 June 2012 17:12

getzeeshan
Messages: 65
Registered: July 2008

Member

that could be a good option for replacing developer but my boss will replace me if I make such a suggestion, Im just curious if we have good information.

Report message to a moderator

Re: To retrieve the dropped tables [message #558340 is a reply to message #558319]

Thu, 21 June 2012 01:17

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

db_recycle_cache_size has nothing to do with recycle bin, it gives the size of the RECYCLE buffer pool.

If you want to activate recycle bin at instance level, just set "recyclebin" parameter to ON.
If you, despite this parameter set to ON, you don't find the dropped objects in the recycle bin it means Oracle lacks of space and then reuse the one in the recycle bin (just like your Windows PC does).

Regards
Michel

Report message to a moderator

Re: To retrieve the dropped tables [message #558378 is a reply to message #558340]

Thu, 21 June 2012 09:56

getzeeshan
Messages: 65
Registered: July 2008

Member

This makes a good answer.

Thanks! buddy.

--Zee

Report message to a moderator

Re: To retrieve the dropped tables [message #558388 is a reply to message #558340]

Thu, 21 June 2012 11:20

getzeeshan
Messages: 65
Registered: July 2008

Member

One more quick question how do we increase the size of the recyclebin and what factor determines the purging of objects from recyclebin is it something like LRU?

any idea?

--Zee

Report message to a moderator

Re: To retrieve the dropped tables [message #558389 is a reply to message #558388]

Thu, 21 June 2012 11:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.lmgtfy.com/?q=oracle+size+of+the+recyclebin

Report message to a moderator

Re: To retrieve the dropped tables [message #558393 is a reply to message #558388]

Thu, 21 June 2012 11:31

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

getzeeshan wrote on Thu, 21 June 2012 18:20

One more quick question how do we increase the size of the recyclebin and what factor determines the purging of objects from recyclebin is it something like LRU?

any idea?

--Zee

Like for your Windows PC there is NO actual size of recycle bin, recycle bin size is all space you do not use and need in your tablespaces.

Regards
Michel

Report message to a moderator

Previous Topic:	Moving from one Windows environment to another Linux environment
Next Topic:	Automating RMAN backup jobs in Windows (3 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 17:35:47 CDT 2024