RMAN - in a nutshell!

[MCubitt]

Our company are struggling to limit server downtime which is caused by backups, where we currently down a database, copy files to a dump area and then start the database, backing up the dump later.

However, the day is lurking for our company to experience 24/5.. 24/6 uptime requirements.

I understand RMAN is a tool which can perform backups of active databases but have also heard it can be complex.

Can anyone offer opinions on using this kind of tool?

We have very limited Oracle knowledge (as anyone in this forum who knows my questions would agree!) but are keen to learn.. quickly!

I know there are variables including archive mode and such, but don't really comporehend.

thanks




Applications Support
UK

 

[alexhu]

Ken - Spooky - I do that too

Alex

 

[KenCunningham]

Great minds and all that. Now what's the other half of that quotation? ;-) Very Twilight Zone indeed!

 

[hoinz]

Ken and Alex,
I don't think that this fear is irrational.
I have no experience with compressing log files; we save them to tapes (two tapes, belt and braces!)
But for a few of our test systems there was a cron job running sometimes that simply deleted them.
And yes, there were error messages (but no serious problems) when a log file was deleted while it was still being written.
So we later on left the last one alone.
regards

 

[MCubitt]

Thanks Ken, Alex & Hoinz. It has certainly given me a good insight into one possible method which appears shared between you three (with or without compression).

thanks


Applications Support
UK

 

[MCubitt]

Sorry, I am back!

All this concentrating on getting the data backed up, restoration and recovery appear to be a whole new ball game.

Since hot backups are straight forward using backup mode - I will attempt that, backing up the full datafiles and archivelogs.

How then do I recover?




Applications Support
UK