Hello Folks, Thank you everybody for help.
Sorry to confuse you I forgot to show what version I am using for testing... It is 9iR2. I just realized why I got unexpected behavior of recovery scenario during my testing. I removed datafiles with started instance. And when my script tried to login to rman error happened. Not I tried same scenario with stopped instance and it worked in proper way. Hm, I tried to login as sysdba to rman (user in target DB should be sysdba). Did I need to access SYSTEM tablespace when I logged in as SYSDBA? It means if instance started and SYSTEM tablespace gone I couldn't login as SYSDBA even to stop instance with SHUTDOWN ABORT??? Am I right? Monday, February 10, 2003, 3:13:56 PM, you wrote: AA> Hello Folks, AA> I am just working with recovery scenarios and have question about AA> rman. AA> Consider following situation: AA> 1. Use recovery manager without catalog only control file. AA> 2. Have level 0 database backup + level 1 backup. AA> If we lost all datafiles except datafiles from SYSTEM it is not a AA> problem to recover database. Also if RMAN uses catalog it works good. AA> But in scenario if we lost all datafiles (including all files from AA> SYSTEN tablespace) how to recover database? AA> Thank you for your help. AA> -- AA> Best regards, AA> Alex mailto:[EMAIL PROTECTED] -- Best regards, Alex mailto:[EMAIL PROTECTED] __________________________________________________ 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.net -- Author: Alex Andriyashchenko 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).