Date: Fri, 14 Mar 2008 16:17:13 -0500
RMAN doesn't care whether the backup is cold or hot. There is no difference. In fact, to do a cold backup, you have to mount the database in RMAN, so it really isn't COLD. It is luke warm.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith Sent: Friday, March 14, 2008 3:05 PM
To: Goulet, Dick; oracle-l_at_freelists.org Subject: RE: rman
But does this not imply that the level 0 back and incremental backup have to be the same? All cold backups or all hot or on-line backups?
Subject: RE: rman
Date: Fri, 14 Mar 2008 15:55:17 -0400
To: joe_dba_at_hotmail.com; oracle-l_at_freelists.org
Yes, does it automatically, no action on your side needed. Basically a restore of a datafile or the database will restore the last cold backup. The recover command will then apply incremental backups as possible and then archive redo to complete the action.
Dick Goulet / Capgemini
North America P&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com<http://www.capgemini.com/> Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com<mailto:richard.goulet_at_capgemini.com> 45 Bartlett St. / Marlborough, MA 01752
Together: the Collaborative Business Experience
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith
Sent: Friday, March 14, 2008 3:16 PM
Does this make sense:
Incremental backups for database every day (based on block change tracking approach - new in 10G). Archivelogs are backed up everyday. Full cold backup on the weekend. Recovery using previous cold backup and applying incremental backups & archivelogs.
I am reading this in a doc given to me.
Can you apply an incremental backup ( level 1 or 2 ) taken during the week to a cold backup taken on Sunday?
Can the BCT feature be used with a cold backup?
Need to know the score, the latest news, or you need your Hotmail(r)-get your "fix". Check it out.<http://www.msnmobilefix.com/Default.aspx>
This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
Climb to the top of the charts! Play the word scramble challenge with star power. Play now!<http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan>
[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.
To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.comReceived on Fri Mar 14 2008 - 16:17:13 CDT