OraFAQ Forum: Backup & Recovery » Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Backup & Recovery (oracle 10g,windows2008)

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

Backup & Recovery [message #524376]

Fri, 23 September 2011 06:11

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

Report message to a moderator

Re: Backup & Recovery [message #524378 is a reply to message #524376]

Fri, 23 September 2011 06:14

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

Senior Member
Account Moderator

Yes (if configuration and backup policy allow it).

Regards
Michel

Report message to a moderator

Re: Backup & Recovery [message #524379 is a reply to message #524378]

Fri, 23 September 2011 06:19

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?

Report message to a moderator

Re: Backup & Recovery [message #524380 is a reply to message #524379]

Fri, 23 September 2011 06:20

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

to recover a table which is wiped out from recycle bin

Report message to a moderator

Re: Backup & Recovery [message #524382 is a reply to message #524380]

Fri, 23 September 2011 06:47

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.

Report message to a moderator

Re: Backup & Recovery [message #524383 is a reply to message #524382]

Fri, 23 September 2011 06:52

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

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

Report message to a moderator

Re: Backup & Recovery [message #524414 is a reply to message #524383]

Fri, 23 September 2011 09:52

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.

Report message to a moderator

Re: Backup & Recovery [message #524657 is a reply to message #524414]

Mon, 26 September 2011 01:16

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/

Report message to a moderator

Re: Backup & Recovery [message #524662 is a reply to message #524657]

Mon, 26 September 2011 01:21

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

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

Report message to a moderator

Re: Backup & Recovery [message #524688 is a reply to message #524662]

Mon, 26 September 2011 03:42

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

Report message to a moderator

Re: Backup & Recovery [message #524693 is a reply to message #524688]

Mon, 26 September 2011 03:51

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

Senior Member
Account Moderator

This is FLASHBACK DATABASE, not FLASHBACK TABLE.

Regards
Michel

Report message to a moderator

Re: Backup & Recovery [message #525432 is a reply to message #524693]

Mon, 03 October 2011 01:45

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

Report message to a moderator

Re: Backup & Recovery [message #525441 is a reply to message #525432]

Mon, 03 October 2011 02:44

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

Senior Member
Account Moderator

Already answered.
Read above.

Regards
Michel

Report message to a moderator

Re: Backup & Recovery [message #526430 is a reply to message #525432]

Tue, 11 October 2011 01:34

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
..

Report message to a moderator

Previous Topic:	RMAN BACKUP
Next Topic:	block change tracking file - when it is used?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 10:20:17 CST 2024