No question at this time
DBA Top 10
1 M. Cadot 5800
2 B. Vroman 3800
3 J. PĂ©ran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 800
6 D. Johnson 700
7 T. Boles 600
8 D. Walgude 400
9 J. Alcroft 200
9 S. Spb 200
9 P. Wisse 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48667
Total active users1334
Act. users last 24h0
Act. users last hour1
Registered user hits last week21
Registered user hits last month191
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, 578 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, 578 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, 577 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, 576 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, 574 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, 573 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