搭建物理standby时启动备库报错如下：

点击( 此处 )折叠或打开

1. SQL > startup pfile = '/u01/app/oracle/product/11.2.0/db_1/dbs/initshanghai.ora' ;
   

2. ORACLE instance started .
   

3. 
   

4. Total System Global Area  839282688 bytes
   

5. Fixed Size             2233000 bytes
   

6. Variable Size           520097112 bytes
   

7. Database Buffers      314572800 bytes
   

8. Redo Buffers            2379776 bytes
   

9. Database mounted .
   

10. ORA - 10458 : standby database requires recovery
    

11. ORA - 01157 : cannot identify/ lock data file 1 - see DBWR trace file
    

12. ORA - 01110 : data file 1 : '/u01/app/oracle/oradata/beijing/system01.dbf'

点击( 此处 )折叠或打开

1. SQL > select name from v$datafile ;
   

2. 
   

3. NAME
   

4. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
   

5. /u01/app/oracle/oradata/beijing/system01 . dbf
   

6. /u01/app/oracle/oradata/beijing/sysaux01 . dbf
   

7. /u01/app/oracle/oradata/beijing/undotbs01 . dbf
   

8. /u01/app/oracle/oradata/beijing/users01 . dbf
   

9. /u01/app/oracle/oradata/beijing/example01 . dbf

这个是主库的路径，猜测路径转换没成功。

SQL> show parameter convert
NAME                 TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert             string     /u01/app/oracle/oradata/shanghai,/u01/app/oracle/oradata/beijing, ;
log_file_name_convert             string     /u01/app/oracle/oradata/shanghai,, /u01/app/oracle/oradata/beijing;

完蛋，参数文件中写错了。。。哈哈哈哈哈哈哈哈哈哈 ，查看没写写了一半的引号。。。哈哈哈哈哈哈哈

还有一种可能啊，db_file_name_convert中前后路径的顺序也会影响的，也就是说这里的路径是有顺序的