create pfile='/tmp/pfile.ora' from spfile; scp /tmp/pfile.ora 192.168.58.55:/tmp/
alter database create standby controlfile as '/tmp/control01.ctl'; scp /tmp/control01.ctl 192.168.58.55:/u01/app/oracle/oradata/ocmtest/control01.ctl
2.备库修改路径并使用pfile启动到nomount测试pfile是否能能使用 startup nomount pfile='/tmp/pfile.ora';
3.备库启动到mount
4.主库全备之后传到备库
5.注册备份集(若先备份再创建传送控制文件且路径位置相同 则可以不注册) catalog start with '/u01/app/oracle/admin/ocmtest/tmp';
6.若主备份的数据文件路径不同 则: select name from v$dbfile; show parameter conver alter system set db_file_name_c,'B' scope = spfile;重启(若主库某一数据文件的位置在A,则备库会放到B,可以多对)
7.还原数据文件 在备库: restore database;
8.手动查询并传递所需日志文件 SQL> recover standby database;
将所需归档 传到归档日志文件所在目录下
回车,完毕即可 readonly开机备库 alter database open read only;(此为手动方法,了解即可)
9.配归档传输 //chkconfig iptables off + service iptables stop 关闭防火墙 1)两端启动监听 2)确定能够互相连接 3)在两端 cd /u01/app/oracle/product/10.2.0/oracle/db_1/dbs下 orapwd file=orapwocmtest password=oracle创建密码文件 4)设置 log_archive_dest_* 到备库 alter system set log_archive_dest_1='SERVICE=ocmdg'; 5)设置 log_archive_dest_state_*为enable 6)开启自动恢复 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
10.添加standby logfile alter system set log_archive_dest_1='SERVICE=ocmdg LGWR SYNC NET_TIMEOUT=5';
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel; alter database add standby logfile group 6 ('/u01/app/oracle/slog/stb_redo01.log') size 52428800;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; select process,pid,status,client_process from v$managed_standby; |