ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-16009

ORA-16009

原创 Linux操作系统 作者:frog-qs 时间:2011-07-04 11:01:25 0 删除 编辑
ALTER DATABASE RECOVER  managed standby database 
Mon Jul  4 09:43:55 2011
Media Recovery Start: Managed Standby Recovery (orcl)
Managed Standby Recovery not using Real Time Apply
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
 parallel recovery started with 2 processes
 该警告是由于在备份数据库的时候,没有关闭主库直接复制过去,重新将数据文件备份到备库
 恢复文件,警告消失。
 recover managed standby database;

 ORA-16009: remote archive log destination must be a STANDBY database
oracle@pri:~> oerr ora 16009
16009, 00000, "remote archive log destination must be a STANDBY database"
// *Cause:  The database associated with the archive log destination service
//          name is other than the required STANDBY type database.
//          Remote archival of redo log files is not allowed to non-STANDBY
//          database instances.
// *Action: Take the necessary steps to create the required compatible STANDBY
//          database before retrying the ARCHIVE LOG processing.
检查参数,配置并没有错
SQL> show parameter log_archive_dest_2
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string      service=pri lgwr async valid_f
                                                 r=(online_logfiles,primary_ro
                                                 les) db_unique_name=pri
SQL> show parameter log_archive_dest_1
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      location=/opt/oracle/oradata/o
                                                 rcl/arch/ valid_for=(all_logfi
                                                 les,all_roles) db_unique_name=
                                                 std
log_archive_dest_10                  string
查看监听文件,里面的主机ip地址配置错误,重新配置问题解决。

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

下一篇: SQL 优化部分说明
请登录后发表评论 登录
全部评论

注册时间:2009-10-27

  • 博文量
    132
  • 访问量
    249458