Re: PO7: How to Force Startup When Datafile is Missing?

From: mark tomlinson <marktoml_at_gdi.net>
Date: Mon, 04 May 1998 14:07:19 GMT
Message-ID: <354fc88b.253395333_at_newshost.us.oracle.com>

On Sun, 3 May 1998 19:54:40 -0400, "R. Pritchard" <ralph_at_gte.net> wrote:

>Hi. How does one force Personal Oracle 7 to start? I have a datafile that is
>corrupt and receives ORA-01122 on start-up. Because of this error, the
>database shuts down and I cannot get it available.
>
>I've tried some command line combinations using Server Manager, but I cannot
>get it to work.
>
>Thanks for any suggestions.
>Ralph
>

-Connect internal
-mount the rdbms, (not open), (alter database mount)
-offline the affected datafile, (alter database datafile 'filename'

offline)
-open the RDBMS, (alter database open) Received on Mon May 04 1998 - 16:07:19 CEST

This message: [ Message body ]
Next message: Franco NG: "Problem using remote index file"
Previous message: Dr. Gianna M. Cothren: "help regarding creating table space"
In reply to R. Pritchard: "PO7: How to Force Startup When Datafile is Missing?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message