数据库联盟工作室
===========================================================
Grid Control的安装
===========================================================

1、4种安装模式说明:新的数据库和实例emrep、repository、oms、agent;

2、采用已有数据库安装时需提供hostname、port、service/SID、sys的password、两个表空间MGMT_TABLESPACE和MGMT_ECM_DEPOT_TS,repository对应schema是sysman、安装前drop掉,dispatchers参数不能设置、session_cached_cursors》=200、aq_tm_process>=1、执行两个脚本dbmspool.sql和prvtpool.plb;

3、oms端的secure通过在安装时require secure communications选项来设置,agent端的secure可通过emctl secure agent命令来设置;

4、agent10g/sysman/admin/script/*.pl

agent10g/sysman/emd/targets.xml

agent10g/sysman/admin/upload/*

agent10g/sysman/config/emd.properties


shiyihai 发表于:2008.08.22 10:00 ::分类: ( oracle ) ::阅读:(21次) :: 评论 (0)
===========================================================
Replication/Stream的配置
===========================================================

1、Stream的源数据库需为archived模式;

2、参数修改:global_names置为true;compatible>=10.2;job_queue_processes=4;aq_tm_processes=4;open_links=4;

3、两边设置stream的管理员用户strmadm,角色有connect、resource、dba、create any job等;

4、两边的db_domain不需设置;

5、global_name的修改update global_name set global_name='dg1';commit;再重启实例即可;

6、配置tnsnames.ora使得两边可以互相访问;

7、创建dblink使得两边可以互相访问,db link的名称为global_name的值;

8、若创建schema需保证源库上schema对应的表空间在目标库上先存在;

9、日志保存在两边的pump_dir目录下,pump_dir为预先定义好的directory对象。


shiyihai 发表于:2008.08.22 09:38 ::分类: ( oracle ) ::阅读:(22次) :: 评论 (0)
===========================================================
Rman的维护
===========================================================

1、Report:分析repository并报告各种问题
a)目标数据库的物理结构:report schema
b)需要备份的数据文件:
report need backup incremental 3
report need backup days 3 tablespace ts_test
report need backup redundancy 2 database
report need backup recovery window of 6 days
c)陈旧备份:report obsolete redundancy 2
d)不可恢复数据文件(nologging时):report unrecoverable

 查看全文

shiyihai 发表于:2008.08.22 09:33 ::分类: ( oracle ) ::阅读:(16次) :: 评论 (0)
===========================================================
Flashback Database
===========================================================

1、 设置Flash recovery area:

两个动态参数(db_recovery_file_dest_size和db_recovery_file_dest)

2、 设置db_flashback_retention_target

3、 设置flashback database为on:

Shutdown immediate;

Startup mount exclusive;

Alter database flashback on;

Alter database open;

4、 闪回操作:

Shutdown immediate;

Startup mount;

flashback database to timestamp(to_date('2008-08-07 08:16:07','yyyy-mm-dd hh24:mi:ss'))

alter database open resetlogs;

5、 查询:

V$flashback_database_logfile

V$flashback_database_log

V$flashback_database_stat


shiyihai 发表于:2008.08.22 09:29 ::分类: ( oracle ) ::阅读:(19次) :: 评论 (0)
===========================================================
network tracing and listener password
===========================================================

首先是三个参数的引入
trc_level:跟踪的级别,可取值off,user,admin和support
trc_directory:跟踪产生的trace文件所在目录
trc_file:跟踪产生的trace文件
具体的命令使用格式如下:

 查看全文

shiyihai 发表于:2008.06.02 13:55 ::分类: ( oracle ) ::阅读:(47次) :: 评论 (0)
===========================================================
configure shared server
===========================================================

Required parameter:dispatchers
optional parameters:
shared_servers、max_shared_servers、circuits、shared_server_sessions
这5个参数均是动态参数,可以动态修改。

 查看全文

shiyihai 发表于:2008.06.02 13:52 ::分类: ( oracle ) ::阅读:(44次) :: 评论 (0)
===========================================================
database service registation
===========================================================

For a listener to forward client connections to an instance, the listener must know the name of the instance and where the instance’s ORACLE_HOME is located. The listener can find this information in two ways:

1、Dynamic service registration: Oracle8i, Oracle9i, and Oracle Database 10g instances automatically register with the default listener on database startup. No additional listener configuration is required for the default listener.


2、Static service registration: The earlier releases of the Oracle database do not automatically register with the listener and, therefore, require that the listener configuration file contain a list of all database services that the listener will serve. You may still choose to use static service registration with newer releases if:
- Your listener is not on the default port of 1521, and you do not want to configure your instance to register with a nondefault port.
- Your application requires static service registration.


shiyihai 发表于:2008.06.02 13:50 ::分类: ( oracle ) ::阅读:(37次) :: 评论 (0)
自我介绍
切换风格
新闻聚合
博客日历
文章归档...
最新发表...
最多阅读文章...
博客统计...
Blog信息
网站链接...