No question at this time
DBA Top 10
1 M. Cadot 11600
2 B. Vroman 6400
3 A. Kavsek 6000
4 P. Wisse 3400
5 J. Schnackenberg 3200
6 J. PĂ©ran 1800
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48560
Total active users1401
Act. users last 24h3
Act. users last hour0
Registered user hits last week152
Registered user hits last month875
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, 37 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, 37 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, 37 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, 36 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, 33 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, 33 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