Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Provision of Reset Command for full Database factory Restore

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.
Comments
-
So you mean just reset the system parameters?
-
-
A command already exists: rm $ORACLE_HOME/dbs/*.ora
Now executing such a command would be a terrible idea.
-
I think you should keep your original init.ora and try to restart database with that
regards
Pravin
-
A total reset is already available as follows:
sql> STARTUP FORCE NOMOUNT
-
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.