RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 06/26/2024 05:32:00 RMAN-05501: aborting duplication of target database RMAN-06617: UNTIL TIME (20-JUN-24) is ahead of last NEXT TIME in archived logs (20-JUN-24) |
OracleNext - Solution to your Oracle problems
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Saturday, September 28, 2024
RMAN-06617: UNTIL TIME
Sunday, August 11, 2024
ORA-29339: tablespace block size 4096 does not match configured block sizes
SQL> create tablespace testtbs blocksize 4k datafile '+DATA' size 2m; create tablespace testtbs blocksize 4k datafile '+DATA' size 2m * ERROR at line 1: ORA-29339: tablespace block size 4096 does not match configured block sizes |
Sunday, July 28, 2024
ORA-03214: File size specified is smaller than minimum required
SQL> alter database datafile '+DATA/MYDB/19AF24AD633634AEE0632502F50A727A/DATAFILE/testtbs.5971.1170569741' resize 6m; alter database datafile '+DATA/MYDB/19AF24AD633634AEE0632502F50A727A/DATAFILE/testtbs.5971.1170569741' resize 6m * ERROR at line 1: ORA-03214: File size specified is smaller than minimum required |
Friday, June 28, 2024
RMAN-06617: UNTIL TIME (20-JUN-24) is ahead of last NEXT TIME in archived logs...
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 06/26/2024 05:32:00 RMAN-05501: aborting duplication of target database RMAN-06617: UNTIL TIME (20-JUN-24) is ahead of last NEXT TIME in archived logs (20-JUN-24) |
Wednesday, May 29, 2024
ORA-00821: Specified value of sga_target 5120M is too small, needs to be at least 12352M
Friday, May 24, 2024
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
This is a very critical error message that many applications started seeing since 12c. Prior to 12c, PGA of a server process could grow unabatedly. After the advent of PGA_AGGREGATE_LIMIT, PGA usage for all connected sessions could be limited to avoid enormous growth of PGA memory due to bad PL/SQL code (or due to an Oracle bug causing a process memory leak). Whenever total PGA usage by all sessions tries to go beyond the value set in this parameter, ORA-04036 is returned to the session and also logged in the alert log file (and trace file is also generated) . Alert log file could log error message similar to the following.
Monday, May 20, 2024
ORA-13792: This operation requires a database link
There could be other reasons for this message to appear while you are trying to execute something in a standby database (or perhaps on primary database), however, in my case, this message was returned when I was trying to create an SQL Tuning Advisor task and wanted to submit for advisor’s recommendations. While doing so, I did not realize that I was actually trying to execute this on physical standby database. Following is the entire error stack that was returned.
Friday, March 29, 2024
ORA-00371: not enough shared pool memory, should be at least 16341008384 byte
SQL> startup pfile=initaux.ora ORA-00371: not enough shared pool memory, should be at least 16341008384 bytes |
Whenever we start an oracle database instance, it requires memory to allocate some memory components of the SGA so that instance could serve the database and database sessions. If we do not specify size of memory components, we might face errors during instance startup. sga_target is the basing parameter to specify before we start an instance and other memory components like shared pool, buffer cache, or log buffer cache are allocated from the memory allocated to SGA.
Wednesday, January 10, 2024
ORA-56747: invalid value ... for parameter sga_target
SQL> alter system set sga_target=4257m; alter system set sga_target=4257m * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-56747: invalid value 4463788032 for parameter sga_target; must be smaller than parameter sga_target of the root container |
Tuesday, November 28, 2023
ORA-02149: Specified partition does not exist
If you are performing a datapump export and you are returned following error for one or more tables, this means that probably a simultaneous partition maintenance operation is in progress during this time this table was accessed for export. ORA-31693, ORA-02354, ORA-02149
ORA-31693: Table data object "<TABLE_OWNER>."<TABLE_NAME>":"<PARTITION_NAME>" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-02149: Specified partition does not exist |
Popular Posts - All Times
-
This error means that you are trying to perform some operation in the database which requires encryption wallet to be open, but wallet is ...
-
Finding space usage of tablespaces and database is what many DBAs want to find. In this article I will explain how to find out space usage ...
-
ORA-01653: unable to extend table <SCHEMA_NAME>.<SEGMENT_NAME> by 8192 in tablespace <TABLESPACE_NAME> This error is q...
-
You may also want to see this article about the ORA-12899 which is returned if a value larger than column’s width is inserted in the col...
-
This document explains how to start and stop an Oracle cluster. To start and stop Grid Infrastructure services for a standalone installatio...
-
If database server CPU usage is showing 100%, or high 90%, DBA needs to find out which session is hogging the CPU(s) and take appropriate ...
-
If you want to know how we upgrade an 11g database to 12c using DBUA, click here . For upgrading 12.1.0.1 to 12.1.0.2 using DBUA, ...
-
By default AWR snapshot interval is set to 60 minutes and retention of snapshots is set to 8 days. For better and precise investigation of...
-
SWAP space recommendation from Oracle corp. for Oracle 11g Release 2 If RAM is between 1 GB and 2 GB, SAWP should be 1.5 times the s...
-
This article explains how to install a 2 nodes Oracle 12cR1 Real Application Cluster (RAC) on Oracle Linux 7. I did this installation on O...