tuanlp

 💡 While setting up the standby database in Oracle, the archives are not being shipped to the standby and we were continuously getting this alert when queried the V$ARCHIVE_DEST view. …

Make sure that your ORACLE_HOME and ORACLE_SID are correct To see the current values in windows, at the command prompt type echo %ORACLE_HOME% Then echo %ORACLE_SID% If the values are …

 💡 In this article I am going to give you the steps of restoring an oracle DB on a new server: Step 1: Install the Oracle Software on the new server …

💡 Recently I tried to setup some new physical standby databases and got the following strange message: DGMGRL> ADD DATABASE “XXXX” as connect identifier is “XXXX” maintained as physical; Error: …

 <aside> 💡 The Oracle database has been upgraded from 11.2.0.4 to 12.2.0.1 and the standby database (physical) was able to synchronize the data; but we see the error “ORA-16795: the …

💡 After configuring data guard, databases would be either primary and standby database role, and we can altered these roles without loss of data or without resetting logs called Switchover. …

 💡 Do không tìm thấy thư mục datafile trên máy auxiliary database server (có thể do server primary datafile để ở nhiều thư mục khác nhau) hoặc do do k …

 alter pluggable database emr open; or alter pluggable database all open; or alter session set container=emr; >startup alter session set container=CDB$ROOT; Đóng alter pluggable database all close;

💡 [INS-32025] The chosen installation conflicts with software already installed in the given Oracle home Resolved 1. Locate your central inventory location @ /etc/oraInst.loc 2 cd <oraInventory path>/oraInventory/ContextXML (In windows …

 💡 Alternate client restores of Oracle backups failing with “RMAN-06026: some targets not found – aborting restore” 🚚 Cause It shows FRA area ============================================== SQL> show parameter db_recovery_file; NAME TYPE …