I haven't really been following this thread closely but whenever you do a level 0 rman backup it will include the controlfile. If you need to recover to a point in time you can recover using backup controlfile to that point in time.
HTH, Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 04, 2002 10:08 AM > Here is an example from 8.1.7.4 > > oracle@loki:/orabak >rman nocatalog > > Recovery Manager: Release 8.1.7.4.0 - Production > > RMAN> connect target / > > RMAN-06005: connected to target database: LIVL > (DBID=750735866) > RMAN-06009: using target database controlfile instead > of recovery catalog > > RMAN> run { > 2> allocate channel c1 type disk; > 3> set limit channel c1 kbytes=2000000; > 4> backup full (database format > '/orabak/tmp/ORA_O_%d_%t_%s_%p_%u'); > 5> sql "ALTER SYSTEM ARCHIVE LOG CURRENT"; > 6> change archivelog all crosscheck; > 7> backup (archivelog all format > '/orabak/tmp/ORA_A_%d_%t_%s_%p_%u'); > 8> } > > RMAN-03022: compiling command: allocate > RMAN-03023: executing command: allocate > RMAN-08030: allocated channel: c1 > RMAN-08500: channel c1: sid=22 devtype=DISK > > RMAN-03022: compiling command: set limit > RMAN-03023: executing command: set limit > > RMAN-03022: compiling command: backup > RMAN-03023: executing command: backup > RMAN-08008: channel c1: starting full datafile > backupset > RMAN-08502: set_count=1 set_stamp=474386022 > creation_time=04-OCT-02 > RMAN-08010: channel c1: specifying datafile(s) in > backupset > RMAN-08522: input datafile fno=00001 > name=/oras1/livl/livlsystem01.dbf > RMAN-08011: including current controlfile in backupset > RMAN-08522: input datafile fno=00002 > name=/oras3/livl/livlrbs01.dbf > RMAN-08522: input datafile fno=00008 > name=/ora03/livl/livlretest01.dbf > RMAN-08522: input datafile fno=00003 > name=/ora01/livl/livllivlt01.dbf > RMAN-08522: input datafile fno=00004 > name=/ora02/livl/livllivlt02.dbf > RMAN-08522: input datafile fno=00005 > name=/ora03/livl/livllivlt03.dbf > RMAN-08522: input datafile fno=00006 > name=/orai1/livl/livllivli01.dbf > RMAN-08522: input datafile fno=00007 > name=/orai2/livl/livllivli02.dbf > RMAN-08013: channel c1: piece 1 created > RMAN-08503: piece > handle=/orabak/tmp/ORA_O_LIVL_474386022_1_1_01e4d3j6 > comment=NONE > RMAN-08525: backup set complete, elapsed time: > 00:03:28 > > RMAN-03022: compiling command: sql > RMAN-06162: sql statement: ALTER SYSTEM ARCHIVE LOG > CURRENT > RMAN-03023: executing command: sql > RMAN-03022: compiling command: backup > RMAN-03023: executing command: backup > RMAN-08009: channel c1: starting archivelog backupset > RMAN-08502: set_count=2 set_stamp=474386265 > creation_time=04-OCT-02 > RMAN-08014: channel c1: specifying archivelog(s) in > backup set > RMAN-08504: input archivelog thread=1 sequence=586 > recid=543 stamp=474386235 > RMAN-08013: channel c1: piece 1 created > RMAN-08503: piece > handle=/orabak/tmp/ORA_A_LIVL_474386265_2_1_02e4d3qp > comment=NONE > RMAN-08525: backup set complete, elapsed time: > 00:00:08 > RMAN-08031: released channel: c1 > > So I've taken a backup...now can I get the control > file back? > > oracle@loki:/orabak/tmp >sqlplus internal > > SQL*Plus: Release 8.1.7.0.0 - Production on Fri Oct 4 > 13:58:56 2002 > > (c) Copyright 2000 Oracle Corporation. All rights > reserved. > > > Connected to: > Oracle8i Enterprise Edition Release 8.1.7.4.0 - > Production > With the Partitioning option > JServer Release 8.1.7.4.0 - Production > > sys@livl> DECLARE > 2 devtype varchar2(256); > 3 done boolean; > 4 BEGIN > 5 devtype := > dbms_backup_restore.deviceallocate('',params=>''); > 6 dbms_backup_restore.restoresetdatafile; > 7 > dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar'); > 8 > dbms_backup_restore.restorebackuppiece('/orabak/tmp/ORA_O_LIVL_474386022_1_1 _01e4d3j6',done=>done); > 9 END; > 10 / > > PL/SQL procedure successfully completed. > > sys@livl> exit > Disconnected from Oracle8i Enterprise Edition Release > 8.1.7.4.0 - Production > With the Partitioning option > JServer Release 8.1.7.4.0 - Production > you have mail in /var/mail/oracle > oracle@loki:/orabak/tmp >ls -l /tmp/foo.bar > -rw-rw---- 1 oracle dba 1908736 Oct 4 > 14:00 /tmp/foo.bar > > > hth > connor > > --- Joe Testa <[EMAIL PROTECTED]> wrote: > Connor, my > problem(fault) was I didnt make a copy of > > the control > > file(and in 8.1.7, you don't get it backed up by > > default like in 9i, > > right?). > > > > I attempted to bring the db in nomount and restore > > the control file, > > rman reply "no controlfile backup found". > > > > joe > > > > > > Connor McDonald wrote: > > > > >What follows might be all hogwash, you could have > > >tried this: > > > > > >DECLARE > > > devtype varchar2(256); > > > done boolean; > > >BEGIN > > > devtype := dbms_backup_restore.deviceallocate('', > > >params=>''); > > > dbms_backup_restore.restoresetdatafile; > > > > > > >dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar'); > > > > > > >dbms_backup_restore.restorebackuppiece('wherever_my_backups_are',done=>done ); > > >END; > > >/ > > > > > >which drags a copy of the control file that was > > >included in the backup into /tmp/foo.bar. > > (Obviously > > >this has to be run against a different ie "up" > > >database). > > > > > >Then startup nomount the db to be recovered, rman > > the > > >'replicate controlfile' and then restore/recover in > > >the normal way. I think this functionality came in > > >when they allowed a no-catalog mechanism, so if you > > >lost everything, you could still make use of a > > backup. > > > > > >hth > > >connor > > > > > > --- JOE TESTA <[EMAIL PROTECTED]> wrote: > Ok > > so > > >the qa environment we've been fooling around > > > > > > > > >>with rman for testing backup/recovery. > > >> > > >>tonite they say " we want a backup restored from > > >>rman from 2 incarnations ago(for those of u who > > dont > > >>know what an incarnation is, its a new version of > > >>the database that gets created when you do open > > >>resetlogs <-- if thats wrong please RMAN gurus > > >>correct me. > > >> > > >>So I get out the book, the docs say "in the event > > >>you have to do this, which should be rare", you > > must > > >>do the > > >>"reset database to incarnation" command. > > >> > > >>seems easy enough, fire up rman, startup > > nomount, > > >>reset incarnation and it finds the old backups, > > and > > >>starts the restore. > > >> > > >>so far so good, but then the catch, being a rman > > >>newbie(8.1.7), i forgot to make a controlfile > > >>backup, now if i'd had that, this should have been > > >>cake,restore the control file in nomount mode, > > mount > > >>and restore the datafiles, recover the datafiles > > and > > >>open resetlogs, did i forget to say, this is a > > >>NOARCHIVELOGMODE database. > > >> > > >>Well, for whatever reason, the database wouldnt > > >>open, due to using a newer controlfile. > > >> > > >>hmmm, i've done this before, i'll just dump the > > >>controlfile to trace(yes i did this BEFORE the > > >>restore, just in case of an actual emergency). > > >> > > >>rebuild the control file, try the recover > > again(did > > >>i say we're going to a particular SCN based on the > > >>info from list backup/list incarnation commands), > > no > > >>deal, damn database will not open. > > >> > > >>regroup, wait a minute, rman aint anything > > special, > > >> let's do this: > > >> > > >>restore the files from rman backup again. > > >>exit rman > > >>sqlplus: recover database until scn #######; > > >>alter database open resetlogs; > > >> > > >>rman: <check> resync catalog; > > >> > > >>CHOKE, but i expected that, > > >>rman: reset database; > > >> > > >>full catalog sync AND > > >> > > >>we're good to go. > > >> > > >>Where did go wrong in using RMAN to do the > > >>recover/restore ??? > > >> > > >>joe > > >> > > >> > > >> > > > > > >===== > > >Connor McDonald > > >http://www.oracledba.co.uk > > >http://www.oaktable.net > > > > > >"Remember amateurs built the ark - Professionals > > built the Titanic" > > > > > >__________________________________________________ > > >Do You Yahoo!? > > >Everything you'll ever need on one web page > > >from News and Sport to Email and Music Charts > > >http://uk.my.yahoo.com > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Joe Testa > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > > http://www.fatcity.com > > San Diego, California -- Mailing list and web > > hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > ===== > Connor McDonald > http://www.oracledba.co.uk > http://www.oaktable.net > > "Remember amateurs built the ark - Professionals built the Titanic" > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).