
Carlos Magno – EzDBA
237 FOLLOWERS
Carlos Magno – Experience of over 15 years as Oracle DBA on complex projects in countries such as Brazil, India, the Netherlands, Luxembourg, France and Italy. Blog with useful information for Oracle DBAs , Oracle DBM, Infrastructure Admin etc. Information about Oracle DBs, Oracle EM, Cloud, Exadata, Sun Cluster, Golden Gate and etc. Cloud: Backup Database - Using Oracle Cloud Engineered..
Carlos Magno – EzDBA
3y ago
– Be sure that the BUG Fix (18633374) is applied on the Source Database:
— The PSU 12.1.0.2.190416 or higher should be applied also on the source.
*** On-Premises:
1.) Check Status of the Source Database:
SQL> select * from gv$pdbs where con_id=13;
INST_ID CON_ID DBID CON_UID GUID NAME OPEN_MODE RES OPEN_TIME CREATE_SCN TOTAL_SIZE BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID
1 13 168895093 168895093 8837DFB294B8214DE054020820D8D4F1 PDBTEST ..read more
Carlos Magno – EzDBA
3y ago
— Table Compression
https://oracle-base.com/articles/11g/dbms_compression-11gr2
https://www.oracle.com/us/assets/lad-2015-ses16380-pedregal-2604876.pdf
http://www.bestremotedba.com/2017/01/25/how-to-advance-compression-12c/
https://www.morganslibrary.org/reference/compression.html
--- MOS Notes- Advanced Compression Master Note(Doc ID 1223705.1)– How to compress a table that is online(Doc ID 1353967.1)– Advanced Compression critical patches(Doc ID 1061366.1)– Redo Transport compression with Data Guard (Doc ID 729551.1)– How to see if rows are compressed in a table(Doc ID 1477918.1)
--- Test ..read more
Carlos Magno – EzDBA
3y ago
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-monitoring.html#GUID-56D5DEDC-6999-4BA5-A6B8-1816A8528405
select * from v$cell;
--------------------------------------------------------------------------------------------------------------------------------------
select * from V$BACKUP_DATAFILE;
--------------------------------------------------------------------------------------------------------------------------------------
SELECT name, value/1024/1024 MB FROM v$sysstat a WHERE
a.name = 'physical read total bytes' OR
a.name = 'physical w ..read more
Carlos Magno – EzDBA
3y ago
--- Using OCI and Database JSON
https://oracle-base.com/articles/12c/json-support-in-oracle-database-12cr1
https://stackoverflow.com/questions/44149124/load-a-json-file-from-filestsystem-to-oracle-database
https://docs.oracle.com/database/121/SQLRF/functions092.htm#SQLRF56973
On this example i am going to show , based on the oci cli output,
how to insert and query a JSON Data on database.
The file is based on REGIONS list from Oracle Cloud.
--- Including JSON into a table:
Json File: based on OCI CLI - Regions
C:\Users\candrade>oci iam region list --output table ..read more
Carlos Magno – EzDBA
3y ago
Hi All, this is the roadmap that just came out from Oracle Open World 2018, have a look into the Roadmap and stay tunned….
ATP_Overview_and_Roadmap_2018 ..read more
Carlos Magno – EzDBA
3y ago
Steps to convert the Standard Database to Enterprise Edition… in a real world…
How to Convert Oracle Database 12c from Standard to Enterprise Edition ? (Doc ID 2046103.1)
1.) Take a FULL backup of the database, if possible OFFLINE;
2.) Install the new binary in the different ORACLE_HOME;
3.) Check the PATCHES, the new ORACLE_HOME should be at least on the same level of PATCHES. So , if needed apply the PSUs / One-OFFs …
4.) If you are using the GRID Infrastructure, the ORACLE_HOME must be changed with srvctl;
5.) create pfile from spfile in order to keep the current INIT of the database;
6.) S ..read more
Carlos Magno – EzDBA
3y ago
On the link below you will find the steps to apply patch over a DBSystem in Oracle Cloud. DBSystem is different comparing with just a Database in cloud. There you can find already runing the ASM Instance and CRS runing.
Enjoy….
PatchDBSystem ..read more
Carlos Magno – EzDBA
3y ago
On this post i will show how to apply patch on Oracle Database inside of Oracle Cloud.
1.) Choose your database
2.) Checks the Avalilables Patches… On this case we have 1…
3.) Before apply the patch you should execute the PreCheck option, in order to see if there is some issue…
For the first time I faced this issue during the Pre-Check
Precheck failed due to incorrect Cloud tooling version and latest Cloud tooling update not available . “No applicable dbaastools rpms found” (Doc ID 2400143.1)
The Solution (If your DBAASTOOLS is older than 18.2.3.1.0):
[opc@db02 ~]$ sudo su –
[root@db02 ..read more
Carlos Magno – EzDBA
3y ago
On this post i will show the steps in order to create an Oracle Database on Oracle Cloud and connect…
1.) Connect o Oracle Cloud, on this case a create a Trial Login, you will receive an amount to try create a lot of stuffs… it’s nice to know better the platform…
It’s easy when you use the Guided Journey
You choose the Integrate, Store and Analyze Data option…
Here you can choose the best option… I choose the Custom in order to explore more the options…
Here i am no setting up the backup strategy, in another post i will explore more about that…
Check also here the Time Zone appropriate for ..read more
Carlos Magno – EzDBA
3y ago
Quarterly Full Stack Download Patch For
Oracle Exadata (Apr 2018 – 18.0.0.0)
Version
Software
Notes See Note 1270094.1 for additional fixes that
address critical issues.
18.1.5.0.0
Patch
27503194 – Storage server and InfiniBand switch software (18.1.5.0.0.180506)
Patch
27561908 – x86-64 Database server bare metal / domU ULN
exadata_dbserver_18.1.5.0.0_x86_64_base OL6 channel ISO image
(18.1.5.0.0.180506)
Patch
27561909 –
x86-64 Database server dom0 ULN
exadata_dbserver_dom0_18.1.5.0.0_x86_64_base OVM3 channel ISO image
(18.1.5.0.0.180506)
Recommended for al ..read more