| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Question about RMAN and recovery scenario.
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:Oleksandr_A_at_yahoo.co.uk
--
Best regards,
Alex mailto:Oleksandr_A_at_yahoo.co.uk __________________________________________________Do You Yahoo!?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex Andriyashchenko
INET: Oleksandr_A_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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). Received on Mon Feb 10 2003 - 17:18:40 CST
 |
 |