wisdomone1的个人空间

提供整合式数据库架构解决方案

  • 博客访问: 11418732
  • 博文数量: 2204
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-04 23:58
  • 认证徽章:
个人简介

提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb qq: 305076427 微博: wisdomone9

文章分类

全部博文(2204)

文章存档

2018年(8)

2017年(49)

2016年(7)

2015年(205)

2014年(27)

2013年(507)

2012年(373)

2011年(255)

2010年(535)

2009年(206)

2008年(30)

2007年(2)

发布时间:2010-02-28 22:08:02

RHEL5.3上安装oracle 9i@L.........【阅读全文】

阅读(2403) | 评论(0) | 转发(0)

发布时间:2010-02-28 21:34:12

To identify the logs in the archive gapQuery the V$ARCHIVED_LOG and V$LOG views on the standby database. For example, the following query shows that there is a difference in the RECD and SENT sequence.........【阅读全文】

阅读(2503) | 评论(0) | 转发(0)

发布时间:2010-02-28 20:57:09

To place the standby database in manual recovery modeUse SQL*Plus to connect to the standby instance and then start the Oracle instance at the standby database. For example, enter: STARTUP NOMOUNT.........【阅读全文】

阅读(2488) | 评论(0) | 转发(0)

发布时间:2010-02-28 19:18:04

Take the following actions to increase system performance:On the primary database, if a table does not have a primary key or a unique index, then create a primary key RELYconstraint. On the logical.........【阅读全文】

阅读(2565) | 评论(0) | 转发(0)

发布时间:2010-02-28 17:38:12

Adding or Re-Creating Tables on a Logical Standby Database Typically, you use table instantiation to re-create atable after an unrecoverable operation. You can also use the procedureto enable S.........【阅读全文】

阅读(2468) | 评论(0) | 转发(0)

发布时间:2010-02-28 16:46:19

Performing DDL on a Logical Standby Database This section describes how to add an index to a table maintained through SQL apply operations. By default, only accounts with SYS privileges can .........【阅读全文】

阅读(2358) | 评论(0) | 转发(0)

发布时间:2010-02-28 14:21:14

Changing the size and number of the online redo logs issometimes done to tune the database. You can add redo log file groupsor members to the primary database without affecting the standbydatabase..........【阅读全文】

阅读(2351) | 评论(0) | 转发(0)

发布时间:2010-02-28 14:19:20

[oracle@localhost oracle]$ sqlplus '/as sysdba'SQL*Plus: Release 9.2.0.4.0 - Production on Sun Feb 28 13:59:25 2010Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.Connect.........【阅读全文】

阅读(2504) | 评论(0) | 转发(0)

发布时间:2010-02-28 13:27:24

When you rename one or more datafiles in the primarydatabase, the change is not propagated to the standby database.Therefore, if you want to rename the same datafiles on the standbydatabase, you mu.........【阅读全文】

阅读(2604) | 评论(0) | 转发(0)

发布时间:2010-02-27 17:34:18

1,拷贝,注册任何missing的归档日志(对于于主库)在将要用于转化为(failover为新主库的逻辑备库上),为简略以下皆称为column file_name format a55SQL> SELECT THREAD#, SEQUENCE#, FILE_NAME FROM DBA_LOGSTDBY_L.........【阅读全文】

阅读(2629) | 评论(0) | 转发(0)
给主人留下些什么吧!~~

dbSeeSee2016-06-13 17:39

踩踩 像博主学习

回复  |  举报

5319689122016-01-25 16:17

回复  |  举报

jeanron1002015-12-23 22:29

回复  |  举报
留言热议
请登录后留言。

登录 注册