Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Tag Archives: standby
Optimal Redo Log Size
Posted in Tuning in General
Tagged LOG FILES, PHYSICAL, RECOVER, Recovery, REDO, standby, V$INSTANCE_RECOVERY
Comments Off
archive_lag_target
Posted in Configuration., Oracle, Parameters
Tagged Archive, ARCHIVE_LAG_TARGET, Log, parameter, parameters, REDO, standby
Comments Off
Error 16047 creating remote archivelog file
Posted in Configuration., Oracle, Parameters, Physical Standby, Standby
Tagged 16047, db_unique_name, DGID, FAL, LOG_ARCHIVE_DEST, mismatch, ORA-16047, ORA-16055:, physical standby, request~rejected, standby
Comments Off
Recovery failure due to archive corruption.
Physical standby performing recovery had a problem with the redo stream, throwing a lot of information out.
Posted in Oracle
Tagged ALTER~DATABASE, BLOCK_CORRUPTION, MANAGED~STANDBY, PHYSICAL, Physical Standby, RECOVER, REDO_STREAM, standby
Comments Off
FAL[client]: Failed to request gap sequence
FAL[client]: Failed to request gap sequence on a standby database indicates that the sequence being requested from all servers is not available. This I find commonly occurs where the backup on the production system clear’s out the archives on the … Continue reading
Posted in Oracle, Physical Standby
Tagged archives, CLIENT, FAILED~TO~REQUEST~GAP~SEQUENCE, FAL_CLIENT, FAL_SERVER, GAP, physical standby, RECOVER, Rman, SERVER, standby
Comments Off
Misleading ORA-01009
Client’s RAC to single instance standby database was having problems, throwing error ORA-01009. This was not helpful. $ oerr ora 100901009, 00000, “missing mandatory parameter”// *Cause:// *Action: So, How to resolve this ……..
Checking Standby Databases.
A client required to be sent a mail to update them on the status of two standby database’s. We could write something which logs onto each machine, checks the information and mails them out, or we can check just the … Continue reading
Recover standby with missing archived logs.
Recovering a database with missing archives. We face a situation sometimes where a standby database is missing redo logs, and the primary no longer has them available. Here’s a means to get past that problem using rman.
