Posted by Mir Sayeed Hassan on 15th July 2018
ORA-16072: a minimum of one standby database destination is required This error occurs in one of our production database after restore & recover in a database open stage SQL> startup mount ORACLE instance started. Total System Global Area 396726272 bytes Fixed Size 2253504 bytes Variable Size 318770496 bytes … Read more..
Posted in ORA-Error | Comments Off on ORA-16072: a minimum of one standby database destination is required
Posted by Mir Sayeed Hassan on 7th July 2018
ORA-01156: recovery or flashback in progress may need access to files [oracle@primdb onlinelog]$ !sq sqlplus / as sysdba SQL> alter database drop standby logfile group 1; alter database drop standby logfile group 1 * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files Solution: You… Read more..
Posted in ORA-Error | Comments Off on ORA-01156: recovery or flashback in progress may need access to files
Posted by Mir Sayeed Hassan on 16th May 2018
ORA-09925: Unable to create audit trail file, Linux-x86_64 Error: 30: Read-only file system I found this error in one of our production database SQL> startup startup ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 30: Read-only file system Additional information: 9925 Solution 1: –… Read more..
Posted in ORA-Error | Comments Off on ORA-09925: Unable to create audit trail file, Linux-x86_64 Error: 30: Read-only file system
Posted by Mir Sayeed Hassan on 14th May 2018
ORA-19504/ORA-17502/ORA-15005 – RMAN Backup Failed to create the file in +ORADATA The below scenario occur in one of my RAC Production database. We would like to take the backup of the full database/incremental database by using the user defined location in +ORADATA [oracle(af2db2)@afcdb2]$ . oraenv ORACLE_SID = [afcdb2] ?… Read more..
Posted in ORA-Error | Comments Off on ORA-19504/ORA-17502/ORA-15005 – RMAN Backup Failed to create the file in +ORADATA
Posted by Mir Sayeed Hassan on 26th February 2018
ORA-39213/ORA-39006: Metadata processing is not available, internal error [oracle@testdb ~]$ expdp system directory=db_dump dumpfile=full_db26feb18.dmp logfile= full_db26feb18.log full=yes Export: Release 11.2.0.4.0 – Production on Mon Feb 26 16:03:01 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates All rights reserved.
Posted in ORA-Error | Comments Off on ORA-39213/ORA-39006: Metadata processing is not available, internal error
Posted by Mir Sayeed Hassan on 14th February 2018
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance Find the below error while starting of the database SQL>; startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 4.8103E+10 bytes Fixed Size … Read more..
Posted in ORA-Error | Comments Off on ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
