|
-
Hi,
I have tried this a few times.
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\CWMLITE01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DRSYS01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\EXAMPLE01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\INDX01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\ODM01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\TOOLS01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\USERS01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\XDB01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM120040519091720_DB.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DM_NTDISTRIB20040514033149_DB.DB
F'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM1_INDX1.ORA'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|