Oracle-Restart
Full srvctl command reference here.
Add Database
srvctl modify database -db db_unique_name -dbname db_name -o $ORACLE_HOME
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
Display
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.
Remove Database
srvctl stop database -db oradb_sb srvctl remove database -db oradb_sb