Add Database to Oracle-Restart
Full srvctl command reference here.
Status Checks
srvctl config database -db oradb_sb Database unique name: oradb_sb Database name: oradb Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_1 Oracle user: oracle Spfile: /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/spfileoradb_sb.ora Password file: /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/orapworadb_sb Domain: Start options: mount Stop options: immediate Database role: PHYSICAL_STANDBY Management policy: AUTOMATIC Disk Groups: DATA,FRA Services: OSDBA group: OSOPER group: Database instance: oradbsb srvctl status database -db oradb_sb Database is running.
Add
su - oracle
srvctl add database -db oradb_sb -dbname oradb -o $ORACLE_HOME
srvctl config database -db oradb_sb
srvctl modify database -db oradb_sb -p '$ORACLE_HOME/dbs/spfileoradb_sb.ora'
srvctl modify database -db oradb_sb -role PHYSICAL_STANDBY
srvctl modify database -db oradb_sb -startoption MOUNT
srvctl modify database -db oradb_sb -pwfile $ORACLE_HOME/dbs/orapworadb_sb
srvctl start database -db oradb_sb
Remove
srvctl stop database -db oradb_sb srvctl remove database -db oradb_sb