💡 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: …
-
OracleTroubleshoot
ORA-16795: the standby database needs to be re-created, Recreate DB Broker
by tuanlpby tuanlp<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. …
-
OracleTroubleshoot
ORA-17628: Oracle error 19505 returned by remote Oracle server: RMAN Duplicate
by tuanlpby tuanlp💡 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;
-
OracleTroubleshoot
Oracle Client: INS-32025: The chosen installation conflicts with software already installed in the given Oracle home
by tuanlpby tuanlp💡 [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 …