2025-02-01から1ヶ月間の記事一覧
https://docs.oracle.com/cd/F19136_01/bradv/rman-complete-database-recovery.html#GUID-D908719C-9D46-4084-850C-0F81C25094EB system表データファイル損失srvctl stop database -d crmcd +DATA/CRM/datafilecp SYSTEM.285.1182371633 /tmprm SYSTEM.285.…
https://docs.oracle.com/cd/F19136_01/bradv/rman-complete-database-recovery.html#GUID-D908719C-9D46-4084-850C-0F81C25094EB system表データファイル損失 cd /oradata/orcl/mv system01.dbf system01.dbf.1 restore database;recover database; ユーザ…
https://docs.oracle.com/cd/F19136_01/bradv/backing-up-database.html#GUID-344F4D14-AC81-4093-B921-6403EE75112C 圧縮バックアップ全体バックアップ差分増分バックアップ累積増分バックアップ増分更新バックアップ高速増分バックアップ長期用アーカイブ…
https://docs.oracle.com/cd/F19136_01/bradv/backing-up-database.html#GUID-655DC5F5-FF8D-4A73-B67D-F5AAE20CA382 rman target / BACKUP PLUGGABLE DATABASE pdb11; BACKUP PLUGGABLE DATABASE pdb12,pdb13;
https://docs.oracle.com/cd/F19136_01/bradv/backing-up-database.html#GUID-B416FCDB-1EA1-48F8-8162-F9181A75B6BB rman target / BACKUP DATABASE ROOT; backup pluggable database 'CDB$ROOT';
フラッシュバックテーブルhttps://docs.oracle.com/cd/F19136_01/bradv/rman-performing-flashback-dbpitr.html#GUID-FF315DFC-ABBC-410D-ABDB-75FA89D43255 sqlalter session set container=pdb11; drop user test cascade;create user test identified by …
https://docs.oracle.com/cd/F19136_01/bradv/backing-up-database.html#GUID-22AFE123-0D60-4194-9DE0-C4C0884BAEF9 rman target / CONFIGURE DEVICE TYPE disk PARALLELISM 2; BACKUP INCREMENTAL LEVEL 0 SECTION SIZE 10M tablespace users; BACKUP INCR…
https://docs.oracle.com/cd/F19136_01/bradv/backing-up-database.html#GUID-6F1B35CC-9292-4A78-9E64-9206CB8EDFF8 rman target / BACKUP AS COPY SECTION SIZE 1G DATABASE; list backup;list copy; exit
https://docs.oracle.com/cd/F19136_01/bradv/rman-recovering-tables-partitions.html rman target / backup database plus archivelog;list backup; exit sqlplus test/test@pdb11;select count(*) from sh.sales;select current_scn from v$database;drop…
https://docs.oracle.com/cd/F19136_01/dwhsg/attribute-clustering.html#GUID-589A37EE-61C9-4F12-BD8F-CB12F3A67675 sqlplus test/test@pdb11 SELECT TABLE_NAME, CLUSTERING FROM DBA_TABLES WHERE OWNER='TEST'; SELECT owner, table_name, clustering_t…
https://docs.oracle.com/cd/F19136_01/dwhsg/attribute-clustering.html sqlplus test/test@pdb11 SELECT TABLE_NAME, CLUSTERING FROM DBA_TABLES WHERE OWNER='TEST'; SELECT owner, table_name, clustering_type, on_load, on_datamovement, with_zonema…
https://docs.oracle.com/cd/F19136_01/inmem/populating-objects-in-memory.html#GUID-452D19AE-EB5F-44AC-A1AD-70CF10D2D347 sqlplus test/test@pdb11 ALTER TABLE SH.CHANNELS INMEMORY MEMCOMPRESS FOR QUERY ( CHANNEL_ID, CHANNEL_DESC ) INMEMORY MEM…
https://docs.oracle.com/cd/F19136_01/inmem/populating-objects-in-memory.html#GUID-C5D0A470-C06A-4EE2-AA1A-B221FFEB663B ・オンデマンド移入デフォルトでは、INMEMORY PRIORITYパラメータはNONEに設定されています。この場合、データベースでは、オブ…
https://cloud.google.com/dataflow/docs/quickstarts/create-pipeline-python?hl=ja -- 1. 前作業 gcloud initgcloud auth list gcloud --version gcloud projects create project01-9999999 \--name="project01" gcloud config listgcloud config set proj…
https://docs.oracle.com/cd/F19136_01/inmem/populating-objects-in-memory.html#GUID-636A1675-838D-4004-9CDB-70783DC72C6B 表領域新規作成 表領域変更 sqlplus test/test@pdb11show parameter memory CREATE TABLESPACE tbs05 DATAFILE '/oradata/orcl/p…
https://docs.oracle.com/cd/F19136_01/inmem/enabling-the-im-column-store.html show parameter inmemoryalter system set INMEMORY_SIZE=128M scope=spfile; shutdown immediatestartupshow parameter inmemory
