物理Standby创建过程Word文档下载推荐.docx
《物理Standby创建过程Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《物理Standby创建过程Word文档下载推荐.docx(22页珍藏版)》请在冰豆网上搜索。
ORA-27037:
unabletoobtainfilestatus
Linux-x86_64Error:
2:
Nosuchfileordirectory
Additionalinformation:
3
创建失败,查询$ORACLE_HOME/dbs目录后发现该数据库用的就是pfile,没有用spfile,所以得首先创建spfile
在数据库open状态下创建pfile
createspfilefrompfile;
Filecreated.
再次创建pfile
(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'
*.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='
*.standby_file_management=auto
(3)根据pfile文件创建spfile
shutdownimmediate
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.
createspfilefrompfile='
;
\
查询新生成的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数据库的控制文件
startup;
ORA-32004:
obsoleteand/ordeprecatedparameter(s)specified
ORACLEinstancestarted.
TotalSystemGlobalArea268435456bytes
FixedSize2020088bytes
VariableSize113249544bytes
DatabaseBuffers150994944bytes
RedoBuffers2170880bytes
Databasemounted.
Databaseopened.
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的数据文件的路径
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
(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
47jiang01.dbf
-rw-r-----1oracledba262152192May1020:
49perfstat.dbf
-rw-r-----1oracledba283123712May1020:
45sysaux01.dbf
-rw-r-----1oracledba314580992May1020:
40system01.dbf
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:
bocnetgyx.ctl100%6896KB6.7MB/s00:
01
[oracle@BOCNETcold]$scpdata00001.dbforacle@192.168.56.9:
data00001.dbf100%20MB6.7MB/s00:
03
[oracle@BOCNETcold]$scpgyx_data02.dbforacle@192.168.56.9:
gyx_data02.dbf100%100MB5.9MB/s00:
17
[oracle@BOCNETcold]$scpjiang01.dbforacle@192.168.56.9:
Permissiondenied,pleasetryagain.
jiang01.dbf100%100MB6.7MB/s00:
15
[oracle@BOCNETcold]$scpperfstat.dbforacle@192.168.56.9:
perfstat.dbf100%250MB7.6MB/s00:
33
[oracle@BOCNETcold]$scpsysaux01.dbforacle@192.168.56.9:
sysaux01.dbf100%270MB6.3MB/s00:
43
[oracle@BOCNETcold]$scpsystem01.dbforacle@192.168.56.9:
system01.dbf100%300MB5.8MB/s00:
52
[oracle@BOCNETcold]$scptang01.dbforacle@192.168.56.9:
tang01.dbf100%100MB6.3MB/s00:
16
[oracle@BOCNETcold]$scpundotbs01.dbforacle@192.168.56.9:
undotbs01.dbf100%200MB6.3MB/s00:
32
[oracle@BOCNETcold]$scpusers01.dbforacle@192.168.56.9:
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
23jiang01.dbf
-rw-r-----1oracledba262152192May1021:
25perfstat.dbf
-rw-r--r--1oracledba1821May1021:
15pfile_gyx.ora
-rw-r-----1oracledba283123712May1021:
26sysaux01.dbf
-rw-r-----1oracledba314580992May1021:
28system01.dbf
29tang01.dbf
-rw-r-----1oracledba209723392May1021:
31undotbs01.dbf
-rw-r-----1oracledba9183232May1021:
32users01.dbf
[oracle@PRODBOCNETGYX]$cpbocnetgyx.ctlbocnetgyx02.ctl
[oracle@PRODBOCNETGYX]$cpbocnetgyx.ctlbocnetgyx03.ctl
total1403312
37bocnetgyx02.ctl
37bocnetgyx03.ctl
-rw-r--r--1oracledba1821May1021:
15pfile_bocnetgyx.ora
-rw-r-----1oracledba