ITeye博客

dbua

libin123 · 共 529 篇文章

Steps To Migrate/Move a Database From Non-ASM to ASM And Vice-Versa [ID 252219.1

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 Information in this document applies to any platform. Purpose This article describes the steps to migrate a database from Non-ASM to ASM and vice-versa. To setup ASM, please follow Note 452924.1 - How to Prepare Storage …

2010-05-14 15:08 · oracle 学习 · 评论(0)

How to duplicate a controlfile when ASM is involved [ID 345180.1]

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 Information in this document applies to any platform. Checked for relevance on 04-May-2009 Goal This document presents different options to duplicate a controlfile in environments using ASM. The procedure applies either …

2010-05-14 14:46 · oracle 学习 · 评论(0)

How to Copy Archivelog Files From ASM to Filesystem and vice versa [ID 944831.1]

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.3 to 11.1.0.7 Information in this document applies to any platform. Goal This note will guide a DBA in copying archivelog files currently located in a ASM diskgroup to a file system. This is commonly useful when a DBA needs to copy ar…

2010-05-14 14:39 · oracle 学习 · 评论(0)

How to move a datafile from ASM to the file system [ID 390416.1]

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3 Information in this document applies to any platform. Goal This note will guide a DBA in moving a datafile currently located in a ASM diskgroup to a file system. Solution How to move a datafile from ASM to a file system.…

2010-05-14 14:31 · oracle 学习 · 评论(0)

How to move a datafile from a file system to ASM [ID 390274.1]

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5 to 10.2.0.3 Information in this document applies to any platform. Goal This note will guide a DBA in moving a datafile currently located on file system to an ASM diskgroup. Solution How to move a datafile from a file system to ASM M…

2010-05-14 14:27 · oracle 学习 · 评论(0)

How To Move Controlfile To ASM [ID 468458.1]

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6 Information in this document applies to any platform. Goal This document provides information on how to move a controlfile from filesystem to ASM and Vise Versa Solution 1. Identify the location of the current controlfil…

2010-05-14 13:57 · oracle 学习 · 评论(0)

Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node [ID 27

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.8 Information in this document applies to any platform. Purpose The purpose of this note is to illustrate the changing of a Virtual IP Address (VIP) or VIP hostname or other VIP parameters in an Oracle10g RAC/Oracle Cluste…

2010-05-14 11:28 · Oracle RAC · 评论(0)

How to Recreate the Controlfile [ID 1012929.6]

Checked for relevance on 06-DEC-2007 PURPOSE This article describes how you can recreate your controlfile. SCOPE & APPLICATION For DBAs who need to recreate the controlfile. WARNING: -------- You should only need to recreate your control file under very special circumstances: - All current copies o…

2010-05-13 14:09 · oracle 学习 · 评论(0)

ORA-19599 When backing up an archivelog that is corrupt [ID 461239.1]

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1.0 This problem can occur on any platform. Symptoms Getting error when backing up archivelogs: RMAN-03015: error occurred in stored script backup_al_all_tape_dwdb2 RMAN-03009: failure of backup command on t1 channel at 10/03/2007 12:…

2010-05-13 13:56 · oracle 案例 · 评论(0)

RAC或OPS环境下重新创建控制文件 引自Metalink

PURPOSE ------- This article describes how you can recreate your controlfile in RAC. SCOPE & APPLICATION ------------------- For DBA's requiring to recreate the controlfile. WARNING: -------- You should only need to recreate your control file under very special circumstances: - All current copies o…

2010-05-13 13:33 · Oracle RAC · 评论(0)

ASMCMD fails to start on module libnnz10.so, permission denied

ASMCMD fails to start on module libnnz10.so, permission denied [ID 790470.1] 修改时间 17-MAR-2009 类型 PROBLEM 状态 PUBLISHED Applies to: Oracle Server Enterprise Edition - Version: 11.1.0.6 to 11.1.0.7 This problem can occur on any platform. ASM - Version: 11.1.0.6 to 11.1.0.7 Red Hat Advanced Server Linu…

2010-05-13 01:14 · oracle 案例 · 评论(0)

Errors ORA-00600 [kclchkblk_4] and ORA-00600 [2662] After Recovery of Datab

Applies to: Oracle Server - Enterprise Edition - Version: 9.0.1.0.0 to 10.1.0.2 This problem can occur on any platform. Symptoms 1) You restored the database from backup and did an incomplete recovery. 2) Opened the database with resetlogs. 3) After opening the database, you start getting following…

2010-05-12 15:45 · oracle 案例 · 评论(0)

How to Change Interconnect/Public Interface IP or Subnet in Oracle Clusterware [

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.8 Information in this document applies to any platform. Goal Purpose: The purpose of this note is to describe how to change or update the cluster_interconnect and/or public interface IP information that is stored in the OC…

2010-04-30 12:06 · Oracle RAC · 评论(0)

10gR2 RAC Install issues on Oracle EL5 or RHEL5 or SLES10 (VIPCA / SRVCTL / OUI

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3 Linux x86-64 Generic Linux Intel Based Server LINUX Symptoms When installing 10gR2 RAC on Oracle Enterprise Linux 5 or RHEL5 or SLES10 there are three issues that users must be aware of. Issue#1 : To install 10gR2, you m…

2010-04-30 12:04 · Oracle RAC · 评论(0)

RAC环境下listener无法启动案例分析

RAC系统重新配置listener后无法启动: [root@rac02 admin]# [root@rac01 bin]# ./crs_start ora.rac02.LISTENER1_RAC02.lsnr Attempting to start `ora.rac02.LISTENER1_RAC02.lsnr` on member `rac02` Start of `ora.rac02.LISTENER1_RAC02.lsnr` on member `rac02` failed. rac01 : CRS-1018: Resource ora.rac02.vip (application) …

2010-04-26 21:24 · Oracle RAC · 评论(0)