Database With SanGa

Error Description: During the recovery process on the standby database, you encounter errors such as: ORA-01111 : Name for data file is unknown. ORA-01110 : Data file is missing. ORA-01157 : Cannot identify/lock data file. These errors typically occur when a data file is created as "UNNAMED" in the $ORACLE_HOME/dbs directory, causing the Managed Recovery Process (MRP) to fail. Error Log: Errors in file /home/app/diag/rdbms/sandy04/SANDY/trace/SANDY_ora_59972.trc: ORA-01111: name for data file 30 is unknown - rename to correct file ORA-01110: data file 30: '/home/app/product/11.2.0/db_1/dbs/UNNAMED00030' ORA-01157: cannot identify/lock data file 30 - see DBWR trace file ORA-01111: name for data file 30 is unknown - rename to correct file ORA-01110: data file 30: '/home/app/product/11.2.0/db_1/dbs/UNNAMED00030' Completed standby crash recovery. Reason: The issue arises because the MRP process, while applying archives, creates an unnamed fi...

I faced an error last night when I was going to start my 12c database on upgrade mode   to upgrade 19c.   ERROR: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type Process ID: 3714866 Session ID: 434 Serial number: 1850 ORA-00603: ORACLE server session terminated by fatal error   REASON: ORA-30012 means that the default UNDO tablespace you specified in SPFILE or PFILE does not exist, or it's not an UNDO tablespace essentially. Therefore, the database fails to startup. SOLUTION: We should identify and set the correct undo tablespace name.   ACTION: 1. log in the database on mount mode   SQL> startup mount; ORACLE instance started.   Total System Global Area 1.2482E+10 bytes Fixed Size                   8939000 bytes Variable Size      ...

I faced an error last night when I was going to recover my 12c database after restoration new environment.   ERROR: RMAN-03002: failure of recover command at 11/28/2023 06:12:57 RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/path/to/recovery file destination/o1_mf_1_235860_lpbxjrbh_.arc' ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K   REASON: There has been no memory allocated to 8K or 16K or 32K block buffers cache. Explicitly allocating memory to the non-default block buffers will resolve the ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K or 16K or 32K errors   ACTION: 1. log in the database 2. check parameter DB_16K_CACHE_SIZE and set value   SQL> show parameter DB_16K_CACHE_SIZE;   NAME                       ...

There was an issue regarding expired archives did not clear  at standby  as scheduled and following error was raise. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of delete command at 07/09/2023 16:00:03 ORA-06540: PL/SQL: compilation error ORA-06553: PLS-252: reference to the wrong copy of package STANDARD Recovery Manager complete. SOLUTION: 1. Restart the standby database 2. Flush shared pool t o clear the whole shared pool you would issue the following command from a privileged user. ALTER SYSTEM FLUSH SHARED_POOL;

WARNING: File being created with same name as in Primary Existing file may be overwritten Errors in file /home/oradata/DB/DB_pr00_12979.trc: ORA-01119: error in creating database file '/home/oracle/oradata/data_TS_FNO-62' ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Linux-x86_64 Error: 13: Permission denied File #64 added to control file as 'UNNAMED00064'. Originally created as:'/home/oracle/oradata/data_TS_FNO-62' Recovery was unable to create the file as:'/home/oracle/oradata/data_TS_FNO-62' MRP0: Background Media Recovery terminated with error 1274 Errors in file /home/oradata/DB/DB_pr00_12979.trc: ORA-01274: cannot add datafile '/home/oracle/oradata/data_TS_FNO-62' - file could not be created Managed Standby Recovery not using Real Time Apply SOLUTION: alter database create datafile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00064' as '/home/oracle/oradata/data_TS_FNO...