應(yīng)該說(shuō)是12c以上版本，如何使數(shù)據(jù)庫(kù)不隨GI啟動(dòng)而啟動(dòng)
以下提供了幾種方式，幾種方式，只需要提供其中一種即可。
1.修改策略為手工
[grid@dbserver ~]$ srvctl modify database -d orcl1 -h
Modifies the configuration for the database.
Usage: srvctl modify database -db <db_unique_name> [-dbname <db_name>] [-instance <inst_name>] [-oraclehome <oracle_home>] [-user <oracle_user>] [-domain <domain>] [-spfile <spfile>] [-pwfile <password_file_path>] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-startoption <start_options>] [-stopoption <stop_options>] [-policy {AUTOMATIC | MANUAL | NORESTART | USERONLY}] [-diskgroup "<diskgroup_list>"|-nodiskgroup] [-force]
-db <db_unique_name> Unique name for the database
-dbname <db_name> Database name (DB_NAME), if different from the unique name given by the -db option
-instance <inst_name> Instance name
-oraclehome <path> Oracle home path
-user <oracle_user> Oracle user
-domain <domain_name> Domain for database. Must be set if database has DB_DOMAIN set.
-spfile <spfile> Server parameter file path
-pwfile <password_file_path> Password file path
-role <role> Role of the database (PRIMARY, PHYSICAL_STANDBY, LOGICAL_STANDBY, SNAPSHOT_STANDBY)
-startoption <start_options> Startup options for the database. Examples of startup options are OPEN, MOUNT, or "READ ONLY".
-stopoption <stop_options> Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.
-policy <dbpolicy> Management policy for the database (AUTOMATIC, MANUAL, NORESTART or USERONLY)
-diskgroup "<diskgroup_list>" Comma separated list of disk group names
-nodiskgroup To remove database's dependency upon disk groups
-force Force the modify operation to stop database and service resources on some nodes as necessary, or to change management policy of all service to match new database management policy
-verbose Verbose output
-help Print usage
[grid@dbserver ~]$ srvctl modify database -db orcl1 -policy MANUAL
[grid@dbserver ~]$ srvctl config database -d orcl1
Database unique name: orcl1
Database name: orcl1
Oracle home:
/u01/app/oracle/product/19.10.0/db_1
Oracle user: grid
Spfile: +
DATA/ORCL1/PARAMETERFILE/spfile.277.1062774613
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: MANUAL
Disk Groups: DATA
Services:
OSDBA group:
OSOPER group:
Database instance: orcl1
2.使用srvctl disable database
srvctl disable database -d orcl1
[grid@dbserver ~]$ srvctl disable database -db orcl1
3.使用 crsctl modify resource
[grid@dbserver ~]$ crsctl modify resource ora.orcl1.db -attr AUTO_START=never
CRS-4995: The command 'Modify resource' is invalid in crsctl. Use srvctl for this command.
12c以前，這樣可以，12c以后，需要加上 -unsupported
[grid@dbserver ~]$ crsctl modify resource ora.orcl1.db -attr AUTO_START=never -unsupported
[grid@dbserver ~]$ crsctl stat res ora.orcl1.db -p |grep -i auto_start
AUTO_START=never