Oracle DBA Place

Hi, Checking if the Far Sync instance is configured to restart automatically after reboot / shutdown of the host / cluster: $ crsctl stat res ora.fdb1.db -f |grep AUTO_START AUTO_START= restore "restore" means that after restart, the database will remain at the previous state it was before. Changing the cluster to startup the database in any case. $ crsctl stat res ora.fdb1.db -f |grep AUTO_START AUTO_START= always Changing database to start always after reboot $ crsctl modify resource ora.fdb1.db -attr  AUTO_START= always -unsupported Modify the startup state: $ srvctl modify database -o mount View modified configuration $ srvctl config database -d fdb1 -all Database unique name: fdb1 Database name: fdb1 Oracle home: /oracle/product/12.1.0.2/dbhome_1 Oracle user: oracle Spfile: Password file: Domain: Start options: mount Stop options: immediate Database role: FAR_SYNC Management policy: AUTOMATIC Disk Groups: DATA Services: Database is enab...

In Oracle Restart, there are two confusing commands for setting up restart behavior. 1. SRVCTL command. srvctl add/modify database -y {AUTOMATIC | MANUAL} Management policy for the database. If AUTOMATIC (the default), the database is automatically restored to its previous running condition (started or stopped) upon restart of the database host computer. If MANUAL, the database is never automatically restarted upon restart of the database host computer. A MANUAL setting does not prevent Oracle Restart from monitoring the database while it is running and restarting it if a failure occurs. https://docs.oracle.com/cd/E11882_01/server.112/e25494/restart.htm#BABHHAHI 2. CRSCTL command. crsctl modify resource ora.pdb.db -attr AUTO_START=restore -unsupported (The -unsupported syntax is needed for oracle 12c) AUTO_START Indicates whether Oracle Clusterware automatically starts a resource after a cluster server restart. Valid AUTO_START values are: - always: Restarts the resource...