设为首页收藏本站

Botang唐波's Oracle Station

查看: 73|回复: 0

课程第53/54次(2018-11-05星期一和2018-11-09星期五)

[复制链接]

744

主题

1117

帖子

8077

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8077
发表于 2018-11-5 21:14:37 | 显示全部楼层 |阅读模式
station23:
  1. Last login: Mon Nov  5 16:13:51 2018 from station90.example.com
  2. [root@station23 ~]# su - oracle
  3. [oracle@station23 ~]$ srvctl config database -d c01orcl
  4. Database unique name: c01orcl
  5. Database name: c01orcl
  6. Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
  7. Oracle user: oracle
  8. Spfile: +DATA/c01orcl/spfilec01orcl.ora
  9. Domain: example.com
  10. Start options: open
  11. Stop options: immediate
  12. Database role: PRIMARY
  13. Management policy: AUTOMATIC
  14. Server pools: c01orcl
  15. Database instances: c01orcl1,c01orcl2
  16. Disk Groups: DATA,FRA
  17. Mount point paths:
  18. Services:
  19. Type: RAC
  20. Database is administrator managed
  21. [oracle@station23 ~]$
复制代码
1. 要改/etc/oratab:
c01orcl1:/u01/app/oracle/product/11.2.0/dbhome_1:N
2. 转成pfile改init.ora:
*.audit_file_dest='/u01/app/oracle/admin/c01orcl/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.4.0'
*.control_files='+DATA/c01orcl/controlfile/current.260.991429095','+FRA/c01orcl/controlfile/current.256.991429095'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain='example.com'
*.db_name='c01orcl'
*.db_unique_name='c01orcl'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=15366881280
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=c01orclXDB)'
c01orcl1.instance_number=1
c01orcl2.instance_number=2
*.memory_target=6481248256
*.open_cursors=300
*.processes=650
*.remote_listener='scan23.example.com:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=720
c01orcl2.thread=2
c01orcl1.thread=1
c01orcl1.undo_tablespace='UNDOTBS1'
c01orcl2.undo_tablespace='UNDOTBS2'
*.log_archive_config='dg_config=(c01orcl,c02orcl)'
*.log_archive_dest_1='location=use_db_recovery_file_dest'
*.log_archive_dest_2='service=c02orcl valid_for=(online_logfiles,primary_role) db_unique_name=c02orcl'
*.standby_file_management=auto
*.fal_server=c02orcl
*.fal_client=c01orcl

station25:
1. mkdir /u01/app/oracle/admin/c02orcl/adump

station26:
1. mkdir /u01/app/oracle/admin/c02orcl/adump

station23.zip (8.24 KB, 下载次数: 15)
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-11-18 02:05 , Processed in 0.170648 second(s), 27 queries .

快速回复 返回顶部 返回列表