Re: How can I create and delete instance and database?

From: <ashesh48_at_my-dejanews.com>
Date: Tue, 14 Jul 1998 13:34:00 GMT
Message-ID: <6ofmo9$4nb$1@nnrp1.dejanews.com>

Hi,

       Thank you for your help.
        I am new for the Oracle.  As u said, my problem starts from

the shutting down the database or Instance. I am using the server manager. svrmgr23.exe for it. the Instace = CFE.  I connected as sys/manager_at_cfe which has the DBA privilages with ADM option.  now i am typing the
svrmgr> shutdown -sid ORCL ( I done know the -SHUTTYPE )

but it doesn't work. it gives em an error of Illegal Shutdown operation...

And which meanuals and SQL scripts i should look for this problem? How can i get trainning for all this.?hope I am asking too much?

Again, Thank you very much for your help Ashesh.

In article <900313996.12961.0.nnrp-07.c2de712e_at_news.demon.co.uk>,   "MotoX" <rat_at_tat.a-tat.com> wrote:
> *First*, perform a *full export and a full cold backup* of your existing
> database.
>
> To delete it, shut it down and remove all the files - look in dba_data_files
> for a list. Add the initialisation files and redo log files to the list.
>
> To recreate, use the CREATE DATABASE command to get a new instance and empty
> database. Look in the manuals for details (creating init files, redo logs,
> catalog, etc.) Then use the full export you made. Alternatively, if you
> already have the creation scripts from your original db, use them, making
> any modifications you desire first.
>
> MotoX.
>
> As regards rebuilding
> ashesh48_at_my-dejanews.com wrote in message
> <6o5gqc$jb1$1_at_nnrp1.dejanews.com>...
> >Hi all, How can I drop the existing database and reuse the
> >objects(logfiles,datafiles etc.) of it and create the new database? and How
> >can i delete the old Instance and create new one?Thanks for help in
> >advance.Ashesh.
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 14 1998 - 08:34:00 CDT