2024-01-01から1年間の記事一覧
https://docs.oracle.com/cd/F19136_01/cwadd/managing-oracle-cluster-registry-and-voting-files.html#GUID-8B4F44B8-9E4F-4DBE-A322-95D0FCEC3FBC olsnodes ※全ノードで実施crsctl stop crs crsctl start crs -excl -nocrs crsctl status resource ora.cr…
https://docs.oracle.com/cd/F19136_01/cwadd/managing-oracle-cluster-registry-and-voting-files.html#GUID-8554ACE4-44DF-4DB5-A939-1DC6D62BAE60 ocrconfig -showbackupocrconfig -manualbackup
https://docs.oracle.com/cd/F19136_01/cwadd/managing-oracle-cluster-registry-and-voting-files.html#GUID-619A16D6-AF79-4A48-950B-673F2A496408 ocrconfig -showbackuplococrconfig -backuploc +TEST
https://docs.oracle.com/cd/F19136_01/cwadd/managing-oracle-cluster-registry-and-voting-files.html#GUID-BFBBF4EC-5227-4413-98E0-93B62AA44034 ocrcheckocrconfig -delete +TEST
https://docs.oracle.com/cd/F19136_01/cwadd/managing-oracle-cluster-registry-and-voting-files.html#GUID-BFBBF4EC-5227-4413-98E0-93B62AA44034 select * from v$asm_diskgroup order by group_number; alter diskgroup test mount; ※rootユーザで実施※…
https://docs.oracle.com/cd/F19136_01/ostmg/maintain-diskgroups.html#GUID-EC6BCD13-2A39-4365-92CE-B26D48C62D38 export ORACLE_SID=+ASM1sqlplus / as sysasm select * from v$asm_diskgroup order by group_number; alter diskgroup test dismount; dr…
https://docs.oracle.com/cd/F19136_01/ostmg/create-diskgroups.html#GUID-7FB8914B-0995-4DA0-8F37-15B8EEAEEE4D SQLによる方法 ASMCAによる方法 export ORACLE_SID=+ASM1sqlplus / as sysasm select * from v$asm_diskgroup order by group_number;select…
https://docs.oracle.com/cd/F19136_01/dgbkr/examples-using-data-guard-broker-DGMGRL-utility.html#GUID-EBCA7643-F1D9-4EA0-BC5F-45AEEDEBC5BC -- 構成の解除dgmgrlconnect sys/oracleshow configuration; disable configuration; show configuration; R…
https://docs.oracle.com/cd/F19136_01/dgbkr/examples-using-data-guard-broker-DGMGRL-utility.html#GUID-630F5987-328C-410C-AE3B-A9D66EB233D4 ※スタンバイ側で実行する -- stbdgmgrlconnect sys/oracleshow configuration; show database verbose act;s…
https://docs.oracle.com/cd/F19136_01/sbydb/examples-of-using-oracle-data-guard.html#GUID-8F4E7807-6013-480F-8780-088F5639732F show parameter ultrashow parameter DB_LOST_WRITE_PROTECT alter system set db_ultra_safe='DATA_AND_INDEX' scope=sp…
https://docs.oracle.com/cd/F19136_01/dgbkr/examples-using-data-guard-broker-DGMGRL-utility.html#GUID-82319941-58E8-4672-8609-7CC496D3DC29 dgmgrlconnect sys/oracleshow configuration; show database verbose act;show database verbose stb; help…
https://docs.oracle.com/cd/F19136_01/sbydb/using-RMAN-in-oracle-data-guard-configurations.html#GUID-2AEB88E7-075F-47F4-BBCE-77B274A50683 rman target /show all; CONFIGURE ARCHIVELOG DELETION POLICY TO applied on all standby;CONFIGURE ARCHIV…
https://docs.oracle.com/cd/F19136_01/dgbkr/examples-using-data-guard-broker-DGMGRL-utility.html#GUID-8939FDE1-19B9-477E-99F8-5353BDD3AEC2 dgmgrlconnect sys/oracleshow configuration;show database verbose act; EDIT DATABASE act SET STATE = '…
https://docs.oracle.com/cd/F19136_01/dgbkr/examples-using-data-guard-broker-DGMGRL-utility.html#GUID-8939FDE1-19B9-477E-99F8-5353BDD3AEC2dgmgrlconnect sys/oracleshow configuration;show database verbose stb; EDIT DATABASE stb SET STATE = 'A…
https://docs.oracle.com/cd/F19136_01/dgbkr/using-data-guard-broker-to-manage-switchovers-failovers.html#GUID-68161F2B-991E-47B6-8D52-9651248A8162 dgmgrlconnect sys/oracleshow configuration; show fast_start failover;EDIT CONFIGURATION SET P…
https://docs.oracle.com/cd/F19136_01/dgbkr/examples-using-data-guard-broker-DGMGRL-utility.html#GUID-AAE5EA1A-53A2-4D8D-BF59-A2856B38C99D (1)LogXptModeの設定dgmgrlconnect sys/oracleshow configuration;show database verbose act;show database…
https://docs.oracle.com/cd/F19136_01/dgbkr/examples-using-data-guard-broker-DGMGRL-utility.html#GUID-05313396-B80D-4F53-BB44-AC7B0FF5E8B4 dgmgrl connect sys/oracle show configuration; show database verbose act;show database verbose stb; --…
https://docs.oracle.com/cd/F19136_01/dgbkr/examples-using-data-guard-broker-DGMGRL-utility.html#GUID-1403D1C3-8944-42D0-8BDA-21D695C7958A dgmgrl connect sys/oracle show configuration; show database verbose act;show database verbose stb; --…
https://docs.oracle.com/cd/F19136_01/admin/managing-automated-database-maintenance-tasks.html#GUID-19E9E024-A8C7-45A0-9CAA-BF3A09D95F9B 土日のオプティマイザ統計収集を無効化 月の自動SQLチューニングを無効化 select CLIENT_NAME from DBA_AUTOTA…
https://docs.oracle.com/cd/F19136_01/tgdba/IO-configuration-and-design.html#GUID-08ED4172-9398-402E-B0C4-4CE88DE87603 show parameter timed_statisticsshow parameter FILESYSTEMIO_OPTIONS alter system set timed_statistics=true;alter system se…
https://docs.oracle.com/cd/F19136_01/tgdba/tuning-database-buffer-cache.html#GUID-DE6B6C6E-D947-45FF-B189-F0271B86DB10https://docs.oracle.com/cd/F19136_01/tgdba/tuning-database-buffer-cache.html#GUID-30C8D6DD-C903-4484-B435-D51DF601D8B1 sh…
https://docs.oracle.com/cd/F19136_01/sqlrf/CREATE-TABLE.html#GUID-F9CE0CC3-13AE-4744-A43C-EAC7A71AAAB6__I2215507 --CACHE この句は、アクセス頻度の高いデータについて、全表スキャンの実行時に、--この表のために取り出されたブロックを、バッファ・…
https://docs.oracle.com/cd/F19136_01/tgdba/tuning-shared-pool-and-large-pool.html#GUID-E0D415CA-C4A7-4588-ADF2-4E302CE25849 create sequence sh.seq1 start with 1 increment by 1; select sh.seq1.nextval from dual; beginDBMS_SHARED_POOL.KEEP (…
https://docs.oracle.com/cd/F19136_01/admin/managing-indexes.html#GUID-8E5379E6-F96D-464D-B601-A279679A49E9 create index sh.f_ind on sh.times(upper(CALENDAR_MONTH_NAME)); alter index sh.f_ind monitoring usage; select count(*) from sh.times …
https://docs.oracle.com/cd/F19136_01/tgsql/performing-application-tracing.html#GUID-F872D6F9-E015-481F-80F6-8A7036A6AD29 conn sh/sh SELECT SID, SERIAL#, USERNAME FROM V$SESSIONWHERE USERNAME = 'SH'; ALTER SESSION SET TRACEFILE_IDENTIFIER =…
https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/UserGuide/blue-green-deployments-creating.htmlhttps://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql-install-cli.html RDS for MySQL DB インスタンスのブルー/グリーンデプロイを作成する…
https://docs.oracle.com/cd/F19136_01/tgsql/performing-application-tracing.html#GUID-045E1093-E389-4F2A-94CB-820AF356C564 ALTER SESSION SET TRACEFILE_IDENTIFIER = 'my_trace_';alter session set sql_trace=true;select count(*) from sh.TOKEI;al…
https://docs.oracle.com/cd/F19136_01/tgsql/generating-and-displaying-execution-plans.html#GUID-E4ED3145-8ABD-4F40-B044-9AEFBD89409C @?/rdbms/admin/catplan.sql conn sh/sh CREATE OR REPLACE PUBLIC SYNONYM my_plan_table for plan_table; explai…
https://docs.oracle.com/cd/F19136_01/sqpug/tuning-SQL-Plus.html#GUID-C8FBE008-B2D6-4049-A095-0747E5328A50 conn / as sysdbaalter session set container=pdb1; @$ORACLE_HOME/sqlplus/admin/plustrce.sql GRANT PLUSTRACE TO sh;
https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-D64AEB01-18FF-47EF-BB5C-A0611117D180https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-18E1B278-B3C5-4FE1-8E51-BC8878C439F5 …
