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
Archive for the ‘ORACLE Database’ Category
Oracle Database – planning the Block Size of Redo Log Files
Samstag, Januar 8th, 2022Oracle Cloud Free Tier – die kostenlosen Always Free-Cloud-Services
Montag, November 29th, 2021 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
Oracle Database 19c – duplicate a database using RMAN
Montag, November 15th, 2021 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
Oracle Lifetime Support Policies – September 2021 for Database Releases
Samstag, Oktober 30th, 2021Oracle – hat den langjährigen Streit um den Itanium Support gegen HPE verloren und muss dem Konkurrenten nun über $ 3 Milliarden Schadensersatz zahlen
Samstag, Oktober 2nd, 2021Oracle Real Application Clusters (RAC) 19c – database clustering improves scalability performance and availability
Samstag, September 18th, 2021SolarWinds Database Performance Analyzer – zeigt Leistungsprobleme auf und bietet Optimierungstipps von Experten
Mittwoch, August 11th, 2021Quest Foglight for Oracle – diagnose and resolve database performance issues with monitoring software
Samstag, Juli 31st, 2021Quest 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
Intel Xeon Scalable Processor 3rd Gen – can deliver from minmal 8 cores to 40 cores per processor
Freitag, Mai 28th, 2021Intel Xeon Scalable Processor 2rd Gen – can deliver from minmal 4 cores to 28 cores per processor
Freitag, Mai 28th, 2021Oracle Database 19c – how to use RMAN and Oracle Secure Backup (OSB) to backup an on-premises database to an AWS S3 Object Store
Sonntag, Mai 23rd, 2021 Performing Oracle RMAN backups to S3 – e.g. Amazon S3
Установка Oracle 19 Enterprise Edition (EE) в Docker – Installieren von Oracle 19 Enterprise Edition (EE) in Docker
Samstag, Februar 13th, 2021 https://github.com/oracle/docker-images/blob/main/OracleDatabase/SingleInstance/README.md
The requirements are you must have 2 CPUs / 6 GByte of the memory / 15 GByte of free storage
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# git clone https://github.com/oracle/docker-images.git
Klone nach ‚docker-images‘ …
remote: Enumerating objects: 18, done.
remote: Counting objects: 100% (18/18), done.
remote: Compressing objects: 100% (17/17), done.
remote: Total 13652 (delta 1), reused 4 (delta 0), pack-reused 13634
Empfange Objekte: 100% (13652/13652), 9.83 MiB | 5.03 MiB/s, fertig.
Löse Unterschiede auf: 100% (7995/7995), fertig.
┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# cd docker-images/OracleDatabase/SingleInstance/dockerfiles/19.3.0
┌──(root💀vm-iot-jsho-docker-02)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─#
┌──(root💀vm-iot-jsho-docker-02)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# mv /tmp/LINUX.X64_193000_db_home.zip .
┌──(root💀vm-iot-jsho-docker-02)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# cd ..
┌──(root💀vm-iot-jsho-docker-02)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -h
Usage: buildContainerImage.sh -v [version] [-e | -s | -x] [-i] [-o] [container build option]
Builds a container image for Oracle Database.
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/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -v 19.3.0 -e
Oracle Database container image for ‚ee‘ version 19.3.0 is ready to be extended:
–> oracle/database:19.3.0-ee
Build completed in 653 seconds.
┌──(root💀vm-iot-jsho-docker-02)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─#
┌──(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
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#
# docker run –name <container name> \
-p <host port>:1521 -p <host port>:5500 \
-e ORACLE_SID=<your SID> \
-e ORACLE_PDB=<your PDB name> \
-e ORACLE_PWD=<your database passwords> \
-e INIT_SGA_SIZE=<your database SGA memory in MB> \
-e INIT_PGA_SIZE=<your database PGA memory in MB> \
-e ORACLE_EDITION=<your database edition> \
-e ORACLE_CHARACTERSET=<your character set> \
-v [<host mount point>:]/opt/oracle/oradata \
oracle/database:19.3.0-ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker run -d -it –name oracle19ee –hostname oracle19ee -p 1521:1521 -p 5500:5500 -e ORACLE_PWD=<password> oracle/database:19.3.0-ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker logs -f oracle19ee
ORACLE EDITION: ENTERPRISE
ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN:<password>
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 12-FEB-2021 08:33:21
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait…
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
XDB initialized.
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker exec -it oracle19ee /bin/bash
[oracle@oracle19ee ~]$
Oracle Enterprise Manager Database Express
https://127.0.0.1:5500/em/login
system <password> orclpdb1
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
ecb493fec6e5 oracle/database:19.3.0-ee „/bin/sh -c ‚exec $O…“ 28 hours ago Up 18 hours (healthy) 0.0.0.0:1521->1521/tcp, 0.0.0.0:5500->5500/tcp oracle19ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker stop -t 30 oracle19ee
oracle19ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker start oracle19ee
oracle19ee
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker exec -it oracle19ee /bin/bash
[oracle@oracle19ee ~]$
[oracle@oracle19ee ~]$ sqlplus pdbadmin@orclpdb1
SQL*Plus: Release 19.0.0.0.0 – Production on Sat Feb 13 17:04:15 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter password: <password>
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL>
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker commit -p oracle19ee oracle19ee.backup.20210213
sha256:ec89f8aa5c9b69a63f96aa43c433f2d34a82eebd2b699379077f49ff05179290
┌──(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
┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#
Установка Oracle 18 Express Edition (XE) в Docker – Installieren von Oracle 18 Express Edition (XE) in Docker
Donnerstag, Februar 11th, 2021Docker Official Images – Oracle Database 12c Enterprise Edition and the ‚Migration‘ to Oracle Database 19c Standard Edition 2
Donnerstag, Februar 11th, 2021https://hub.docker.com/_/oracle-database-enterprise-edition
┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# docker login
┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# docker pull store/oracle/database-enterprise:12.2.0.1
12.2.0.1: Pulling from store/oracle/database-enterprise
4ce27fe12c04: Pull complete
9d3556e8e792: Pull complete
fc60a1a28025: Pull complete
0c32e4ed872e: Pull complete
b465d9b6e399: Pull complete
Digest: sha256:40760ac70dba2c4c70d0c542e42e082e8b04d9040d91688d63f728af764a2f5d
Status: Downloaded newer image for store/oracle/database-enterprise:12.2.0.1
docker.io/store/oracle/database-enterprise:12.2.0.1
https://github.com/oracle/docker-images
┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# git clone https://github.com/oracle/docker-images.git 128 ⨯
Klone nach ‚docker-images‘ …
remote: Enumerating objects: 18, done.
remote: Counting objects: 100% (18/18), done.
remote: Compressing objects: 100% (17/17), done.
remote: Total 13652 (delta 1), reused 4 (delta 0), pack-reused 13634
Empfange Objekte: 100% (13652/13652), 9.83 MiB | 5.03 MiB/s, fertig.
Löse Unterschiede auf: 100% (7995/7995), fertig.
┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# cd docker-images/OracleDatabase/SingleInstance/dockerfiles
┌──(root💀vm-iot-jsho-docker-01)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─#
┌──(root💀vm-iot-jsho-docker-01)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -h
Usage: buildContainerImage.sh -v [version] [-e | -s | -x] [-i] [-o] [container build option]
Builds a container image for Oracle Database.
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
┌──(root💀vm-iot-jsho-docker-01)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─#
┌──(root💀vm-iot-jsho-docker-01)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# mv /tmp/LINUX.X64_193000_db_home.zip .
┌──(root💀vm-iot-jsho-docker-01)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─#
┌──(root💀vm-iot-jsho-docker-01)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# cd ..
┌──(root💀vm-iot-jsho-docker-01)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -h
Usage: buildContainerImage.sh -v [version] [-e | -s | -x] [-i] [-o] [container build option]
Builds a container image for Oracle Database.
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)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─#
# ./buildContainerImage.sh -v 19.3.0 -s
Oracle Linux Oracle Container Runtime for Docker – verify readiness of Database switchover using Data Guard Validate command
Mittwoch, Februar 10th, 2021 Oracle Data Guard ensures high availability, data protection, and disaster recovery for Oracle database. Data Guard provides a comprehensive set of services for DR solution. The services can be used to create, maintain, manage, monitor one or more standby databases, and validate the database for the readiness of role switch. Data Guard can switch any standby database manually or automatically in case the production database becomes unavailable due to a planned or unplanned outage. Data Guard minimizes the downtime associated with the outage. Oracle Data Guard is included with the Enterprise Edition and Personal Edition of the Oracle database software
Docker Container: ora19cp, ora19cs
Oracle Database version: 19.3.0.0
Oracle Database Edition: Oracle Database 19c Enterprise Edition
Container database: False