I had a performance problem in one of the routine backups, so I opened a Service Request (SR) at MOS (My Oracle Support). After a few hours from the moment I opened the SR, I got a request to upload the output of a few commands. Therefore, I used a SPOOL output to create it. For those unfamiliar with how to create a SPOOL output in the RMAN utility, follow below how you can accomplish this task: brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer…
Category: Oracle Recovery Manager (RMAN)
RMAN-06429: TARGET database is not compatible with this version of RMAN
I restored a backup from an older version than the current database version. Therefore, when I tried to use the RMAN utility, I received the following errors: After executing the scripts dbmsrman.sql,dbmsbkrs.sql,prvtrmns.plb and prvtbkrs.plb under the location @$ORACLE_HOME/rdbms/admin/ as the SYS owner, I was able to use the RMAN utility as below: brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil,…
RMAN: ORA-19910: can not change recovery target incarnation in control file
I tried to reset the incarnation to its previous state when I received the following error below: After some analysis, I acknowledge that the database was OPEN. Therefore, to change the incarnation, I bounced the database, started it in the MOUNT state, and executed the operation to shift the incarnation, so it finished successfully. The evidence of this operation can be seen below: brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as…
RMAN : ORA-01145: offline immediate disallowed unless media recovery enabled
I was working on an activity that required me to set some datafile offline when I received the following error: After some analysis, I realized that the database was in no archive mode, and to be able to make a datafile offline, the database must be in archive mode. Therefore, I enabled the archive mode in the database by restarting the database in the MOUNT state, allowing the archive to mode option, and after it was possible to change the status of the database as below: brunorsHi! I am Bruno,…
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied when Primary and Standby have the same password for the password file
“Opinions expressed are solely my own and do not express the views or opinions of my employer.” I was creating a standby database and had the intention of using an active duplicate to copy the data from the primary database to the standby when I had the following error: I did all the ordinary checklist by checking if the password file on the standby file had the same password as the primary database and also by checking if the “Password file:” option configured on the srvctl “srvctl config database -d…
Oracle 12cR1: Moving tablespace by using the transportable tablespace feature from a Solaris Operating System (x86-64) to a Linux x86 64-bit system
This post will be about Cross-platform transportable tablespace. Cross-platform transportable tablespace is a technique where you can copy a tablespace from a database running in one platform to another platform. Also Cross-platform transportable tablespace isn’t the same as Cross-platform transportable database. In this instance the whole database is copied including the SYSTEM tablespace. In this post we are going to copy a tablespace from one database to another database. Then the first thing you have to know is the internal names for each platform that supports cross-platform data transport and…
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…
Simple way how to use Database Point-in-Time Recovery
There are some situations where it is relevant for DBA to use FLASHBACK or Database Point-in-Time Recovery such as when a user modifies some data incorrectly or also when an upgrade failed and if it wishes to revert the previous situation of the database among several others possibilities. With this, in this post I will be explaining in a simple way how to use Database Point-in-Time Recovery. Therefore, I will be considering some requirements for this operation be possible: – The database must be enabled in Archivelog mode: – The…
Duplicando um banco de dados no mesmo servidor
Como Administrador de banco de dados Oracle, algumas vezes somos requisitados para efetuar algumas operações de cópias de dados. Entre essas operações está uma que chamamos de Duplicate. Geralmente essa operação é executada quando precisamos copiar uma base de dados de um servidor para outro servidor. No entanto, neste artigo, decidir fazer diferente: cópia a mesma base com outro SID no mesmo servidor, o que requer mais atenção, pois a qualquer momento é possível sobrescrever a base errada se não estiver atento. Sendo assim, segue o step-by-step que elaborei:…