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, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc…
Day: September 26, 2022
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, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up…
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,…