Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ ORA-38856: Unable instance UNNAMED_INSTANCE_2 (redo thread 2) marked enabled     - Linux network security probing tools Hping2 (Linux)

- Win7 + Ubuntu Kylin + CentOS 6.5 installed three systems (Linux)

- Linux ldconfig command (Linux)

- Java polymorphic methods inside constructors complete analysis (Programming)

- Father of Python: Why Python zero-based index (Programming)

- Android Activity launchMode (Programming)

- sed command (Linux)

- Examples of testing and installation Mesos on CentOS (Linux)

- Caffe + Ubuntu 14.04 64bit + CUDA 6.5 configuration instructions (Linux)

- systemd Power Management (Linux)

- High-performance JavaScript DOM programming (Programming)

- Linux Basic Course: tar command description (Linux)

- Oracle database online redo logs are several methods of recovery of deleted (Database)

- Linux GCC 5.1.0 compiler installation (Linux)

- Source code to compile and install MySQL 5.7.9 (Database)

- Linux iptables firewall settings whitelist (RHEL 6 and CentOS 7) (Linux)

- Linux installation beautify early experience (Linux)

- How to achieve the MySQL Oracle table associated with the two operations update (Database)

- RedHat Performance Tuning (Server)

- Linux virtual machines to solve end MySQL database can not remote access (Database)

  ORA-38856: Unable instance UNNAMED_INSTANCE_2 (redo thread 2) marked enabled
  Add Date : 2016-09-26      
  In doing remote database recovery time trial, error ORA-38856, details are as follows:

Source Library for Oracle RAC, 2 node database version

Target library is a single instance of ORACLE, version

Source Library Rman backup of all equipment 0

After a successful restore, recover unsuccessful, need to use the original online log, rebuilding the control file,

Then alter database open resetlogs, given

SQL> alter database open resetlogs;
alter database open resetlogs
Line 1 Error:
ORA-38856: Unable instance UNNAMED_INSTANCE_2 (redo thread 2) marked enabled

It is a Bug:


Oracle 10g release 2.0 that affects backups taken from a RAC database. The problem is related to the number of threads

used by the source database and an expectation that the cloned database must have an identical number of threads.


1. Set the following parameter in the auxiliary init.ora file: _ no_recovery_through_resetlogs = TRUE.
2. Open the database in resetlogs mode.
3. Remove _no_recovery_through_resetlogs = TRUE from init.ora.
4. Restart database.
- Ubuntu 15.10 installation and deployment Swift development environment (Linux)
- Commentary Apache + Tomcat + JK implement Tomcat clustering and load (Server)
- To use slay kill user processes (Linux)
- HAProxy Windows version of the compiler and its application in the CORS (Server)
- Hadoop new and old version of the difference in the size of the InputSplit (Server)
- Oracle10g 64-bit installation solution in Windows 2008 Server R2 (Database)
- RAID configuration and management under linux (Server)
- Examples of safety testing system notes for RedHat Linux (Linux)
- Mongo-connector integrated MongoD to achieve incremental Solr index (Server)
- Plasma 5.4 How to install on Kubuntu 15.04 (Linux)
- Linux filtration empty file command summary (Linux)
- Linux SSH login without a password (Linux)
- Linux System Getting Started Tutorial: Five image processing software (Linux)
- Installation of Ubuntu Make under Ubuntu 15.10 (Linux)
- Linux itself disguised illusion strengthen security (Linux)
- ORA-30926 and MERGE tables empty the temporary occupation problem (Database)
- Git you do not know about some of the things (Linux)
- Oracle in the add & split partition on the impact of global & local index (Database)
- Kafka + Log4j log implement centralized management (Server)
- Java uses JDBC connect database (Programming)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.