物理Standby创建过程.docx
- 文档编号:8957264
- 上传时间:2023-02-02
- 格式:DOCX
- 页数:22
- 大小:53.36KB
物理Standby创建过程.docx
《物理Standby创建过程.docx》由会员分享,可在线阅读,更多相关《物理Standby创建过程.docx(22页珍藏版)》请在冰豆网上搜索。
物理Standby创建过程
物理Standby创建过程
1:
确认主库为归档模式
SQL>archiveloglist;
DatabaselogmodeArchiveMode
AutomaticarchivalEnabled
Archivedestination/oracle/app/oracle/archivelog
Oldestonlinelogsequence1
Nextlogsequencetoarchive2
Currentlogsequence2
2:
将主库设置为ForceLogging模式
SQL>selectforce_loggingfromv$database;
FORCE_
------
YES
如果不是YES,执行如下语句
SQL>alterdatabaseforcelogging;
3:
配置Primary主库的初始化参数
(1)通过spfile创建pfile
SQL>createpfile='/oracle/backup/pfile_bocnet.ora'fromspfile;
createpfile='/oracle/backup/pfile_bocnet.ora'fromspfile
*
ERRORatline1:
ORA-27037:
unabletoobtainfilestatus
Linux-x86_64Error:
2:
Nosuchfileordirectory
Additionalinformation:
3
创建失败,查询$ORACLE_HOME/dbs目录后发现该数据库用的就是pfile,没有用spfile,所以得首先创建spfile
在数据库open状态下创建pfile
SQL>createspfilefrompfile;
Filecreated.
再次创建pfile
SQL>createpfile='/oracle/backup/pfile_bocnet.ora'fromspfile;
Filecreated.
(2)修改主库端初始化参数文件
[oracle@BOCNETbackup]$vipfile_bocnet.ora
BOCNET.__db_cache_size=150994944
aux.__db_cache_size=100004944
BOCNET.__java_pool_size=4194304
aux.__java_pool_size=414304
BOCNET.__large_pool_size=4194304
aux.__large_pool_size=414304
BOCNET.__shared_pool_size=100663296
aux.__shared_pool_size=56063296
BOCNET.__streams_pool_size=4194304
*.audit_file_dest='/oracle/app/oracle/admin/BOCNET/adump'
*.background_dump_dest='/oracle/app/oracle/admin/BOCNET/bdump'
*.log_archive_dest_state_2=defer
*.compatible='10.2.0.1.0'
*.control_files='/oracle/app/oracle/oradata/BOCNET/control01.ctl','/oracle/app/oracle/oradata/BOCNET/control02.ctl','/oracle/app/oracle/oradata/BOCNET/control03.ctl'
*.core_dump_dest='/oracle/app/oracle/admin/BOCNET/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='BOCNET'
*.db_recovery_file_dest='/oracle/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.job_queue_processes=10
*.log_archive_dest_1='location=/oracle/app/oracle/archivelog'
*.nls_language='SIMPLIFIEDCHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=88080384
*.processes=150
*.recyclebin='OFF'
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=266338304
*.sql_trace=FALSE
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/app/oracle/admin/BOCNET/udump'
#dataguard
*.db_unique_name=bocnet
*.log_archive_config='dg_config=(bocnet,gyx)'
*.log_archive_dest_2='service=gyx_192.168.56.9archvalid_for=(online_logfiles,primary_role)db_unique_name=gyx'
*.log_archive_dest_state_2=defer
*.fal_server=gyx_192.168.56.9
*.fal_client=bocnet_192.168.56.8
*.db_file_name_convert='/oracle/app/oracle/oradata/BOCNET','/oracle/app/oracle/oradata/GYX',’/oracle/app/’,’/oracle/app/oracle/oradata/GYX’,’/oracle/sdfdsfsd/’,’/oracle/………..’
*.log_file_name_convert='/oracle/app/oracle/oradata/BOCNET','/oracle/app/oracle/oradata/GYX'
*.standby_file_management=auto
(3)根据pfile文件创建spfile
SQL>shutdownimmediate
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.
SQL>createspfilefrompfile='/oracle/backup/pfile_bocnet.ora';
\
Filecreated.
查询新生成的spfile文件,根据文件生成时间可以判断(红色标注)
[oracle@BOCNETbackup]$cd$ORACLE_HOME/dbs
[oracle@BOCNETdbs]$ll
-rw-r-----1oracledba1536May521:
22orapwBOCNET
-rw-r-----1oracledba7061504May713:
44snapcf_BOCNET.f
-rw-r-----1oracledba4608May1020:
02spfileBOCNET.ora
-rw-r-----1oracledba3584Mar2520:
57spfilePROD.ora
4:
创建Standby数据库的控制文件
SQL>startup;
ORA-32004:
obsoleteand/ordeprecatedparameter(s)specified
ORACLEinstancestarted.
TotalSystemGlobalArea268435456bytes
FixedSize2020088bytes
VariableSize113249544bytes
DatabaseBuffers150994944bytes
RedoBuffers2170880bytes
Databasemounted.
Databaseopened.
SQL>alterdatabasecreatestandbycontrolfileas'/oracle/backup/gyx.ctl';
Databasealtered.
[oracle@BOCNETbackup]$ll
total6928
drwxr-xr-x4oracledba4096Apr2715:
08ad
-rw-r-----1oracledba7061504May1020:
16bocnetgyx.ctl
drwxr-xr-x2oracledba4096May1020:
21cold
-rw-r--r--1oracledba1821May1019:
56pfile_bocnet.ora
drwxr-xr-x2oracledba4096May622:
40rman
drwxr-xr-x2oracledba4096Apr2715:
08td
5:
对Primary库BOCNET的数据文件进行冷备份
(1)查询Primary库BOCNET的数据文件的路径
SQL>selectnamefromv$datafile;
NAME
--------------------------------------------------------------------------------
/oracle/app/oracle/oradata/BOCNET/system01.dbf
/oracle/app/oracle/oradata/BOCNET/undotbs01.dbf
/oracle/app/oracle/oradata/BOCNET/sysaux01.dbf
/oracle/app/oracle/oradata/BOCNET/users01.dbf
/oracle/app/oracle/oradata/BOCNET/gyx_data02.dbf
/oracle/app/oracle/oradata/BOCNET/tang01.dbf
/oracle/app/oracle/oradata/BOCNET/jiang01.dbf
/oracle/app/oracle/oradata/BOCNET/data00001.dbf
/oracle/app/oracle/oradata/BOCNET/perfstat.dbf
9rowsselected.
(2)关闭Primary数据库BOCNET
SQL>shutdownimmediate
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.
(3)copy数据文件到相应目录
[oracle@BOCNETBOCNET]$cpsystem01.dbf/oracle/backup/cold
[oracle@BOCNETBOCNET]$cpundotbs01.dbf/oracle/backup/cold
[oracle@BOCNETBOCNET]$cpsysaux01.dbf/oracle/backup/cold
[oracle@BOCNETBOCNET]$cpusers01.dbf/oracle/backup/cold
[oracle@BOCNETBOCNET]$cpgyx_data02.dbf/oracle/backup/cold
[oracle@BOCNETBOCNET]$cptang01.dbf/oracle/backup/cold
[oracle@BOCNETBOCNET]$cpjiang01.dbf/oracle/backup/cold
[oracle@BOCNETBOCNET]$cpdata00001.dbf/oracle/backup/cold
[oracle@BOCNETBOCNET]$cpperfstat.dbf/oracle/backup/cold
(4)相关目录查询这些数据文件
[oracle@BOCNETcold]$ll
total1382584
-rw-r-----1oracledba20979712May1020:
48data00001.dbf
-rw-r-----1oracledba104865792May1020:
47gyx_data02.dbf
-rw-r-----1oracledba104865792May1020:
47jiang01.dbf
-rw-r-----1oracledba262152192May1020:
49perfstat.dbf
-rw-r-----1oracledba283123712May1020:
45sysaux01.dbf
-rw-r-----1oracledba314580992May1020:
40system01.dbf
-rw-r-----1oracledba104865792May1020:
47tang01.dbf
-rw-r-----1oracledba209723392May1020:
41undotbs01.dbf
-rw-r-----1oracledba9183232May1020:
46users01.dbf
6:
在standby端创建文件夹GYX
[oracle@PROD~]$cd$ORACLE_BASE
[oracle@PRODoracle]$cdoradata
[oracle@PRODoradata]$ll
total16
drwxr-xr-x2oracledba4096May416:
19BOCNET
drwxr-xr-x2oracledba4096May1021:
06GYX
drwxr-xr-x2oracledba4096Mar2809:
24ITM
drwxr-x---2oracledba4096May416:
45PROD
7:
将初始化参数文件、控制文件、数据文件拷贝至文件夹GYX
[oracle@BOCNETbackup]$scppfile_bocnet.oraoracle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
root3306
pfile_bocnet.ora100%18211.8KB/s00:
00
[oracle@BOCNETbackup]$scpbocnetgyx.ctloracle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
root3306
bocnetgyx.ctl100%6896KB6.7MB/s00:
01
[oracle@BOCNETcold]$scpdata00001.dbforacle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
data00001.dbf100%20MB6.7MB/s00:
03
[oracle@BOCNETcold]$scpgyx_data02.dbforacle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
gyx_data02.dbf100%100MB5.9MB/s00:
17
[oracle@BOCNETcold]$scpjiang01.dbforacle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
Permissiondenied,pleasetryagain.
oracle@192.168.56.9'spassword:
jiang01.dbf100%100MB6.7MB/s00:
15
[oracle@BOCNETcold]$scpperfstat.dbforacle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
perfstat.dbf100%250MB7.6MB/s00:
33
[oracle@BOCNETcold]$scpsysaux01.dbforacle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
sysaux01.dbf100%270MB6.3MB/s00:
43
[oracle@BOCNETcold]$scpsystem01.dbforacle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
system01.dbf100%300MB5.8MB/s00:
52
[oracle@BOCNETcold]$scptang01.dbforacle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
tang01.dbf100%100MB6.3MB/s00:
16
[oracle@BOCNETcold]$scpundotbs01.dbforacle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
undotbs01.dbf100%200MB6.3MB/s00:
32
[oracle@BOCNETcold]$scpusers01.dbforacle@192.168.56.9:
/oracle/app/oracle/oradata/GYX/
oracle@192.168.56.9'spassword:
users01.dbf100%8968KB4.4MB/s00:
02
8:
将初始化文件更改名字,控制文件进行复制
[oracle@PRODBOCNETGYX]$mvpfile_bocnet.orapfile_gyx.ora
[oracle@PRODBOCNETGYX]$ll
total1389496
-rw-r-----1oracledba7061504May1021:
19bocnetgyx.ctl
-rw-r-----1oracledba20979712May1021:
21data00001.dbf
-rw-r-----1oracledba104865792May1021:
22gyx_data02.dbf
-rw-r-----1oracledba104865792May1021:
23jiang01.dbf
-rw-r-----1oracledba262152192May1021:
25perfstat.dbf
-rw-r--r--1oracledba1821May1021:
15pfile_gyx.ora
-rw-r-----1oracledba283123712May1021:
26sysaux01.dbf
-rw-r-----1oracledba314580992May1021:
28system01.dbf
-rw-r-----1oracledba104865792May1021:
29tang01.dbf
-rw-r-----1oracledba209723392May1021:
31undotbs01.dbf
-rw-r-----1oracledba9183232May1021:
32users01.dbf
[oracle@PRODBOCNETGYX]$cpbocnetgyx.ctlbocnetgyx02.ctl
[oracle@PRODBOCNETGYX]$cpbocnetgyx.ctlbocnetgyx03.ctl
[oracle@PRODBOCNETGYX]$ll
total1403312
-rw-r-----1oracledba7061504May1021:
37bocnetgyx02.ctl
-rw-r-----1oracledba7061504May1021:
37bocnetgyx03.ctl
-rw-r-----1oracledba7061504May1021:
19bocnetgyx.ctl
-rw-r-----1oracledba20979712May1021:
21data00001.dbf
-rw-r-----1oracledba104865792May1021:
22gyx_data02.dbf
-rw-r-----1oracledba104865792May1021:
23jiang01.dbf
-rw-r-----1oracledba262152192May1021:
25perfstat.dbf
-rw-r--r--1oracledba1821May1021:
15pfile_bocnetgyx.ora
-rw-r-----1oracledba283123712May1021:
26sysaux01.dbf
-rw-r-----1oracledba
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 物理 Standby 创建 过程