我的是
SQL> Select name,SWITCHOVER_STATUS,open_mode,PROTECTION_MODE,DATABASE_ROLE from v$database;
NAME SWITCHOVER_STATUS OPEN_MODE PROTECTION_MODE DATABASE_ROLE
--------- -------------------- ---------- -------------------- ----------------
ORA10G SESSIONS ACTIVE MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY
开始的时候,备库standby_archive_dest 如下:
SQL> show parameter standby
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string ?/dbs/arch
standby_file_management string AUTO
我建立了$ORACLE_HOME/dbs/arch目录,$ORACLE_HOME就是 /study/oracle10g/product/10.2.0/
后来改为:
SQL> show parameter standby
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string /study/oracle10g/product/10.2.0/dbs/arch
发觉传输的时候/study/oracle10g/product/10.2.0/dbs/arch 下就有arc的文件了,
请问?/dbs/arch 和 /study/oracle10g/product/10.2.0/arch 就是同一个路径下,为啥开始的 ?/dbs/arch 没有起作用呢?
SQL> Select name,SWITCHOVER_STATUS,open_mode,PROTECTION_MODE,DATABASE_ROLE from v$database;
NAME SWITCHOVER_STATUS OPEN_MODE PROTECTION_MODE DATABASE_ROLE
--------- -------------------- ---------- -------------------- ----------------
ORA10G SESSIONS ACTIVE MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY
开始的时候,备库standby_archive_dest 如下:
SQL> show parameter standby
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string ?/dbs/arch
standby_file_management string AUTO
我建立了$ORACLE_HOME/dbs/arch目录,$ORACLE_HOME就是 /study/oracle10g/product/10.2.0/
后来改为:
SQL> show parameter standby
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string /study/oracle10g/product/10.2.0/dbs/arch
发觉传输的时候/study/oracle10g/product/10.2.0/dbs/arch 下就有arc的文件了,
请问?/dbs/arch 和 /study/oracle10g/product/10.2.0/arch 就是同一个路径下,为啥开始的 ?/dbs/arch 没有起作用呢?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8497396/viewspace-748639/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8497396/viewspace-748639/