-
编辑 删除
oracle10g data guard role transition_physical_logical_switchover_failover
1,--rac备库，转换时，只有一个实例打开，其它实例关闭，转变角色后吗，呵呵，其它实例会自动进行角色转换哟，oracle我爱你For a Real Application Clusters database, only one RAC instance on the standby databa...
-
编辑 删除
oracle 10g data guard log apply services
1Footnote 1: The managed recovery process (MRP) applies archived redo log files to the physical standby database, and automatically determines the optimal number of parallel recovery processes at the ...
-
编辑 删除
oracle10g data guard redo transport service
1,Table 5-1 LOG_ARCHIVE_DEST_STATE_n Initialization Parameter AttributesAttribute DescriptionENABLE Redo transport services can transmit redo data to this destination. This is the default...
-
编辑 删除
oracle 10g logical standby db creation
1,构建一个物理备库，我们已经有了，哈哈，对吧2,停止物理备库日志应用ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;3,调整主库用于支持逻辑备库 如主库切换为逻辑备库 配置如下参数LOG_ARCH...
-
编辑 删除
oracle 10g physical standby database creation
前言： 主库os version:centos 3.9 备库os version:rhel5 oracle version:oracle10.2.0.1构建物理备库步骤如下:1.在主库，开启强制日志功能 alter dat...
-
编辑 删除
为物理备库添加standby logfile group相关事则
1,为了理解physical standby db,在其上添加standby logfile group, SQL> alter database add standby logfile group 4 ('/oracle/oradata/centos/redo04') size 50m;alter database add standby logfile group...
-
编辑 删除
测试oracle10g dg备库ORA-12162处理一则
前言：在测试oracle10g dg时，备库用sqlplus连接出现如题错误。查阅相关文档,解决如下1,-bash-3.1$ sqlplus sys/system as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 19 04:48:02 2010Copyright ...
-
编辑 删除
manual database deletion for oracle10g on solaris10
-bash-3.00$ export ORACLE_SID=manualdb-bash-3.00$ sqlplus '/as sysdba'SQL*Plus: Release 10.2.0.2.0 - Production on Tue Dec 15 10:09:56 2009Copyright (c) 1982, 2005, Oracle. All Rights Reserved.C...
-
编辑 删除
manual database creation for oracle10g on solaris10
1,配置ORACLE_SIDbash-3.00$ export ORACLE_SID=mynewdb2,切到dbs目录bash-3.00$ cd $ORACLE_HOME/dbsbash-3.00$ lsinit.ora initdw.orabash-3.00$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0...
-
编辑 删除
补接_oracle rac_node addition and deletion for clusterware or software
Adding an Oracle Clusterware Home to a New Node Using OUI in Interactive Mode 1. Ensure that you have successfully installed Oracle Clusterware on at least on...
-
编辑 删除
近期oracle upgrade book and rac manual 手记
1,whenever sqlerror exit --表示当在sqlplus中执行命令不正确时，马上退出sqlplus whenever oserror exit --同上2,set numwidth 30 --配置number类型的列显示宽度3,rem(remark) --注解sql ...
-
编辑 删除
Downgrade the Database
Complete the following steps to downgrade your release 10.2 database to the Oracle Database release from which you originally upgraded:Log in to the system as the owner of the release 10.2 Ora...
-
编辑 删除
转载__sqlplus相关tip
小窍门–sqlplus中使用backspace键Thursday, October 11th, 2007在unix下使用sqlplus，backspace默认是不支持删除的而是出现“^H，有时候感觉特别不方便。出现这个问题原因我猜测是因为sqlplus不...
-
编辑 删除
从oracle817升到1201（或之后）必须作的工作
Tasks to Complete Only After Upgrading a Release 8.1.7 DatabaseUpgrade User NCHAR ColumnsTo upgrade user tables with NCHAR columns, perform. the following steps:Log in to the system as the owner of ...
-
编辑 删除
手工升级_manual upgrade_后升级ocr
Upgrade the Oracle Cluster Registry (OCR) ConfigurationIf you are using Oracle Cluster Services, then you must upgrade the Oracle Cluster Registry (OCR) keys for the database.Use one of the followin...
-
编辑 删除
upgrade oracle rman catalog
Upgrading the Recovery CatalogIfyou use a version of the recovery catalog that is older than thatrequired by the RMAN client, then you must upgrade it. For example, youmust upgrade the catalog if ...
-
编辑 删除
oracle_1201_upgrade_第二部
Using the Pre-Upgrade Information ToolThe Pre-Upgrade Information Tool is a SQL script. that ships with the new Oracle Database 10grelease, and must be copied to and run from the environment of ...
-
编辑 删除
测试学习oracle10g_dbca各种数据库类型（普通，事务处理，定制，数据仓库）
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...
-
编辑 删除
oracle1201_upgrade manual_第一部
1,先引录如下升级流程图片2,上述各步骤细述Step 1: Prepare to UpgradeBecome familiar with the features of the new Oracle Database 10g release.Determine the upgrade path to the new Oracle Datab...
-
编辑 删除
oracle10g_client_installation_note
1，安装和install server同理2,三大安装类型：administator (可以管理db),  ...
