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…
Month: October 2019
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…