***************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/
,如需转载,请注明出处,否则将追究法律责任。