Physical Standby 转 Logical Standby

atyu30

ALTER DATABASE RECOVER TO LOGICAL STANDBY ATYU30STD
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: '/opt/oracle/oradata/ATYU30/system01.dbf'
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/opt/oracle/oradata/ATYU30/system01.dbf'
ORA-01206: file is not part of this database - wrong database id

renxiao2003

不太明白。建议楼主根据错误号查询一下。

atyu30

问题虽然是解决了，但是还是有些不明白
SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Database altered.

SHOW PARAMETER DB_NAME;NAME;


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      ATYU30
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY ATYU30STD;

SQL> SHOW PARAMETER DB_NAME;

NAME               TYPE        VALUE

-------------------------- ----------- ------------------------------

db_name             string      ATYU30STD

SQL> SELECT DATABASE_ROLE FROM V$DATABASE;

DATABASE_ROLE

----------------

LOGICAL STANDBY

atyu30

我的备份脚本

1. 
   
2. #!/bin/sh
   
3. BACKUPPATH=/data/backup/
   
4. /opt/oracle/product/10.2.0/db_1/bin/rman target / nocatalog  msglog $BACKPPATH/fullback.log append << EOF
   
5. RUN {
   
6. allocate channel c1 type disk;
   
7. allocate channel c2 type disk;
   
8. BACKUP FORMAT '/data/backup/ATYU30_%U_%T' skip inaccessible filesperset 5  DATABASE TAG ATYU30_hot_db_bk;
   
9. sql 'alter system archive log current';
   
10. BACKUP FORMAT '/data/backup/arch_%U_%T' skip inaccessible filesperset 5 ARCHIVELOG ALL DELETE INPUT;
    
11. backup current controlfile tag='bak_ctlfile' format='/data/backup/ctl_file_%U_%T';
    
12. release channel c2;
    
13. release channel c1;
    
14. }
    
15. exit;
    
16. EOF
    

复制代码

atyu30

克隆脚本

1. 
   
2. #!/bin/sh
   
3. RMAN=/opt/oracle/product/10.2.0/db_1/bin/rman
   
4. $RMAN target sys/dataguard@ATYU30 auxiliary sys/dataguard<< EOF
   
5. duplicate target database to ATYU30 nofilenamecheck;
   
6. EOF
   

复制代码

克隆的standby物理库无法转逻辑库
始终报1楼的错

但是同样用备份脚本备份完成以后，
NFS挂载

1. 
   
2. RMAN>restore database
   

复制代码

这样还原的standby，物理库转逻辑库就一切顺利？

费解