Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!feeder.ecngs.de!ecngs!feeder2.ecngs.de!87.106.137.111.MISMATCH!weretis.net!feeder1.news.weretis.net!news.solani.org!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: RMAN question Date: Wed, 3 Mar 2010 15:43:42 +0000 (UTC) Organization: solani.org Lines: 29 Message-ID: References: <88b08385-a8ae-4285-9d5c-3a3eabb5345a@v20g2000yqv.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1267631022 9298 eJwNyskNADAIA7CZAoRjHATt/iO0X8tUh0+Y042Xt4/ITGLqQFbAEaIZXyx/aqZu6eoGtsYfFgQQow== (3 Mar 2010 15:43:42 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Wed, 3 Mar 2010 15:43:42 +0000 (UTC) X-User-ID: eJwFwYkBADAEBLCVKIeO46n9R2gCMbZ2NZhisVorT6AhdMh7huvU3hmfp5wHLYSmXM4I8fsBH/IRIw== Cancel-Lock: sha1:sbF4TqsrbCJI+IhA4dOK3AIS4TM= User-Agent: Pan/0.133 (House of Butterflies) X-NNTP-Posting-Host: eJwNwgERwDAIA0BLZSWhlQNk+Jew/T02jR1O0DEYkoVFZajz1VL8+zk7Rnkgjhb8yO1WxbUPKf0RbA== Xref: news.cambrium.nl On Wed, 03 Mar 2010 07:12:27 -0800, The Magnet wrote: > Hi, > > We're running Oracle 10g R2. I'm restoring a copy of the database onto > a different server. Our retention period is 21 days, with an > Incremental Level 0 each Sunday. > > For this restore, I really only need to start with the last Incremental > Level 0, as that is a backup of the entire database. But when we > performed the restore, it seemed to start with the beginning of > retention period, hence 21 days ago. This is not needed, we really need > just from the last Incremental Level 0. > > How can I tell RMAN which Level 0 to access. We are using a control > file rather than a catalog. One thing I though of is to mark the other > backups as Unavailable? > > Searching Oracle docs, but have not found the answer yet. > > Many thanks You can restore specific tag or file. Check the syntax for the restore command. -- http://mgogala.byethost5.com