Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-1113 signalled during: alter database open

ORA-1113 signalled during: alter database open

From: Stephen <slincali_at_gmail.com>
Date: 16 Jun 2005 15:40:29 -0700
Message-ID: <1118961629.791161.11630@g47g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US