Provision of Reset Command for full Database factory Restore

vansul

Provision of Reset Command for Reset of  the full factory reset of default configuration except data stored

this will be helpful for learners DBA to restore the settings in case of any unrecoverable error

Recovery of only database configurations and not the database objects.

top.gun

So you mean just reset the system parameters?

ctrieb

I don't understand this, can you explain it with an example.

BPeaslandDBA

A command already exists:    rm $ORACLE_HOME/dbs/*.ora

Now executing such a command would be a terrible idea.

Pravin Takpire

I think you should keep your original init.ora and try to restart database with that

regards

Pravin

top.gun

A total reset is already available as follows:

sql> STARTUP FORCE NOMOUNT

Lothar Flatz

I don't get this as well. How should we take an idea seriously that is badly explained? In any case a database is NOT and resembles NOT a mobile phone.