在单机上创建物理的Oracle9istandby数据库_其他_学习笔记★闵涛★计算机学习电脑编程软硬件技巧


	转至繁体中文版	\| 网站首页 \| 图文教程 \| 资源下载 \| 站长博客 \| 图片素材 \| 武汉seo \| 武汉网站优化 \|

在单机上创建物理的Oracle9istandby数据库

作者：闵涛文章来源：闵涛的学习笔记点击数：1676 更新时间：2009/4/22 23:22:10

bsp; -02 23-7? -02
43 23-7? -02 23-7? -02

3.4 验证是否新的归档Redo日志已经被应用：

SQL> select sequence#,applied from v$archived_log
2 order by sequence#;

SEQUENCE# APP
---------- ---
        38 YES
        39 YES
        40 YES
        41 YES
        42 YES
        43 YES

OK.表明我们还是成功的。暂时告一段落。

参考文档

Oracle Data Guard Concepts and Administration
Release 2 (9.2)
Part Number A96653-02

附加内容：

primary数据库的Pfile内容：

*.aq_tm_processes=1
*.background_dump_dest='D:\oracle\admin\DEMO\bdump'
*.compatible='9.2.0.0.0'
*.control_files='D:\oracle\oradata\DEMO\CONTROL01.CTL',
　　　'D:\oracle\oradata\DEMO\CONTROL02.CTL','D:\oracle\oradata\DEMO\CONTROL03.CTL'
*.core_dump_dest='D:\oracle\admin\DEMO\cdump'
*.db_block_size=8192
*.db_cache_size=19922944
*.db_domain='
*.db_file_multiblock_read_count=32
*.db_name='DEMO'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DEMOXDB)'
*.fast_start_mttr_target=300
*.hash_area_size=1048576
*.hash_join_enabled=TRUE
*.instance_name='DEMO'
*.java_pool_size=20971520
*.job_queue_processes=10
*.large_pool_size=7340032
*.log_archive_dest_1='location=d:\oracle\oradata\demo\archive'
*.log_archive_dest_2='SERVICE=PSTANDBY'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_start=TRUE
*.open_cursors=300
*.optimizer_mode='FIRST_ROWS'
*.pga_aggregate_target=17825792
*.processes=150
*.query_rewrite_enabled='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=33554432
*.sort_area_size=1048576
*.star_transformation_enabled='TRUE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\admin\DEMO\udump'