💡 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 …
Category:
Oracle
-
-
OracleTroubleshoot
ORA-01187: cannot read from file because it failed verification tests
by tuanlpby tuanlp<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 …
-
OracleTroubleshoot
Hướng dẫn active database về chế độ standby sau khi đã chuyển sang primary
by tuanlpby tuanlp💡 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 …
-
DataguardOracleTroubleshoot
Xác định lỗi transport error trong Data Guard khi dùng broker
by tuanlpby tuanlp💡 How do identify a transport error in a Data Guard setup using the broker If the broker has been setup, check the configuration basics: dgmgrl / show configuration; Configuration …
-
Error log: SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘/u01/app/oracle/oradata/RTS_NEW/system_new.dbf’ …
-
-
💡 I faced “ORA-39213: Metadata processing is not available” error during data pump import as below. impdp “‘/ as sysdba’” directory=EXPORT dumpfile=RTLS_FULL_10-09-2018_GECIS.DMP full=Y logfile=RTLS_FULL_IMP_10-09-2018_GECIS.LOG cluster=no parfile=imp.par Import: Release 12.1.0.2.0 – …
-
💡 While running the database error following error occurred: ERROR: RMAN-03009: failure of Control File and SPFILE Autobackup command on ch00 channe l at 08/16/2018 04:53:13 ORA-19504: failed to create …
-
OracleTroubleshoot
ORA-30012: undo tablespace ‘UNDOTBS1’ does not exist or of wrong type
by tuanlpby tuanlpXử lý như sau sqlplus sys/sysdba as sysdba 1. SQL> startup mount; 2. SQL>show parameter undo NAME TYPE VALUE ———————————— ———– —————————— undo_management string AUTO undo_retention integer 900 undo_tablespace string …
-
OracleTroubleshoot
Resize your Oracle datafiles down to the minimum without ORA-03297
by tuanlpby tuanlp💡 Khi resize datafile để giải phóng datafile bị thừa thì xuất hiện lỗi ORA-03297: file contains used data beyond requested RESIZE value 🚚 Solution Chạy câu lệnh sau để …