ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
来源:互联网 发布:中建一局知乎 编辑:程序博客网 时间:2024/04/29 17:05
ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
Example:
In the example below the error Occurred while performing an open resetlogs on a 10.2.0.3 Oracle Single Instance Database
Server prior to restoring an RMAN backup of and Oracle Database. The RMAN backup was taken from a RAC Database Server
and restored to a Single Instance Box.
Details:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled.
Oracle bug, 4355382 ORA-38856: FAILED TO OPEN DATABASE WITH RESETLOGS WHEN USING RAC BACKUP, exists in the
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.
Solution:
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.
Example:
In the example below the error Occurred while performing an open resetlogs on a 10.2.0.3 Oracle Single Instance Database
Server prior to restoring an RMAN backup of and Oracle Database. The RMAN backup was taken from a RAC Database Server
and restored to a Single Instance Box.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
Details:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled.
Oracle bug, 4355382 ORA-38856: FAILED TO OPEN DATABASE WITH RESETLOGS WHEN USING RAC BACKUP, exists in the
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.
Solution:
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.
- ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
- ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
- ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
- ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
- ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
- ORA-01618: redo thread 2 is not enabled - cannot mount
- ORA-01618: redo thread 2 is not enabled - cannot mount
- ORA-01618: redo thread 2 is not enabled - cannot mount 错误
- ORA-01618: redo thread 2 is not enabled - cannot mount 错误
- ORA-01618: redo thread 2 is not enabled - cannot mount 错误
- ORA-01618: redo thread 2 is not enabled - cannot mount RAC
- ORA-10485: Real-Time Query cannot be enabled while applying migration redo
- ORA-01123: cannot start online backup; media recovery not enabled
- ORA-01123: cannot start online backup; media recovery not enabled
- ORA-00600 Recovery of Online Redo Log: Thread 1 Group 2 Seq 128 Reading mem 0 错误特殊恢复
- ORA-00265:instance recovery required, cannot set ARCHIVELOG mode
- ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
- ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
- MOSS AJAX WebParts开发环境设置
- 无法连接到WMI提供程序。您没有权限或者该服务器无法访问
- 显示excel在datagridview以及在spreedsheet显示excel(office2010)
- 强制删除页面上出错的WebParts
- Attribute在.net编程中的应用(一)
- ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
- 代码创建自定义权限级别
- difference between --enable-mbstring and --enable-mbstring=shared
- Nutch的URL选择策略 OPIC IN NUTCH
- 增加了WPF的一些feature给自己的sample
- 软件维护人员及运维人员岗位职责
- 使用Nginx的proxy_cache缓存功能取代Squid
- Pthread学习完毕
- ARM指令集