Menu de navegação

[mpvargasParticipante]

Fala Rodrigo…
Também no deu certo… segue abaixo as ultimas linhas do alert.log
Não encontrei nada de anormal

starting up 1 shared server(s) …
Tue Oct 4 15:27:49 2011
ALTER SYSTEM SET _offline_rollback_segments=’TRUE’ SCOPE=SPFILE;
Tue Oct 4 15:27:59 2011
Shutting down instance: further logons disabled
Tue Oct 4 15:27:59 2011
Stopping background process MMNL
Tue Oct 4 15:27:59 2011
Stopping background process CJQ0
Tue Oct 4 15:28:00 2011
Stopping background process MMON
Tue Oct 4 15:28:01 2011
Shutting down instance (immediate)
License high water mark = 1
Tue Oct 4 15:28:01 2011
Stopping Job queue slave processes
Tue Oct 4 15:28:01 2011
Job queue slave processes stopped
Waiting for dispatcher ‘D000’ to shutdown
All dispatchers and shared servers shutdown
Tue Oct 4 15:28:03 2011
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL…
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Oct 4 15:31:27 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 113246208
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 8388608
nls_language = AMERICAN
nls_territory = AMERICA
sga_target = 503316480
control_files = /u01/app/oracle/oradata/asoec10t/control01.ctl, /u01/app/oracle/oradata/asoec10t/control02.ctl, /u01/app/oracle/oradata/asoec10t/control03.ctl
db_block_size = 8192
__db_cache_size = 364904448
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_allow_resetlogs_corruption= TRUE
_offline_rollback_segments= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=asoec10tXDB)
utl_file_dir = /logs/diretorios/utl_leandro
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/asoec10t/bdump
user_dump_dest = /u01/app/oracle/admin/asoec10t/udump
core_dump_dest = /u01/app/oracle/admin/asoec10t/cdump
audit_file_dest = /u01/app/oracle/admin/asoec10t/adump
db_name = asoec10t
open_cursors = 300
pga_aggregate_target = 250000000
PMON started with pid=2, OS id=27687
PSP0 started with pid=3, OS id=27689
MMAN started with pid=4, OS id=27691
DBW0 started with pid=5, OS id=27693
LGWR started with pid=6, OS id=27695
CKPT started with pid=7, OS id=27698
SMON started with pid=8, OS id=27700
RECO started with pid=9, OS id=27702
CJQ0 started with pid=10, OS id=27707
MMON started with pid=11, OS id=27709
Tue Oct 4 15:31:28 2011
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
MMNL started with pid=12, OS id=27711
Tue Oct 4 15:31:28 2011
starting up 1 shared server(s) …
Tue Oct 4 15:31:28 2011
ALTER DATABASE MOUNT
Tue Oct 4 15:31:32 2011
Setting recovery target incarnation to 1
Tue Oct 4 15:31:32 2011
Successful mount of redo thread 1, with mount id 2261589072
Tue Oct 4 15:31:32 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Oct 4 15:31:32 2011
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN…

[vpapaParticipante]

Opa,

Tentou o que te disse? Recria o controlfile removendo o datafile que resolve, mas creio que pelo tempo perdido era mais facil ter refeito a base de teste.

Att,

[Regis AraujoParticipante]

Opa..

Boa noite senhores..!!

Vargas.. faz o seguinte.. coloca estes parametros direto no INIT e sobe o banco pelo INIT, e depois cria um SPFILE.. Pois já tive problema de alterar um parametro via alter system e no final ele não alterar direito..

Faz este procedimento..

Outra coisa.. antes de subir o banco com o parametro..coloca o banco em modo MOUNT e e da um select na V$DATAFILE_HEADER e verifica o status dos datafiles e o SCN de cada um..

Bom, já usei este artificio do _allow_resetlogs_corruption e tive relativo sucesso.. pena q perdi as informações posteriores ao SCN do datafile sem sincronia..

Abraços..!

[Autor]

Posts