Home » RDBMS Server » Backup & Recovery » Backup & Recovery (oracle 10g,windows2008)
icon5.gif   Backup & Recovery [message #524376] Fri, 23 September 2011 06:11 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
can we recover a dropped table from database as well as recyclebin.thanx in advance
Re: Backup & Recovery [message #524378 is a reply to message #524376] Fri, 23 September 2011 06:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes (if configuration and backup policy allow it).

Regards
Michel
Re: Backup & Recovery [message #524379 is a reply to message #524378] Fri, 23 September 2011 06:19 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
if we talk about of future then what all arrangements shuld be done since now?
Re: Backup & Recovery [message #524380 is a reply to message #524379] Fri, 23 September 2011 06:20 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
to recover a table which is wiped out from recycle bin
Re: Backup & Recovery [message #524382 is a reply to message #524380] Fri, 23 September 2011 06:47 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
how to recover a object which is dropped from db and also from recycle bin.if not now,then what shuld we done now to recover in future from this situation.
Re: Backup & Recovery [message #524383 is a reply to message #524382] Fri, 23 September 2011 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Advanced User's Guide
Chapter 19 Advanced User-Managed Recovery Scenarios
Section Recovering from a Dropped Table: Scenario

Regards
Michel

Re: Backup & Recovery [message #524414 is a reply to message #524383] Fri, 23 September 2011 09:52 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
i want to create new database,so what all strategies should i follow to recover all objects however which may be dropped from db as well as from recycle bin in my new database, at time of creation the database.i know that some settings are done at time of creation to recover tables and other objects if those are purged also from recycle bin accidently.thanx in advance.
Re: Backup & Recovery [message #524657 is a reply to message #524414] Mon, 26 September 2011 01:16 Go to previous messageGo to next message
Markwillium
Messages: 13
Registered: December 2010
Location: India
Junior Member
FlashBack is a feature introduced in Oracle9i and improved versions in Oracle10g. You can use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or application error. For details features click below link: http://www.cuddletech.com/articles/oracle/node65.html

If FlashBack & Backup fail to restore then you can also try 3rd party oracle database recovery software.
http://www.stellaroracledatabaserecovery.com/
Re: Backup & Recovery [message #524662 is a reply to message #524657] Mon, 26 September 2011 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
You can use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or application error

Not after a drop.

Regards
Michel
Re: Backup & Recovery [message #524688 is a reply to message #524662] Mon, 26 September 2011 03:42 Go to previous messageGo to next message
Markwillium
Messages: 13
Registered: December 2010
Location: India
Junior Member
Michel Cadot wrote on Mon, 26 September 2011 01:21

Not after a drop.

Regards
Michel

Hello Michel,

Thanx for correction but i have read this from here "Once Flashback is enabled and you have been granted permission to use it you could do something as important as "flashbacking" a dropped table, or something as minor as undoing your last SQL statements chnages to a table. You can even flash back an entire database to get back to an earlier point in time across the board!"

Source:http://www.cuddletech.com/articles/oracle/node65.html

Regards,
Markwillium
Re: Backup & Recovery [message #524693 is a reply to message #524688] Mon, 26 September 2011 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is FLASHBACK DATABASE, not FLASHBACK TABLE.

Regards
Michel
Re: Backup & Recovery [message #525432 is a reply to message #524693] Mon, 03 October 2011 01:45 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
please tell me that if a drop a table from db as well as from recycle bin then can i get my table back in my db,if it depends on cofiguration then tell me in details what configuration should i had to do,because i am going to make a new database.thanx
Re: Backup & Recovery [message #525441 is a reply to message #525432] Mon, 03 October 2011 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Already answered.
Read above.

Regards
Michel
Re: Backup & Recovery [message #526430 is a reply to message #525432] Tue, 11 October 2011 01:34 Go to previous message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
yes you can use point in time recovery also
by using this you can back your table also
and is your database in archive mode
and flash back database is on in your database
..
Previous Topic: RMAN BACKUP
Next Topic: block change tracking file - when it is used?
Goto Forum:
  


Current Time: Fri Mar 29 05:15:41 CDT 2024