Re: ORA-1113 signalled during: alter database open

On 16 Jun 2005 15:40:29 -0700, "Stephen" <slincali_at_gmail.com> wrote:

>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

Let me get this straight: you deliberately restored an incomplete backup over a consistent database, and you now think you will be able to get out of this *without* recovery?
You aren't serious, are you?

Sorry to say so: you just screwed up your database, and the only way is to restore a *complete and consistent* backup and use your archivelogs (the database is running in archivelog, isn't it) to perform a complete recovery.
If you don't have archivelogs and you don't have a recent export, your database is toast, and you just demonstrated you better shouldn't touch Oracle.

--
Sybrand Bakker, Senior Oracle DBA