|
-
hi,
i try to recover the system file by giving the following command and try to open the database but it once again shows the same error with different datafile that it needs recovery........
this is wat i did to recover:
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\SYSTEM01.DBF';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: 'D:\ORACLE\ORADATA\SONA\EXAMPLE01.DBF'
..............
wat to do now?
i hav control file backup.can i recover it by "recover database using backup control file until cancel" ?
any suggestions plz......
sorry itz my mistake that not having any backup.....
plz help me to solve this issue.....
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
|