OraFAQ Forum: Backup & Recovery » rman back up advice/question

Home » RDBMS Server » Backup & Recovery » rman back up advice/question (111.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rman back up advice/question [message #658065]

Fri, 02 December 2016 03:37

dba88
Messages: 3
Registered: December 2016

Junior Member

Hello DBA's

Please assist with my question here:

There's a need to upgrade EMC Unity for which I have to restart Production and Test databases. There is also Rman online backup in place for both P & Q systems.

+ The databases P and database Q will be affected and have to be stopped and restarted -- Downtime < 15 minutes.

Note: We are having a full back up on weekend and incremental on week days.

So, can we use the full backup from the last weekend and restart the online back ups?
OR
Should I start with incremental instead of a new full back up.

Thank You for all your help smile emoticon

Report message to a moderator

Re: rman back up advice/question [message #658066 is a reply to message #658065]

Fri, 02 December 2016 03:55

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

I do not see why stopping and starting the databases should have any impact on your backup strategy.

Report message to a moderator

Re: rman back up advice/question [message #658067 is a reply to message #658065]

Fri, 02 December 2016 03:58

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Is EMC Unity not the just storage? In which case you should be fine to just keep doing incrementals. It depends on your faith/paranoia though I guess.

Report message to a moderator

Re: rman back up advice/question [message #658069 is a reply to message #658067]

Fri, 02 December 2016 04:56

dba88
Messages: 3
Registered: December 2016

Junior Member

Thank You, I appreciate your response.

EMC is only to store archive logs (just the storage)

So, you are saying should I just continue with my incremental back ups. In worst case scenario, I can just restore to previous full back up?

Best Regards,
Agha

Report message to a moderator

Re: rman back up advice/question [message #658071 is a reply to message #658069]

Fri, 02 December 2016 06:30

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

dba88 wrote on Fri, 02 December 2016 04:56

Thank You, I appreciate your response.

EMC is only to store archive logs (just the storage)

So, you are saying should I just continue with my incremental back ups. In worst case scenario, I can just restore to previous full back up?

Best Regards,
Agha

What does the location of the archivelogs have to do with the usability of any existing backups?

Report message to a moderator

Re: rman back up advice/question [message #658074 is a reply to message #658071]

Fri, 02 December 2016 07:30

dba88
Messages: 3
Registered: December 2016

Junior Member

Hi,

Thanks for your prompt reply and your advice Smile

Sorry, I thought you were asking me if EMC is just the storage? That is why in my previous email I said it is to store archive logs. I know it has nothing to do with usability for backups.

Thank You much so much Roach Coach

Best Regards,
Agha

Report message to a moderator

Re: rman back up advice/question [message #658096 is a reply to message #658074]

Sat, 03 December 2016 07:53

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

dba88 wrote on Fri, 02 December 2016 07:30

Hi,

Thanks for your prompt reply and your advice

Sorry, I thought you were asking me if EMC is just the storage? That is why in my previous email I said it is to store archive logs. I know it has nothing to do with usability for backups.

So if you already know it has nothing to do with usability of backups, what is your question?

Report message to a moderator

Previous Topic:	Deleting all data of corrupted database
Next Topic:	Transport tablespace with Oracle Standard Edition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 22:19:30 CST 2025