I would suggest you setup a test database to try these scenarios so that you understand how to use these RMAN features. On Fri, Mar 14, 2008 at 1:05 PM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote: > 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 > From: richard.goulet@xxxxxxxxxxxxx > To: joe_dba@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx > > 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 > Fax: 508.229.2019 / Email: *richard.goulet@xxxxxxxxxxxxx* > 45 Bartlett St. / Marlborough, MA 01752 > > *Together: the Collaborative Business Experience * > ______________________________________________________________ > ------------------------------ > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Joe Smith > *Sent:* Friday, March 14, 2008 3:16 PM > *To:* oracle-l@xxxxxxxxxxxxx > *Subject:* rman > > > > 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? > > > > thanks. > > > ------------------------------ > > 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> > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist