No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 9400
3 B. Vroman 4800
4 P. Wisse 4300
5 J. Schnackenberg 2900
6 J. PĂ©ran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48524
Total active users1409
Act. users last 24h3
Act. users last hour0
Registered user hits last week77
Registered user hits last month415
Go up

restore possibilities - until time before backup end
Next thread: restore question
Prev thread: restore fails

Message Score Author Date
Hi, let's suppose that I start a full backup on M...... Alain Bourgeois Jun 18, 2020, 10:35
Hi Alain, while there might be szenarios (invol...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Jan Schnackenberg Jun 18, 2020, 12:01

Follow up by mail Click here


Subject: restore possibilities - until time before backup end
Author: Alain Bourgeois, Belgium
Date: Jun 18, 2020, 10:35, 50 days ago
Os info: oracle linux 6
Oracle info: 11.2.0.4 / 12.2.0.1
Message: Hi,
let's suppose that I start a full backup on Monday that finishes correctly Wednesday, then delete obsolete.
All other backups are removed as I keep only one backup. I have archivelogs from Monday.

On Friday, is it possible, using this backup, to do a "restore until time" Tuesday 4pm? Or PITR can only be done at a time after the end of the backup used.

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

Subject: Re: restore possibilities - until time before backup end
Author: Jan Schnackenberg, Germany
Date: Jun 18, 2020, 12:01, 50 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Alain,

while there might be szenarios (involving READ ONLY tablespaces, etc) where a PITR to a time before the end of the first FULL backukp might be possible, the general rule is: No, this is not possible, you can only restore to a point after the FULL backup finished.

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