我使用的是在同一主机上使用 RMAN 备份建立物理备用数据库的方法，系统是windows XP，步骤如下：
1.备份
RMAN> backup database plus archivelog
2> format='d:\backup\%d_%s.bak';
RMAN> backup current controlfile for standby
2> format='d:\backup\%d_%s.bak';
2.建立存放备用数据库相关文件的 OS 目录和例程服务
C:\>oradim -new -sid standby -syspwd orcl
3.配置监听程序和网络服务名
只更改了tnsnames.ora中的配置
4.准备主数据库参数文件
SQL> create pfile from spfile;
修改参数文件 initdemo.ora:
fal_client='demo'
fal_server='standby'
log_archive_config='dg_config=(demo,standby)'
log_archive_dest_2='service=standby valid_for=(online_logfiles,primary_role) db_unique_name=standby'
log_archive_dest_1='location=d:\demo\archive valid_for=(all_logfiles,all_roles) db_unique_name=demo'
standby_file_management='auto'
SQL> shutdown immediate
SQL> create spfile from pfile;
SQL> startup
5.准备备用数据库参数文件
SQL> create pfile='%oracle_home%\database\initstandby.ora'
2from spfile;
修改参数文件 initstandby.ora :
audit_file_dest='D:\standby\adump'
background_dump_dest='D:\standby\bdump'
control_files='d:\standby\control01.ctl'
core_dump_dest='D:\standby\cdump'
user_dump_dest='D:\standby\udump'
standby_file_management='auto'
db_unique_name='standby'
service_names=standby
instance_name=standby
fal_client='standby'
fal_server='demo'
log_archive_config='dg_config=(demo,standby)'
log_archive_dest_1='location=d:\standby\archive valid_for=(all_logfiles,all_roles) db_unique_name=standby'
log_archive_dest_2='service=demo valid_for=(online_logfiles,primary_role) db_unique_name=demo'
db_file_name_convert='d:\demo','d:\standby'
log_file_name_convert='d:\demo\','d:\standby','c:\demo','standby'
standby_archive_dest='d:\standby\archive'
SQL> create spfile='%oracle_home%\database\spfilestandby.ora'
2from pfile='%oracle_home%\database\initstandby.ora';
6.启用备用例程并建立备用数据库
C:\>sqlplus sys/orcl@standby as sysdba
SQL> startup nomount
C:\>rman target sys/orcl@demo auxiliary sys/orcl@standby
RMAN> duplicate target database for standby dorecover;
7.启用备用数据库
C:\>sqlplus sys/orcl@standby as sysdba
SQL> conn sys/orcl@demo as sysdba
SQL> alter system switch logfile;
SQL> conn sys/orcl@standby as sysdba
SQL> select name from v$archived_log;
但是结果显示无任何行，也就是归档日志未成功传送到备用数据库
求高手指点，非常感谢！！！
|
