Home » RDBMS Server » Backup & Recovery » To retrieve the dropped tables (11.2.0.2.5 , Solaris 10)
To retrieve the dropped tables [message #558319] Wed, 20 June 2012 15:36 Go to next message
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
Re: To retrieve the dropped tables [message #558322 is a reply to message #558319] Wed, 20 June 2012 15:47 Go to previous messageGo to next message
Littlefoot
Messages: 19340
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.
Re: To retrieve the dropped tables [message #558323 is a reply to message #558322] Wed, 20 June 2012 15:51 Go to previous messageGo to next message
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.
Re: To retrieve the dropped tables [message #558326 is a reply to message #558323] Wed, 20 June 2012 16:16 Go to previous messageGo to next message
Littlefoot
Messages: 19340
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!
Re: To retrieve the dropped tables [message #558329 is a reply to message #558326] Wed, 20 June 2012 17:04 Go to previous messageGo to next message
BlackSwan
Messages: 22543
Registered: January 2009
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
Re: To retrieve the dropped tables [message #558330 is a reply to message #558329] Wed, 20 June 2012 17:12 Go to previous messageGo to next message
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.
Re: To retrieve the dropped tables [message #558340 is a reply to message #558319] Thu, 21 June 2012 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 58633
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
Re: To retrieve the dropped tables [message #558378 is a reply to message #558340] Thu, 21 June 2012 09:56 Go to previous messageGo to next message
getzeeshan
Messages: 65
Registered: July 2008
Member
This makes a good answer.

Thanks! buddy.

--Zee
Re: To retrieve the dropped tables [message #558388 is a reply to message #558340] Thu, 21 June 2012 11:20 Go to previous messageGo to next message
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
Re: To retrieve the dropped tables [message #558389 is a reply to message #558388] Thu, 21 June 2012 11:22 Go to previous messageGo to next message
BlackSwan
Messages: 22543
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=oracle+size+of+the+recyclebin
Re: To retrieve the dropped tables [message #558393 is a reply to message #558388] Thu, 21 June 2012 11:31 Go to previous message
Michel Cadot
Messages: 58633
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
Previous Topic: Moving from one Windows environment to another Linux environment
Next Topic: Automating RMAN backup jobs in Windows (3 Merged)
Goto Forum:
  


Current Time: Thu Jul 31 11:29:55 CDT 2014

Total time taken to generate the page: 0.09605 seconds