Restore & Recovery

From: y <y_at_y.com>
Date: Sat, 07 Sep 2002 16:18:59 GMT
Message-ID: <3D7A26D2.2FD7BF5B@y.com>

ORACLE 8i EE

I have two questions about "Restore and Recovery":

Q1. I create a database with ARCHIVELOG mode. When I lost one of my data file (Users tablespace). During recovery phase, I have to:

    SQL> startup mount
    SQL> recovery database
    SQL> alter database open

How does it means the whole database is available during recovery process? During recovery phase, I can't open the database.

Q2). Using RMAN

    Why when I need to restore and recover a tablespace, I have to take the tablespace "OFFLINE TEMPORARY".

    And when I need to restore and recover a datafile, I need only to take the tablespace "OFFLINE IMMEDIATE"?

Thanks in advance, Received on Sat Sep 07 2002 - 11:18:59 CDT