Troubleshoot

 💡 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 …

💡 [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 …

 💡 While shutting down my TEST database process was hanged. Then I had to use shutdown abort. But when I wanted to start database it did not open.  Xử lý …

 💡 Bị connection time out db 1. Check the current FRA destination. SQL> show parameter db_recovery_file NAME TYPE VALUE ———————————— ———– —————————— db_recovery_file_dest string /dbaclassdb/oradata/FRA db_recovery_file_dest_size big integer 20G SQL> …

💡 After restoring an RAC database to a standalone database through RMAN, we tried to drop the redolog groups belongs to thread 2. We hit the below error. SQL> alter …

 💡 I was cloning a database from rman backup . After completion of cloning, when I did RESETLOG it failed with ORA-00392 error. RMAN> alter database open resetlogs; RMAN-00571: =========================================================== …

 💡 I was cloning a database from rman backup . After completion of cloning, when I did RESETLOG it failed with ORA-00344 error. Errors in file /u01/app/oracle/admin/icai/bdump/icai_mrp0_20855.trc: ORA-10562: Error occurred …

💡 I was cloning a database from rman backup . After completion of cloning, when I did RESETLOG it failed with ORA-00344 error. RMAN> alter database open resetlogs; RMAN-00571: =========================================================== …

💡 ERROR:ORA-01552: cannot use system rollback segment for non-system tablespace ‘ACS_RS’ ERROR: SQL State: 72000 ORA-01552: cannot use system rollback segment for non-system tablespace ‘ACS_RS’ SOLUTION: SQL> show parameter undo …