I have executed a database migration by transitioning from a physical active data guard to a primary database. Subsequent to the migration, I observed that several data files were offline, as evidenced below: Modifying the status of each individual data file would require a substantial amount of time. To provide an illustrative example: In order to streamline the operation, I devised a PL/SQL procedure that effectively places all data files offline across all tablespaces within the database, subsequently modifying their statuses to online, as illustrated below: I hope this post…
Category: Oracle Dataguard
Archive log not deleting within retention policy
I was managing an ORACLE RAC database configured with Oracle Data Guard when I discovered the archive log was not being deleted after the retention policy of 2 days in our backup configuration. Therefore, I started the investigation by collecting some information from the alert log. And the first initiative I took was to verify if the database had been deleting old archives when there was a space pressure in the recovery area as below: It is a cheerful and ordinary Oracle database approach to automatically deleting unneeded files. The…
Enabling Active Data Guard in Physical Standby Database
Active Data Guard is the option when the standby database is configured to be in its status open with read-only mode. As explained below in the white paper “Oracle (Active) Data Guard 19c Real-Time Data Protection and Availability,” there are some benefits, dated March 2019: With this in mind, the current post is about enabling your Physical Standby database as an Active Data Guard. Taking as a primary step that you already have a configured Physical Standby database, this post follows the procedures below: All these steps mentioned above, except…
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…
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x2425E8B, qkaProjRwo()+139] [flags: 0x0, count: 1]
“Opinions expressed are solely my own and do not express the views or opinions of my employer.” After applying the rollback from the Critical Patch Updates PATCH 33583921 – GI Jan 2022 Release Update 12.2.0.1.220118 at both Oracle RAC Databases 12.2.0.1 and GRID 12.2.0.1, I found the following messages on the alert log of the database: After some investigation, I found that the error “ORA-7445 [kcbm_sim_one()+1288] [SIGSEGV]” is very generic and often the argument [kcbm_sim_one()] is related to many known bugs on the Oracle database from versions 10.1 to 10.4.…
Oracle Data Guard 12c: ORA-01110: data file 0000: ‘$ORACLE_HOME/dbs/UNNAMED0ZZZ’
“Opinions expressed are solely my own and do not express the views or opinions of my employer.” Oracle Data Guard is a great Oracle product that ensures high availability, data protection, and disaster recovery for enterprise data. However, as with any other product, sometimes there are some issues that appear and it is needed to be solved. Therefore, the post today will be about the error “ORA-01110: data file 0000: ‘$ORACLE_HOME/dbs/UNNAMED0ZZZ’”. Many causes can lead to this error but one that I can point out is when the primary database…
ORAPWD : Password complexity failed for SYS user
I was creating an Oracle Data Guard environment when I got the following error while I was creating the password file: And the reason behind this error is that Oracle Corporation has been working hard to ensure more security in their database releases. Therefore, from the Oracle database release version 12.2, Oracle has changed some policies within passwords, and due to it, no longer weak passwords are allowed unless you want to. The new requirements about passwords that are allowed can be found in the chapter “3 Configuring Authentication” of…
Implementing Oracle Data Guard Broker 19c in an Oracle Standby RAC Database
Before I start, I would like to do a disclaimer and say that this is a procedure that might help you. However, I do not recommend you test it in a production environment before reading Oracle documentation and notes to understand the concepts that I will write here. Oracle Data Guard Broker is a utility that can help you manage your Oracle Data Guard. Among many benefits of using this utility, I highlight that while using it, it will not need manual intervention to recover the databases or eventually a…
Oracle Data Guard 19c: rfs (PID:11969): Possible network disconnect with primary database
One of the essential things in the configuration of Oracle Data Guard and Oracle Data Guard Broker is where the file tnsnames.ora is placed, which by default, from some other early releases of 19c it has been defined at $ORACLE_HOME/network/admin. However, in one of the environments that I was providing some job as a consultant, I could see the following outputs from the Oracle Data Guard broker utility : Just a brief explanation on the output above to make it easier to understand from now on: Standby database has db_unique_name…
Active Data Guard feature: since 11g keeping your Oracle Data Guard open in read-only mode, and still applying redo information
The active Data Guard feature is not something new. It has been on since Oracle Database version 11g, but it is the first time I am writing about it on my blog (I think so!), and I think it is always nice not to miss anything on our career path. So here we go! Before Oracle Database version 11g, it was already possible to open Oracle Data Guard in open mode. Still, there were some complications, e.g., when it was needed to recover the standby database. Thinking on that, Oracle…