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

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

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

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

 <aside> 💡 ORA-01187: cannot read from file because it failed verification tests </aside> SQL> select file_name from dba_temp_files; select file_name from dba_temp_files * ERROR at line 1: ORA-01187: cannot read…

💡 After restoring standby database from RMAN backup, got below error, while mounting standby database,getting below error. ORA-01665: control file is not a standby control file 1. Check the database_role…