No question at this time
DBA Top 10
1 M. Cadot 10800
2 B. Vroman 6500
3 A. Kavsek 5600
4 J. Schnackenberg 2600
5 P. Wisse 2200
5 J. PĂ©ran 2200
7 T. Boles 600
8 D. Dave 400
9 . Lauri 200
9 R. Rao Kulkarni 200
9 H. Bhangu 200
9 V. Gupta 200
9 A. Bourgeois 200
9 M. Jain 200
9 K. Pingeli 200
9 J. Baet 200
9 B. Jacobs 200
9 R. Pastre 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48605
Total active users1406
Act. users last 24h5
Act. users last hour0
Registered user hits last week164
Registered user hits last month694
Go up

Recover a table
Next thread: please help me to start oracledbconsole
Prev thread: OCR file lost

Message Score Author Date
Hi, Is it possible to recover a table using res...... Balaji M Oct 22, 2020, 11:36
No, at least there is no guarantee. Regards, Ph...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Oct 22, 2020, 12:14
Hi, in 12.1/12.2 you can use RMAN Table Point i...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Oct 22, 2020, 15:16
Hi Philip & Alex, Thanks for your answers. Phi...... Balaji M Oct 23, 2020, 14:51
Hi Balaji, There are several techniques to undo...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Oct 26, 2020, 11:26
Thank you... Balaji M Oct 27, 2020, 07:32

Follow up by mail Click here


Subject: Recover a table
Author: Balaji M, India
Date: Oct 22, 2020, 11:36, 201 days ago
Os info: Linux 6
Oracle info: Oracle 11.2,12..2
Message: Hi,

Is it possible to recover a table using restore point that was deleted a week ago.

Regards,
Balaji




Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover a table
Author: Philip Wisse, Netherlands
Date: Oct 22, 2020, 12:14, 201 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: No, at least there is no guarantee.

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover a table
Author: Ales Kavsek, Slovenia
Date: Oct 22, 2020, 15:16, 201 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,

in 12.1/12.2 you can use RMAN Table Point in time recovery, in 11g you have to do point in time recovery of database, then use exp/expdp to export table that you lost.

For >= 12c you can refer to Tim's article for RMAN Table point in time recovery:

https://oracle-base.com/articles/12c/rman-table-point-in-time-recovery-12cr1

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover a table
Author: Balaji M, India
Date: Oct 23, 2020, 14:51, 200 days ago
Message: Hi Philip & Alex,
Thanks for your answers.

Philip,
at least there is no guarantee.
If you don't mind,could you please rephrase this sentence.

Regards,
Balaji

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover a table
Author: Philip Wisse, Netherlands
Date: Oct 26, 2020, 11:26, 197 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Balaji,

There are several techniques to undo changes, mostly relying on the undo tablespace.

But a 'restore point' is different, it uses flashback logs which resembles archive logs.

You cannot guarantee undotable based undo but you can guaratee restore point based flashback.

HTH Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover a table
Author: Balaji M, India
Date: Oct 27, 2020, 07:32, 196 days ago
Message: Thank you
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here