2)上面结果提到USE_DB_RECOVERY_FILE_DEST这个Archive destination,其实我们可以去掉“USE_”使用“DB_RECOVERY_FILE_DEST”得到数据库中的参数详解。 sys@ora10g> show parameter DB_RECOVERY_FILE_DEST
NAME TYPE VALUE --------------------- ----------- -------------------------------------- db_recovery_file_dest string /oracle/app/oracle/flash_recovery_area
3)将db_recovery_file_dest参数置空 alter system set db_recovery_file_dest = '' scope=spfile;
4)以防万一,将log_archive_dest参数也置空 alter system set log_archive_dest = '' scope=spfile;
5)我们这里采用的生效参数是log_archive_dest_1,修改方法如下。请注意语法 alter system set log_archive_dest_1 = 'location=/oracle/arch/ora10g' scope=spfile;
3.修改流程介绍完毕,我们再一起讨论一些有趣的现象。 1)有趣现象一:使用log_archive_dest参数,不使用上面提到的log_archive_dest_1参数一样可以达到修改归档路径的目的 精简式列一下这个修改流程: (1)修改归档文件格式 alter system set log_archive_format='%t_%s_%r.arch' scope=spfile; (2)将db_recovery_file_dest置空 alter system set db_recovery_file_dest = '' scope=spfile; (3)将log_archive_dest_1置空 alter system set log_archive_dest_1 = '' scope=spfile; (4)启用log_archive_dest参数 alter system set log_archive_dest = '/oracle/arch/ora10g' scope=spfile; (5)重启数据库使上面的所有参数生效 shutdown immediate; startup; (6)当然,上面的过程一样可以通过修改pfile的方法来完成 修改后的pfile关键参数内容如下: *.log_archive_format='%t_%s_%r.arch' *.db_recovery_file_dest='' *.log_archive_dest='/oracle/arch/ora10g' *.log_archive_dest_1=''
(3)“有趣”现象出现了 sys@ora10g> alter system switch logfile; sys@ora10g> alter system switch logfile; sys@ora10g> col NAME for a40 sys@ora10g> alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss'; sys@ora10g> select recid, name, first_time from v$archived_log;
(3)实验结果如下 sys@ora10g> alter system switch logfile; sys@ora10g> alter system switch logfile; sys@ora10g> col NAME for a40 sys@ora10g> alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss'; sys@ora10g> select recid, name, first_time from v$archived_log;