I have started to migrate some database On-Prem to AWS RDS. I have been migration Oracle On-Prem to AWS Oracle RDS which means that it will be a Homogeneous migration process. Then as one of the steps to migrate this database, I have taken all the DDL of the tablespaces On-Prem and decided to create in my target RDS database. Therefore, in the creation process I stuck in this error: According to Amazon documentation “Amazon RDS only supports Oracle Managed Files (OMF) for data files, log files, and control files.…
ORA-38342: heat map not enabled
I have had the brilliant idea to perform a test to be able to track the modification of database blocks, read and write access in segments made by DMLs and DDLS in one of my databases. I knew already that to do this I had just to enable the parameter heat_map from OFF to ON. So I did : Well, I have done what I thought. Now let’s create a table to check my enabled parameter: What? What happened? Am I crazy? I am 100% sure that I have the…
A friend called Data Recovery Advisor. How to recover/restore your database using this tool with RMAN?
Friends are meant to help each other. Then who can help you when you need to restore and recover your database? The answer is called Data Recovery Advisor that automatically diagnoses data failures and provides repair options to fix these failures. The commands of Recovery Advisor commands in the RMAN are LIST FAILURE, ADVISE FAILURE, REPAIR FAILURE (or REPAIR FAILURE PREVIEW before execute), and CHANGE FAILURE (to change the status or priority of your failure). However, keep in mind that you need at least a backup of the file that…
RMAN: BACKUP DATABASE KEEP FOREVER OPTION 12C
I got to know about this option when I saw a configured backup script in an environment running Oracle Database 12c with Zero Data Loss Recovery Appliance (Recovery Appliance). Then I started to search about this and although Oracle Documentation doesn’t really show a lof about this option I could understand that it is one of the types of the long-term backup retention and then the backup or copy never expires.. However, one of the prerequisite to use this option is to have a recovery catalog because the control file…
PostgreSQL 11:INITDB
Hello, So here I am writing another article about PostgreSQL. If you do not have this database installed and would like to learn and try about this database engine, check out my last post about installation: https://www.techdatabasket.com/postgresql-11-installation-on-centos-el7-x86_64/ After the installation we have to start the initdb file that creates a new PostgreSQL database cluster. This file can be invoked both through the command : Where in this case /usr/pgsql-11/bin is the directory where the software is installed by default or you can also invoke this utility using this command: Nevertheless…
Oracle Groundbreaker Nordic Tour 2019
On the 25th of October 2019, SWEOUG will host the Oracle Groundbreaker Day as a part of the Groundbreaker Nordic Tour. This FREE event will be held in Stockholm. We’re getting a fantastic line of speakers. A full day of Oracle technology. Time:08:30 – 16:30 Address: Regeringsgatan 30, Stockholm, 111 53 Registration at https://www.meetup.com/Stockholm-Oracle/events/gxmpglyznbtb/ Speakers at SWEOUG OGB Day 2019(#GroundbreakersTourNordic) Speaker: Rita Nuñez Twitter:https://twitter.com/ritan2000 About: Oracle ACE Director, Oracle Database and Oracle Cloud Specialist Blog: http://dbaoraclesoporte.blogspot.com/ Title: First Steps with Oracle Autonomous Transaction Processing Database Abstract: An autonomous database is a cloud database…
PostgreSQL 11 installation on Centos el7.x86_64
When it comes to perform the installation of the database engine Postgres SQL the link to download the software is: https://yum.postgresql.org/. Also take a look at the documentation to check the prerequisite: https://www.postgresql.org/docs/manuals/ The installation is performed using the repository and in this post I will install the version 11 on the operating system Linux centos el7.x86_64. So, let’s install the repository with the root user: Search for the installed repository using the command “yum search postgresql11”: After we have confirmed the installation of the repository, we can proceed with…
Events by year
2013: Conference: Attendee 4o. GUOB TECH DAY / OTN TOUR 2013 – August 2013 – São Paulo, Brazil 2014: Conference: Attendee 5o. GUOB TECH DAY 2014 – August 2014 – São Paulo, Brazil 2019: Workshop: Attendee March 2019 – Stockholm, Sweden. Video: https://www.youtube.com/watch?v=ADjwiIWTU4U Conference: Attendee 04th of April 2019 – Rome, Italy 2019 Oracle Code and Oracle ACE program dinner Youtube video:https://www.youtube.com/watch?v=RL2Rqh6ctk4 Post: https://www.techdatabasket.com/oracle-code-and-oracle-ace-program-dinner-rome-italy-2019/ Conference: Attendee June 2019 ODTUG Kscope19- Seattle, Washington, USA. Youtube video: https://www.youtube.com/watch?time_continue=5&v=nGki6K04KI4 Post:https://www.techdatabasket.com/odtug-kscope19-seattle-washington/ Meetup: Attendee 16th of July 2019, SWEOUG: SWEOUG: Oracle and Beer – Stockholm,…
Event- Oracle Open World 2019 – My activity list
Hello, I am delighted to inform you all that I will attend the Oracle Open World 2019 in San Francisco, California, USA. As an Oracle Ace Associate it will be my first time attending this event and I am very glad about this opportunity. This event has a very extensive agenda and to avoid being overwhelmed while attending the speeches which is also very hard. It is hard to decide which activity to join due the huge amount of quality content, here is my schedule with a DBA’s perspective: September…
Oracle Autonomous Database and DevOps: A Simple Approach to Utilization – Part 5
This article is the fifth and final part of the Oracle Autonomous Database and DevOps article series. For a better understanding, I recommend you read the articles “Oracle Autonomous Database and DevOps: A Simple Approach to Use – Part 1”, “Part 2”, “Part 3” and “Part 4” before proceeding with the steps in this article. As the previous article dealt with the creation of the Linux application server within Oracle Cloud, in this article we will proceed with the creation of microservices using Docker and connecting a JAVA application to…