check parameters

SQL> set linesize 200
set pagesize 1000
column name format a40
column value format a60
select inst_id, name,value from gv$parameter
where name in ('db_create_file_dest',
               'audit_file_dest',
               'audit_trail',
               'diagnostic_dest',
               'standby_file_management',
               'db_recovery_file_dest_size',
               'db_create_online_log_dest_1',
               'db_create_online_log_dest_2',
               'log_archive_format',
               'log_archive_dest_1')
order by name;

   INST_ID NAME                                     VALUE
---------- ---------------------------------------- ------------------------------------------------------------
         1 audit_file_dest                          /u01/app/oracle/admin/SHESTSU/adump
         2 audit_file_dest                          /u01/app/oracle/admin/SHESTSU/adump
         2 audit_trail                              OS
         1 audit_trail                              OS
         2 db_create_file_dest                      +REG_DATA01
         1 db_create_file_dest                      +REG_DATA01
         2 db_create_online_log_dest_1              +REDOLOG01
         1 db_create_online_log_dest_1              +REDOLOG01
         1 db_create_online_log_dest_2              +REDOLOG02
         2 db_create_online_log_dest_2              +REDOLOG02
         1 db_recovery_file_dest_size               10737418240
         2 db_recovery_file_dest_size               10737418240
         1 diagnostic_dest                          /u01/app/oracle/admin
         2 diagnostic_dest                          /u01/app/oracle/admin
         1 log_archive_dest_1                       LOCATION=USE_DB_RECOVERY_FILE_DEST
         2 log_archive_dest_1                       LOCATION=USE_DB_RECOVERY_FILE_DEST
         2 log_archive_format                       %t_%s_%r.dbf
         1 log_archive_format                       %t_%s_%r.dbf
         2 standby_file_management                  MANUAL
         1 standby_file_management                  MANUAL

20 rows selected.

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

转载于:http://blog.itpub.net/26664718/viewspace-2153229/