DTM Migration Kit– is an advanced data management tool that designed for the multi-vendor environment and rarely used database support. It allows user database administrator or developer to import data from most popular formats to export database content to migrate data from different data sources
Planning the Block Size of Redo Log Files – unlike the database block size which can be between 2K and 32K redo log files always default to a block size that is equal to the physical sector size of the disk historically this has typically been 512 bytes (512B) some newer high-capacity disk drives offer 4K byte (4K) sector sizes for both increased ECC capability and improved format efficiency most Oracle Database platforms are able to detect this larger sector size the database then automatically creates redo log files with a 4K block size on those disks
Oracle Cloud Free Tier – Always Free Cloud Services with
2 AMD-basierte Compute-VMs mit jeweils 1/8 OCPU / 1 GB Speicher
4 Arm-basierte Ampere A1-Kerne und 24 GB Speicher verwendbar als eine VM oder bis zu 4 VMs
2 Blockvolumes-Speicher insgesamt 200 GB
10 GB Objektspeicher
10 GB Archivspeicher
Resource Manager verwaltet mit Terraform
5 OCI Bastions
RMAN has the ability to duplicate or clone a database from a backup or from an active database it is possible to create a duplicate database on a remote server with the same file structure a remote server will a different file structure or the local server with a different file structure
Quest Foglight for Oracle – you get unrivaled performance information and advanced Oracle monitoring to prevent costly downtime. This monitoring software provides alerting and notifications, real-time and historical diagnostics, as well as reporting, plus unmatched analytics of collected data. Take Oracle monitoring to the next level with Foglight for Oracle
Parameters: -v: version to build Choose one of: 11.2.0.2 12.1.0.2 12.2.0.1 18.3.0 18.4.0 19.3.0 -e: creates image based on ‚Enterprise Edition‘ -s: creates image based on ‚Standard Edition 2‘ -x: creates image based on ‚Express Edition‘ -i: ignores the MD5 checksums -o: passes on container build option
* select one edition only: -e, -s, or -x
LICENSE UPL 1.0
Copyright (c) 2014,2021 Oracle and/or its affiliates.
┌──(root💀vm-iot-jsho-docker-02)-[~] └─# docker images REPOSITORY TAG IMAGE ID CREATED SIZE oracle/database 19.3.0-ee 28f2ce0e86dc 15 minutes ago 6.67GB
TNSLSNR for Linux: Version 19.0.0.0.0 – Production System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora Log messages written to /opt/oracle/diag/tnslsnr/oracle19ee/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ———————— Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production Start Date 12-FEB-2021 08:33:21 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora Listener Log File /opt/oracle/diag/tnslsnr/oracle19ee/listener/alert/log.xml Listening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) The listener supports no services The command completed successfully . Prepare for db operation 8% complete Copying database files 31% complete Creating and starting Oracle instance 32% complete 36% complete 40% complete 43% complete 46% complete Completing Database Creation 51% complete 54% complete Creating Pluggable Databases 58% complete 77% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /opt/oracle/cfgtoollogs/dbca/ORCLCDB. Database Information: Global Database Name:ORCLCDB System Identifier(SID):ORCLCDB Look at the log file „/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log“ for further details.
SQL*Plus: Release 19.0.0.0.0 – Production on Fri Feb 12 08:50:20 2021 Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.3.0.0.0
SQL> System altered.
SQL> System altered.
SQL> Pluggable database altered.
SQL> PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.3.0.0.0 The Oracle base remains unchanged with value /opt/oracle ######################### DATABASE IS READY TO USE! ######################### The following output is now a tail of the alert.log: ORCLPDB1(3):ALTER DATABASE DEFAULT TABLESPACE „USERS“ ORCLPDB1(3):Completed: ALTER DATABASE DEFAULT TABLESPACE „USERS“ 2021-02-12T08:50:20.389852+00:00 ALTER SYSTEM SET control_files=’/opt/oracle/oradata/ORCLCDB/control01.ctl‘ SCOPE=SPFILE; 2021-02-12T08:50:20.395466+00:00 ALTER SYSTEM SET local_listener=“ SCOPE=BOTH; ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE Completed: ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
┌──(root💀vm-iot-jsho-docker-02)-[~] └─# docker images REPOSITORY TAG IMAGE ID CREATED SIZE oracle19ee.backup.20210213 latest ec89f8aa5c9b 14 minutes ago 11.5GB oracle/database 19.3.0-ee 28f2ce0e86dc 2 days ago 6.67GB
┌──(root💀vm-iot-jsho-docker-02)-[~] └─# docker save -o /tmp/oracle19ee.backup.20210213.tar oracle19ee.backup.20210213
Parameters: -v: version to build Choose one of: 11.2.0.2 12.1.0.2 12.2.0.1 18.3.0 18.4.0 19.3.0 -e: creates image based on ‚Enterprise Edition‘ -s: creates image based on ‚Standard Edition 2‘ -x: creates image based on ‚Express Edition‘ -i: ignores the MD5 checksums -o: passes on container build option
* select one edition only: -e, -s, or -x
LICENSE UPL 1.0
Copyright (c) 2014,2021 Oracle and/or its affiliates.
┌──(root💀vm-iot-jsho-docker-01)-[~] └─# cd docker-images/OracleDatabase/SingleInstance/dockerfiles/19.3.0
Parameters: -v: version to build Choose one of: 11.2.0.2 12.1.0.2 12.2.0.1 18.3.0 18.4.0 19.3.0 -e: creates image based on ‚Enterprise Edition‘ -s: creates image based on ‚Standard Edition 2‘ -x: creates image based on ‚Express Edition‘ -i: ignores the MD5 checksums -o: passes on container build option
* select one edition only: -e, -s, or -x
LICENSE UPL 1.0
Copyright (c) 2014,2021 Oracle and/or its affiliates.