ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 练习standby (非rman)

练习standby (非rman)

原创 Linux操作系统 作者:lxz3000 时间:2008-03-27 15:23:07 0 删除 编辑
***************standby not rman*****************
0.linux cp *.dbf    to the standby database data_file_dest.
   be careful the directory and parameter *.db_file_name_convert='/u04','/u03'
1.alter database create standby controlfile as './standby.ctl' ;
2.init.ora/spfile.ora
   *.db_name = primarydb(can not be changed) instance_name/service_names = (can change)
   *.control_files='/u01/control01.ctl','/u02/control02.ctl','........ (copy the standby.ctl to the target directorys and rename them)
   *.log_archive_dest_1='LOCATION=/u03/oradata/db1/archivelogs MANDATORY REOPEN'
   *.log_archive_format='%t_%s_%r.dbf'
   *.log_file_name_convert='/u04','/u03'
   *.db_file_name_convert='/u04','/u03'
   *.fal_client='std_db1'
   *.fal_server='pri_db1'
   *.standby_archive_dest='/u03/oradata/db1/archivelogs'
   *.standby_file_management='AUTO'

   primary db init.ora/spfile
   *.fal_client='pri_db1'
   *.fal_server='std_db1'
   *.log_archive_dest_2='SERVICE=std_terrydb1 reopen=60'  (can modify later)

   create pfile from spfile  ==> edit pfile ==> create spfile from pfile
3.listener.ora,tnsnames.ora
4.orapwd file=$ORALCE_HOME/dbs/orapwdb1 password=oracle entries=4
5.startup nomount    (after create spfile)
   alter database mount standby database
   lsnrctl start
   alter system register
   alter database recover managed standby database disconnect from session
6.alter system set log_archive_dest_2='SERVICE=std_terrydb1 reopen=60' (on primary db and then the logs will archived to the standby database)
   perhaps I should do step 6 before alter database recover managed standby database disconnect from session.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/10341434/viewspace-218024/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-13

  • 博文量
    44
  • 访问量
    92497