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…
Year: 2019
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…
Move an Oracle database from on-prem to AWS : EC2 or RDS?
Now with Cloud, many customer want to move their database On-Prem to some clouds as AWS, Oracle and IBM. Here I describe the differences if you want to move your Oracle database On-Prem to Amazon AWS. EC2: You manage the database at AWS by yourself. RDS (RELATIONAL DATABASE SERVICE) : Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations . Then if the customer chooses for EC2 you have these migrations options: Migrating Oracle database…
ODTUG Kscope19- Seattle, Washington
ODTUG Kscope is the premier educational conference for Oracle technology users, attracting Oracle experts from all over the globe. No other conference in the Oracle world features this kind of development-specific training and content, including lessons learned by other companies facing similar challenges and hundreds of opportunities to discover money-saving techniques. ODTUG Kscope offers a dynamic experience and a unique learning environment for attendees, with over 300 technical sessions, hands-on training, all-day symposiums, and networking with Oracle experts. In this video I would like to thank: 1:28- Dan Goerdt (President…