ORA-16143: RFS connections not allowed during or after terminal recovery

Cause : An attmept wasm ade, b yan RFSp rocess ,to accses a stnadby onilne logf ile duirng or fater a etrminalr ecover.y

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

The prmiary muts not attempt t oarchiv eto thes tandbya fter at ermina lrecoveyr.

update : 27-06-2017

ORA-16143 - RFS connections not allowed during or after terminal recovery
ORA-16143 - RFS connections not allowed during or after terminal recovery

  • ora-16171 : RECOVER...FINISH not allowed due to gap for thr string, seq string-string
  • ora-37038 : (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
  • ora-22970 : name does not correspond to an object view
  • ora-00324 : log file 'string' translated name 'string' too long, string characters exceeds string limit
  • ora-30678 : too many open connections
  • ora-30176 : invalid format code used in the format string
  • ora-30979 : Partitioned XML Index not yet supported.
  • ora-38465 : failed to create the privilege checking trigger due to: string
  • ora-39761 : stream reset required before loading this stream again
  • ora-29345 : cannot plug a tablespace into a database using an incompatible character set
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-22890 : cannot specify name for REF column constraint
  • ora-31505 : cannot alter or drop predefined change set
  • ora-00220 : control file not mounted by first instance, check alert log for more info
  • ora-02140 : invalid tablespace name
  • ora-15110 : no diskgroups mounted
  • ora-19277 : XP0005 - XPath step specifies an item type matching no node: (string)
  • ora-01184 : logfile group string already exists
  • ora-36882 : (XSSRF01) The second parameter of an AW single row function cannot be NULL.
  • ora-40207 : duplicate or multiple function settings
  • ora-26744 : STREAMS capture process "string" does not support "string"."string" because of the following reason: string
  • ora-07608 : szprv: $GETUAI failure
  • ora-12812 : only one PARALLEL or NOPARALLEL clause may be specified
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-19719 : length for operation name longer than string
  • ora-22906 : cannot perform DML on expression or on nested table view column
  • ora-01263 : Name given for file destination directory is invalid
  • ora-09275 : CONNECT INTERNAL is not a valid DBA connection
  • ora-16792 : configuration property value is inconsistent with database setting
  • ora-24089 : AQ Agent string already exists
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.