2025-02-01から1ヶ月間の記事一覧
https://docs.oracle.com/cd/E96517_01/multi/creating-a-proxy-pdb.html#GUID-4453DF44-5D16-4581-9CBF-0C7BCA85DE82 ※プロキシPDBのセッションでは、パスワード認証のみがサポートされます。 create database link PROD1 connect to system identified by …
https://docs.oracle.com/cd/F19136_01/dbseg/configuring-authentication.html#GUID-22328DCF-B137-499B-ACC9-49D6C72B6A57 https://qiita.com/plusultra/items/65ffb3f0282b6335e154 https://docs.oracle.com/cd/F19136_01/dbseg/configuring-authenticati…
https://docs.oracle.com/cd/F19136_01/multi/administering-application-containers-with-sql-plus.html#GUID-AAF93A02-7C70-4024-8758-E351C213543E -- 1. アプリケーションコンテナの作成 show parameter db_create_file_dest show pdbs; CREATE PLUGGABL…
https://docs.oracle.com/cd/F19136_01/multi/creating-removing-application-containers-seeds-with-sql-plus.html#GUID-E2B95068-D16D-438D-9A0B-974540988990https://docs.oracle.com/cd/F19136_01/multi/administering-application-containers-with-sql-…
https://docs.oracle.com/cd/F19136_01/rcmrf/CROSSCHECK.html#GUID-07E07E7E-9A29-4901-9739-FFC472029A7D rman target / list backup;list copy;list archivelog all; crosscheck backup;crosscheck copy;crosscheck archivelog all; list expired backup;…
Ubuntu (24)https://zenn.dev/kabec_dev/articles/29ccf90d636523 uname -rls -l /lib/modules sudo cat /boot/grub/grub.cfgsudo cat /boot/grub/grub.cfg | grep -e 'menuentry ' -e 'submenu' sudo grep 'menuentry ' /boot/grub/grub.cfg | cut -f 2 -d …
Ubuntu (24)https://hachi-world.com/2024/12/08/how-to-check-linux-installed-datetime/ stat /stat / | grep -i "Birth" ls -lact --full-time /etc/ ls -lact --full-time /etc/ | awk 'END {print $6,$7,$8}' Debian (12)https://hachi-world.com/2024/…
https://docs.oracle.com/cd/F19136_01/bradv/rman-performing-flashback-dbpitr.html#GUID-C1215E86-9A7B-4EC9-9777-2A18BD627394 sql SELECT * FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME='LOCAL_UNDO_ENABLED'; select flashback_on from v$database;…
https://docs.oracle.com/cd/F19136_01/multi/managing-security-for-a-multitenant-environment.html#GUID-AB5E62DB-7E2A-4B5A-BA96-A2BD2DF15275 conn / as sysdba SET LINESIZE 150COL PROFILE_NAME FORMAT a20COL RULE FORMAT a20COL CLAUSE FORMAT a25 …
推奨スペック-- オンプレミス環境 -- CPU: 2コア以上メモリ: 4GB以上システムディスク: 60GB以上データディスク: 10GB以上 Ubuntu (22)https://pleasanter.org/ja/manual/getting-started-pleasanter-ubuntuPleasanter: 1.4.13 -- 1. .NETのセットアップ sud…
https://docs.oracle.com/cd/F19136_01/multi/cloning-a-pdb.html#GUID-133B6D33-3B52-433B-9C85-C4BEE4F7284E The PDB Snapshot Carousel is feature is only available for EE-ES (Exadata with Extra cost option),and Cloud Platform: DBCS EE, DBCS EE-…
https://docs.oracle.com/cd/F19136_01/multi/cloning-a-pdb.html#GUID-22118625-3157-4C38-8A88-79A561A3E6ED The PDB Snapshot Carousel is feature is only available for EE-ES (Exadata with Extra cost option),and Cloud Platform: DBCS EE, DBCS EE-…
https://docs.oracle.com/cd/F19136_01/multi/administering-pdb-snapshots.html#GUID-FF6DF540-0C22-451C-80B3-1ACA8C8CB7D2 The PDB Snapshot Carousel is feature is only available for EE-ES (Exadata with Extra cost option),and Cloud Platform: DBC…
https://docs.oracle.com/cd/F19136_01/ladbi/enabling-read-only-oracle-home.html 読取り専用Oracleホームを有効にするには: 1. ソフトウェアのみのOracle Databaseインストールを実行します。2. roohctl -enableスクリプトを実行します。3. Oracle Databa…
https://docs.oracle.com/cd/F19136_01/admin/managing-space-for-schema-objects.html#GUID-918AD789-47B8-4B11-9016-184D1B0D9AD4 sqlplus test/test@pdb11 variable id number;begin declare name varchar2(100); descr varchar2(500); obj_id number; be…
https://docs.oracle.com/cd/F19136_01/tgsql/optimizer-statistics-advisor.html#GUID-EA9D4850-A988-462D-BBDE-E6299F6F0D75 -- 1. オプティマイザ統計アドバイザ・タスクの作成 sqlplus test/test@pdb11 alter session set nls_date_format='YYYY-MM-DD H…
https://docs.oracle.com/cd/F19136_01/tgsql/sql-access-advisor.html#GUID-816A7103-440D-4AB8-8ED5-BD4DBDEBB283 grant ADMINISTER SQL TUNING SET to sh; sqlplus sh/sh@pdb11 -- 1. SQLチューニング・セットの作成SET SERVEROUTPUT ON;VARIABLE task_id…
https://docs.oracle.com/cd/F19136_01/tgsql/sql-tuning-advisor.html#GUID-F5494CD1-52BB-478E-BB36-17104B36B0FE sqlalter session set container=pdb11;grant ADVISOR to hr; sqlplus hr/hr@pdb11 SELECT /*+ ORDERED */ * FROM employees e, locations …
https://docs.oracle.com/cd/F19136_01/bradv/rman-duplicating-databases.html 非CDB(PROD2 → PROD12)CDB(PROD1 → PROD11)新しいCDBとともにPDBを複製(PROD1:PDB11 → PROD13:PDB11)既存の別CDBに指定したPDBを複製(orcl:PDB11 → PROD1:PDB24) vim ~/.bashrc…
https://docs.oracle.com/cd/F19136_01/admin/transporting-data.html#GUID-F7B2B591-AA88-4D16-8DCF-712763923FFBhttps://docs.oracle.com/cd/F19136_01/bradv/creating-transportable-tablespace-sets.html#GUID-123F4E45-0324-4D1D-980F-E176A9E22C87 -- …
https://docs.oracle.com/cd/F19136_01/multi/backing-up-and-recovering-cdbs-and-pdbs.html#GUID-86822B10-B187-4E41-9A8F-93BFFBD143E9https://docs.oracle.com/cd/F19136_01/bradv/rman-complete-database-recovery.html#GUID-8D0D3B72-C618-4AD2-902A-6…
https://docs.oracle.com/cd/F19136_01/rcmrf/RECOVER.html rman target / report schema; backup datafile 62,13; alter database datafile 62 offline ; -- pdb11で実行alter database datafile 13 offline ; restore datafile 62,13;recover datafile 62,…
https://docs.oracle.com/cd/F19136_01/bradv/performing-rman-tspitr.html alter database default tablespace AAA; rman target / report schema; delete noprompt backup;backup database plus archivelog delete input; LIST RESTORE POINT ALL; DROP RE…
https://docs.oracle.com/cd/F19136_01/rcmrf/RECOVER.html rman target / report schema; backup tablespace users,PDB11:USERS; -- rootとpdb11で実行alter tablespace users offline immediate; restore tablespace users,PDB11:USERS;recover tablespace…
https://docs.oracle.com/cd/F19136_01/bradv/rman-block-media-recovery.html dd if=/dev/zero of=/fra/orcl/users01.dbf bs=8k conv=notrunc seek=20 count=1 dbv file=/fra/orcl/users01.dbf rman target / validate database; select * from v$database_…
https://docs.oracle.com/cd/F19136_01/rcmrf/SWITCH.html#GUID-BEA73581-C6F4-4346-A61B-B6C19513BF1C rman target / report schema; RUN{ ALTER DATABASE DATAFILE 7 OFFLINE; SET NEWNAME FOR DATAFILE 7 TO '/fra/orcl/users01.dbf'; RESTORE DATAFILE 7…
https://docs.oracle.com/cd/E82638_01/bradv/configuring-rman-client-advanced.html#GUID-433BCC86-BA70-4D37-B9C3-92BACFAE72E8 rman target /select * from v$encryption_wallet; show all;CONFIGURE ENCRYPTION FOR DATABASE ON;SET ENCRYPTION IDENTIF…
https://docs.oracle.com/cd/E82638_01/bradv/configuring-rman-client-advanced.html#GUID-00CCDDB4-E999-4956-AF30-15E7D622908B rman target /select * from v$encryption_wallet; show all;CONFIGURE ENCRYPTION FOR DATABASE ON;delete noprompt backup…
https://docs.oracle.com/cd/E82638_01/bradv/configuring-rman-client-advanced.html#GUID-8D85E7DF-53FE-4AF8-811B-CA836B737B36 rman target / show all;SET ENCRYPTION IDENTIFIED BY oracle only;delete noprompt backup;backup database plus archivel…
https://docs.oracle.com/cd/F19136_01/bradv/rman-performing-flashback-dbpitr.html#GUID-7D3EE2F7-77A2-4264-8875-CC0AEC64ABE0 時間ベース変更ベースログ順序番号リストアポイントAVAILABLE REDO export NLS_LANG=American_America.AL32UTF8export NLS_D…
