I am reading/testing RMAN to recover the datafiles and have questions:
basically, I am trying to resotre the datafiles or tablespaces that were lost, so obviously, the database will be crashed and you can only MOUNT the database.
Below is what Oracle advises to do and I am not clear:
Restore & Recover A Subset Of The Database
A subset of the database can be restored in a similar fashion:
sql 'ALTER TABLESPACE users OFFLINE IMMEDIATE';
restore tablespace users;
recover tablespace users;
sql 'ALTER TABLESPACE users ONLINE';
question: you have to mount the database rights??? but I got an error:
sql statement: alter tablespace test_data offline
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03009: failure of sql command on default channel at 08/30/2005 16:47:32
RMAN-11003: failure during parse/execution of SQL statement: alter tablespace li
ORA-01109: database not open
why do I get the error??? b/c the lost of the datafiels , that's only state I can get to and restore the database.
I have catalog database running on SERVER1 and backup the database on SERVER2. SERVER2 crashed b/c it lost datafiles or its tablespaces and I have to restore the database. you can only mount the database on SERVER2 but not OPEN b/c the lost datafiles.
The thing I don't undertsand was if you lost the datafiles, the DB will crashed and it's not even online so how to take the tablespace offline and do the recovery.
I am still testing so may be I miss the puzzle somewhere, could you please tell me the whole idea to resotre the daabase if I lost the dat files.