Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-1113 signalled during: alter database open
I was hasty and I did a cold backup incorrectly, I believe. I shut
the database down and backed up only the data files for one (out of 4
tablespaces). I started Oracle and proceeded to work on all 4
tablespaces. Today I needed to quickly roll back the tablespace I
"backed up", so I stopped Oracle and pasted the backed up datafiles
back in. Now Oracle won't start...
ORA-1113 signalled during: alter database open
Is there a command I can run to tell Oracle I am sure these data files are consistent, and to let me open the database? Even point me in the right direction and I will appreciate it.
Thanks,
Stephen
Received on Thu Jun 16 2005 - 17:40:29 CDT