Tema: Re: Oracle dievu ir pusdieviu:)
Autorius: Toxis@ze_yvil_place
Data: 2009-06-11 10:36:42
"Ness" <aggb_nutrinam@inbox.lt> wrote in message news:h0p4bc$r04$1@trimpas.omnitel.net...
> normaliai aplikacijos lygio duomenys niekaip negali issaukti 5 aktyvius redo
> logus (kai turi buti 1). Gal su oracle parametrais kazkas prizaista?
prie oraclo apskrytai lindau tik prie rman'o ir atkapstydamas konsole ($ set oracle_sid=YourInstanceName
$ emctl stop dbconsole
$ emca -deconfig dbcontrol db
$ emca -repos recreate
$ emca -config dbcontrol db )
>
> gali imesti rezultatus siu dvieju selectu?
>
> select name, value from v$parameter where lower(name) like '%file%' or
> lower(name) like 'log_%'
NAME VALUE
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
tracefile_identifier
spfile C:\ORACLE\10.2.0\DATABASE\SPFILEsid_name.ORA
fileio_network_adapters
filesystemio_options
file_mapping FALSE
control_files D:\ORACLE\ADMIN\FLASH_RECOVERY_AREA\sid_name\CONTROLFILE\O1_MF_4QV9RXHN_.CTL, E:\ORACLE\ORADATA\sid_name\CONTROLFILE\O1_MF_4QV9RXXS_.CTL, C:\ORACLE\ORADATA\sid_name\CONTROLFILE\O1_MF_4QV9RY5V_.CTL
db_file_name_convert
log_file_name_convert
control_file_record_keep_time 7
log_archive_config
log_archive_start FALSE
log_archive_dest
log_archive_duplex_dest
log_archive_dest_1 LOCATION=USE_DB_RECOVERY_FILE_DEST
log_archive_dest_2 LOCATION=USE_DB_RECOVERY_FILE_DEST2 OPTIONAL REOPEN=300 QUOTA_SIZE=2048
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_10
log_archive_dest_state_1 enable
log_archive_dest_state_2 enable
log_archive_dest_state_3 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_dest_state_6 enable
log_archive_dest_state_7 enable
log_archive_dest_state_8 enable
log_archive_dest_state_9 enable
log_archive_dest_state_10 enable
log_archive_max_processes 2
log_archive_min_succeed_dest 1
log_archive_trace 0
log_archive_local_first TRUE
log_archive_format ARC%S_%R.%T
log_buffer 6977024
log_checkpoint_interval 0
log_checkpoint_timeout 0
db_files 200
db_file_multiblock_read_count 16
db_create_file_dest E:\ORACLE\\ORADATA
db_recovery_file_dest D:\ORACLE\\ADMIN\FLASH_RECOVERY_AREA
db_recovery_file_dest_size 21474836480
standby_file_management MANUAL
gc_files_to_locks
log_checkpoints_to_alert FALSE
logmnr_max_persistent_sessions 1
remote_login_passwordfile EXCLUSIVE
utl_file_dir c:\oracle\10.2.0\DATABASE
audit_file_dest D:\ORACLE\ADMIN\sid_name\ADUMP
max_dump_file_size 4194304
session_max_open_files 10
ifile
dg_broker_config_file1 C:\ORACLE\10.2.0\DATABASE\DR1sid_name.DAT
dg_broker_config_file2 C:\ORACLE\10.2.0\DATABASE\DR2sid_name.DAT
>
> SELECT a.*, b.* FROM v$logfile a, v$log b WHERE a.group# = b.group#
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------------------- ------- ------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- -------- ---------------- ---------------------- -------------------------
1 INVALID ONLINE D:\ORACLE\ADMIN\FLASH_RECOVERY_AREA\sid_name\ONLINELOG\O1_MF_1_4QV9RZLK_.LOG NO 1 1 371 104857600 3 NO CURRENT 19932319 2009.06.11
1 ONLINE E:\ORACLE\ORADATA\sid_name\ONLINELOG\O1_MF_1_4QV9S29R_.LOG NO 1 1 371 104857600 3 NO CURRENT 19932319 2009.06.11
1 INVALID ONLINE C:\ORACLE\ORADATA\sid_name\ONLINELOG\O1_MF_1_4QV9S54W_.LOG NO 1 1 371 104857600 3 NO CURRENT 19932319 2009.06.11
2 INVALID ONLINE D:\ORACLE\ADMIN\FLASH_RECOVERY_AREA\sid_name\ONLINELOG\O1_MF_2_4QV9S7OH_.LOG