No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. Péran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

RMAN backups
Next thread: AWR report from or not from PDB
Prev thread: Snapshots for PDB

Message Score Author Date
Hi I have the following RMAN backup process in ...... James Alcroft Aug 15, 2019, 22:58
Hi James, zipping RMAN backup files sounds awkw...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Aug 16, 2019, 15:04
Hello James, - (I thought that "level 2" had be...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Aug 16, 2019, 15:14
Hi Bruno, yes, I fully agree with you. Personal...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Aug 16, 2019, 15:43
Thanks guys. Ales, I send the zip file to anoth...... James Alcroft Aug 16, 2019, 16:00
Hello James, about <<<I>Due to the nature of th...... Bruno Vroman Aug 16, 2019, 16:13
Yeh, I follow what you are saying. Customers do...... James Alcroft Aug 16, 2019, 16:41

Follow up by mail Click here


Subject: RMAN backups
Author: James Alcroft, United Kingdom
Date: Aug 15, 2019, 22:58, 96 days ago
Os info: Win 2012
Oracle info: 12.1
Message: Hi

I have the following RMAN backup process in place:

Sat: Level 0 backup
Mon 2am: level 2 backup
Tue 2am: level 2 backup
Wed 2am: level 1 backup
Thu 2am: level 2 backup

Mon to Fri from 7am to 11pm on the hour, archive only backup

After each RMAN backup, the files are zipped up and these backup files are then deleted (leaving me with just the zip file).

My problem is that I keep running out of disk space. The server is VM at Azure, and my last drive space increase request took 5 weeks (internal issues, not Azure).

Am I right in thinking that once my level 2 backup has finished on Tuesday, i don't need my hourly archive only backups from Monday? And once my level 1 backup on Wednesday has finished, I don't need any of my previous backups except for the level 0?

Basically thinking of deleting files once they are not needed.

Many thanks.

James

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

Subject: Re: RMAN backups
Author: Ales Kavsek, Slovenia
Date: Aug 16, 2019, 15:04, 95 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi James,

zipping RMAN backup files sounds awkward those days, why don't you use RMAN basic compression instead?

Regarding your question, yes you're right about deleting strategy, bun only if you're 100% sure that you'll never ever need to perform point in time recovery. Personally, I would not risk of not having ability to execute point in time recovery. For sure I would keep at least level 2 backups, even after executing level 1, so I could at least execute daily (~2am) point in time recovery.

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: RMAN backups
Author: Bruno Vroman, Belgium
Date: Aug 16, 2019, 15:14, 95 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hello James,

- (I thought that "level 2" had been deprecated... I use only level 0 and level 1 backups)

- and no backup on Friday?

- I would suggest
  Sat 2am L0
  Mon to Fri 2am L1 cumulative (so that for example if you have to restore and recover "up to Thu 3pm" RMAN will not need the L1 of Mon, Tue, Wed)

- About deleting backups when they are not needed anymore, beware that Murphy is behind the corner... You might think that you need only the ability to restore/recover the database to the most recent point in time (scenario: big issue "now", restore the database!) but they're might be other stories... What about for example: Now the business comes to you "we made a big mistake on Wednesday afternoon, damaging the data; the data backed up on Thursday and Friday is of no use, you have to restore the database as it was on Wed 11am"... Being able to do this is more important than gaining some backup space
(you might as well demand space to keep a few weeks of backups, and maybe monthly backups should be saved to tape...)

- and BTW, if you don't know this you might have a good suprise regarding speed of incremental backups: check the documentation about "block change tracking": usually tiny cost (small file) for large benefit (RMAN knows "what to back up") (of course, "it depends of your particular case")

Best regards,

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

Subject: Re: RMAN backups
Author: Ales Kavsek, Slovenia
Date: Aug 16, 2019, 15:43, 95 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Bruno,

yes, I fully agree with you. Personally, I know that I would not "survive" if I would not have an option to perform point in time recovery (in my current situation the PITR is almost a regular monthly activity, and after people return from holidays, it's a weekly "business" ;-).
But I could understand James situation, cloud provider as such is not the problem, at the end of the day some business bureaucracy is running the show ;-(.

Regarding levels above 1 (2,3 and 4), you're right, they're deprecated but they still works, why I don't know, because we can achieve the same with level 0 and 1.


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: RMAN backups
Author: James Alcroft, United Kingdom
Date: Aug 16, 2019, 16:00, 95 days ago
Message: Thanks guys.

Ales, I send the zip file to another server as part of my backup process. Easier to send one zip file instead of 15 to 20 individual files. But understand you comments.

Bruno, sorry missed the Friday backup off the list. Yes, level 2 backup on Friday at 2am also happening.

Due to the nature of the data we store, which is for multiple customers, we will only restore database to the latest backup, we will never do a point-in-time recovery. When working on a customer upgrade, or similar, we will export their schema using EXPDP first.

If level 2 option is deprecated, I will change to do level 0 and level 1.

I will try compressed RMAN backup, see what space is required and then just ignore sipping the files.

Thanks for the suggestions.

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

Subject: Re: RMAN backups
Author: Bruno Vroman, Belgium
Date: Aug 16, 2019, 16:13, 95 days ago
Message: Hello James,

about <<Due to the nature of the data we store, which is for multiple customers, we will only restore database to the latest backup, we will never do a point-in-time recovery>>

You don't want either to have to restore the database for all the customers because of an issue with one customer...
You might have to do something like this:

customer X: "we made a big mistake, please reset the data (maybe they can even say "of table T only") as it was 2.5 days ago, on Wed 11am."
->
 a)restore and recover in non-prod environment, only the minimum set of necessary tablespaces, up to Wed 11am.
 b) from this database, export the relevant schema(s) (or only the relevant table(s))
 c) replace what has to be replaced in the actual production database.

You see that you can provide the service to customer X without impacting customers Y and Z (and that's good... Just imagine what you should explain to Y and Z hmmmm, or how would react X if you had to say "sorry dear customer, we cannot do this, go back to the small letters of the contract and contact your lawyer")

Best regards,

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

Subject: Re: RMAN backups
Author: James Alcroft, United Kingdom
Date: Aug 16, 2019, 16:41, 95 days ago
Message: Yeh, I follow what you are saying.

Customers do not have direct access to the database, only through our data entry application. All data changes are audited, so should they have messed up some data, we have methods to recover this through the audit data.

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