Database/Oracle (118) 썸네일형 리스트형 119 - [Oracle 19C] Backup for pluggable db and restoring Backup for pluggable db and restoring [oracle@test ~]$ rman target=/ Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 27 17:22:28 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1680360448) RMAN> RMAN> list backup of database orclpdb; using target database control file instead of recovery ca.. 118 - [Oracle 19C] Full backup for CDB and restoring Full backup for CDB and restoring # RMAN 을 위해서는 ARCHIVELOG mode = on, configure 'fast recovery area' 할 것. 2023.12.28 - [Database/Oracle] - 116 - [Oracle 19C] Enableing ARCHIVELOG mode. 116 - [Oracle 19C] Enableing ARCHIVELOG mode. Enableing ARCHIVELOG mode. show user; show con_name; /* USER is "SYS" CON_NAME ------------------------------ CDB$ROOT */ select * from v$logfile; /* GROUP# STATUS TYP.. 117 - [Oracle 19C] Configuring fast recovery area Configuring fast recovery area show user; show con_name; /* USER is "SYS" CON_NAME ------------------------------ CDB$ROOT */ The fast recovery area is an Oracle managed directory file system, or Oracle automatic storage management disk group that provides centralized storage for backup and recovery files. The fast recovery area is usually used to store the Oracle archived redo logs, the databas.. 116 - [Oracle 19C] Enableing ARCHIVELOG mode. Enableing ARCHIVELOG mode. show user; show con_name; /* USER is "SYS" CON_NAME ------------------------------ CDB$ROOT */ select * from v$logfile; /* GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE CON_ID ---------- ------- ------- ---------------------------------------- ------------------------- ---------- 3 ONLINE /u01/app/oracle/oradata/ORCL/redo03.log NO 0 2 ONLINE /u01/app/oracle/oradata/O.. 115 - [Oracle 19C] External table with PARTITIONS External table with PARTITIONS show user show con_name /* USER is "HR" CON_NAME ------------------------------ ORCLPDB */ CREATE TABLE sales_by_country (trans_id number, trans_amount number, country varchar2(3)) PARTITION BY LIST (country) (PARTITION c1 VALUES ('USA'), PARTITION c2 VALUES ('JOR') ); /* Table SALES_BY_COUNTRY created. */ SELECT table_name, partition_name, high_value, partition_po.. 114 - [Oracle 19C] SQL*Loader express mode SQL*Loader express mode The main benefit of SQL*Loader express mode is the savings for time and effort that results from not needing to write and test a SQL*Loader control file. Instead, you specify a single SQL*Loader command with a few parameters and the load starts. Another benefit of express mode is that it will try to use the fastest mechanism for loading data files: external tables using p.. 113 - [Oracle 19C] SQL*Loader Loading Methods - Direct Path Load Direct Path Load (DIRECT=TRUE) Uses data saves (faster operation) Generates redo only under specific conditions Enforces only PRIMARY KEY, UNIQUE, and NOT NULL Does not fire INSERT triggers Does not load into clusters Prevents other users from making changes to tables during load operation show user; show con_name; /* USER is "HR" CON_NAME ------------------------------ ORCLPDB */ create table d.. 112 - [Oracle 19C] SQL*Loader Loading Methods - Conventional Load Conventional Load Uses COMMIT Always generates redo entries Enforces all constraints Fires INSERT triggers Can load into clustered tables Allows other users to modify tables during load operation The insertion of an array ofrecords is followed by a COMMIT operation. Each data load may involve several transactions. SQL> show user; USER is "HR" SQL> show con_name CON_NAME -------------------------.. 이전 1 2 3 4 ··· 15 다음