Minimal Number Of Parameters To Start An Instance

Today I needed create an auxiliary instance to restore a pairs of datafiles, for this purpose minimal configurations is enough. Oracle documentations says that only one parameter to start (startup nomount in mi case) is db_name, the rest of parameters are setting on defaults. Please look at down the next text;


thunder-3@:$PWD> cat initreco.ora
### The only one parameter needed is db_name
thunder-3@:$PWD> sqlplus '/ as sysdba'

SQL*Plus: Release Production on Tue Aug 30 13:02:47 2016

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  329990144 bytes
Fixed Size                  2158976 bytes
Variable Size             255856256 bytes
Database Buffers           67108864 bytes
Redo Buffers                4866048 bytes

HTH – Antonio NAVARRO.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s