[ОТВЕТИТЬ]
Опции темы
14.11.2014 15:20  
iiadre89
Как восстановить базу из бекапа rman? Проблема в ошибке ORA-01595, знаю что можно это сделать через rman, но беда в том что не знаю как пошагово это сделать.
 
14.11.2014 15:40  
iiadre89
А вот что пишется в ALert.log



Dump file d:\oracle\product\10.2.0\admin\shuba16\bdump\alert_shuba16.log
Fri Nov 14 12:24:19 2014
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:971M/2977M, Ph+PgF:4113M/5954M, VA:1916M/2047M
Fri Nov 14 12:24:19 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
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.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 356515840
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
nls_language = RUSSIAN
nls_territory = RUSSIA
sga_target = 893386752
control_files = D:\ORACLE\ORADATA\SHUBA16\CONTROL01.CTL, D:\ORACLE\ORADATA\SHUBA16\CONTROL02.CTL, D:\ORACLE\ORADATA\SHUBA16\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 520093696
compatible = 10.2.0.3.0
log_archive_format = ARC%S_%R.%T
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size= 214748364800
undo_management = AUTO
undo_tablespace = UNDOTBS1
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=SHUBA16XDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\SHUBA16\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\SHUBA16\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\SHUBA16\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\SHUBA16\CDUMP
db_name = SHUBA16
open_cursors = 300
pga_aggregate_target = 296747008
PMON started with pid=2, OS id=7840
MMAN started with pid=4, OS id=8024
DBW0 started with pid=5, OS id=7084
LGWR started with pid=6, OS id=156
CKPT started with pid=7, OS id=2812
SMON started with pid=8, OS id=5728
RECO started with pid=9, OS id=8012
CJQ0 started with pid=10, OS id=3976
MMON started with pid=11, OS id=4440
Fri Nov 14 12:24:19 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Nov 14 12:24:19 2014
starting up 1 shared server(s) ...
Fri Nov 14 12:24:19 2014
alter database mount exclusive
PSP0 started with pid=3, OS id=6832
MMNL started with pid=12, OS id=6108
Fri Nov 14 12:24:24 2014
Setting recovery target incarnation to 1
Fri Nov 14 12:24:24 2014
Successful mount of redo thread 1, with mount id 215804403
Fri Nov 14 12:24:24 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Nov 14 12:24:24 2014
alter database open
Fri Nov 14 12:24:24 2014
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Fri Nov 14 12:24:24 2014
Started redo scan
Fri Nov 14 12:24:24 2014
Completed redo scan
233 redo blocks read, 107 data blocks need recovery
Fri Nov 14 12:24:24 2014
Started redo application at
Thread 1: logseq 9916, block 3
Fri Nov 14 12:24:25 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 9916 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\SHUBA16\REDO01.LOG
Fri Nov 14 12:24:25 2014
Completed redo application
Fri Nov 14 12:24:25 2014
Completed crash recovery at
Thread 1: logseq 9916, block 236, scn 291478841
107 data blocks read, 107 data blocks written, 233 redo blocks read
Fri Nov 14 12:24:26 2014
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=18, OS id=6992
ARC1 started with pid=19, OS id=4396
Fri Nov 14 12:24:27 2014
ARC0: Archival started
Fri Nov 14 12:24:27 2014
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Fri Nov 14 12:24:27 2014
Thread 1 advanced to log sequence 9917 (thread open)
Thread 1 opened at log sequence 9917
Current log# 2 seq# 9917 mem# 0: D:\ORACLE\ORADATA\SHUBA16\REDO02.LOG
Successful open of redo thread 1
Fri Nov 14 12:24:27 2014
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Nov 14 12:24:27 2014
SMON: enabling cache recovery
Fri Nov 14 12:24:27 2014
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Nov 14 12:24:27 2014
ARC1: Becoming the heartbeat ARCH
Fri Nov 14 12:24:28 2014
db_recovery_file_dest_size of 204800 MB is 11.45% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Nov 14 12:24:28 2014
Successfully onlined Undo Tablespace 1.
Fri Nov 14 12:24:28 2014
SMON: enabling tx recovery
Fri Nov 14 12:24:28 2014
Database Characterset is CL8MSWIN1251
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=20, OS id=8060
Fri Nov 14 12:24:34 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_smon_5728.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [47], [42], [], [], [], [], []

Fri Nov 14 12:24:34 2014
Completed: alter database open
Fri Nov 14 12:24:36 2014
Doing block recovery for file 2 block 14
Block recovery from logseq 9917, block 73 to scn 291479049
Fri Nov 14 12:24:36 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 9917 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\SHUBA16\REDO02.LOG
Block recovery completed at rba 9917.81.16, scn 0.291479050
Doing block recovery for file 2 block 9
Block recovery from logseq 9917, block 73 to scn 291479037
Fri Nov 14 12:24:37 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 9917 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\SHUBA16\REDO02.LOG
Block recovery completed at rba 9917.74.16, scn 0.291479040
Fri Nov 14 12:24:37 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_smon_5728.trc:
ORA-01595: ошибка при освобождении экстента (2) сегмента отката (1)
ORA-00607: Внутренняя ошибка при внесении изменения в блок данных
ORA-00600: код внутр. ошибки, аргументы: [4194], [47], [42], [], [], [], [], []

Fri Nov 14 12:24:39 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_j001_7088.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [20], [15], [], [], [], [], []

Fri Nov 14 12:24:40 2014
DEBUG: Replaying xcb 0x43fa0440, pmd 0x434b68dc for failed op 8
Doing block recovery for file 2 block 108
No block recovery was needed
Fri Nov 14 12:24:41 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_j001_7088.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [20], [15], [], [], [], [], []
ORA-00600: код внутр. ошибки, аргументы: [4194], [20], [15], [], [], [], [], []

Fri Nov 14 12:24:42 2014
DEBUG: Replaying xcb 0x43fa0440, pmd 0x434b68dc for failed op 8
Fri Nov 14 12:24:42 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_j001_7088.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [20], [15], [], [], [], [], []
ORA-00600: код внутр. ошибки, аргументы: [4194], [20], [15], [], [], [], [], []

Doing block recovery for file 2 block 108
No block recovery was needed
Fri Nov 14 12:24:43 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_j001_7088.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4194], [20], [15], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [20], [15], [], [], [], [], []

Fri Nov 14 12:24:43 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_mmon_4440.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [20], [15], [], [], [], [], []

Fri Nov 14 12:24:43 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_j000_8080.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [47], [42], [], [], [], [], []

Fri Nov 14 12:24:44 2014
DEBUG: Replaying xcb 0x43fc3b40, pmd 0x434c74f0 for failed op 8
Doing block recovery for file 2 block 14
Block recovery from logseq 9917, block 73 to scn 291479049
Fri Nov 14 12:24:45 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 9917 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\SHUBA16\REDO02.LOG
Block recovery completed at rba 9917.81.16, scn 0.291479050
Fri Nov 14 12:24:45 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_j000_8080.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [47], [42], [], [], [], [], []
ORA-00600: код внутр. ошибки, аргументы: [4194], [47], [42], [], [], [], [], []

Fri Nov 14 12:24:46 2014
DEBUG: Replaying xcb 0x43fa0440, pmd 0x434b68dc for failed op 8
Doing block recovery for file 2 block 108
No block recovery was needed
Fri Nov 14 12:24:46 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_j000_8080.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [47], [42], [], [], [], [], []
ORA-00600: код внутр. ошибки, аргументы: [4194], [47], [42], [], [], [], [], []

Fri Nov 14 12:24:47 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_pmon_7840.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [20], [15], [], [], [], [], []

Fri Nov 14 12:24:47 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_j000_8080.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4194], [47], [42], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [47], [42], [], [], [], [], []

Fri Nov 14 12:24:48 2014
DEBUG: Replaying xcb 0x43fa0440, pmd 0x434b68dc for failed op 8
Doing block recovery for file 2 block 108
No block recovery was needed
Fri Nov 14 12:24:48 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_pmon_7840.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [20], [15], [], [], [], [], []

Fri Nov 14 12:24:48 2014
PMON: terminating instance due to error 472
Fri Nov 14 12:24:48 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_q001_7548.trc:
ORA-00472: процесс PMON завершился с ошибкой

Fri Nov 14 12:24:48 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_lgwr_156.trc:
ORA-00472: процесс PMON завершился с ошибкой

Fri Nov 14 12:24:49 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_reco_8012.trc:
ORA-00472: процесс PMON завершился с ошибкой

Fri Nov 14 12:24:49 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_smon_5728.trc:
ORA-00472: процесс PMON завершился с ошибкой

Fri Nov 14 12:24:49 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_ckpt_2812.trc:
ORA-00472: процесс PMON завершился с ошибкой

Fri Nov 14 12:24:50 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_mman_8024.trc:
ORA-00472: процесс PMON завершился с ошибкой

Fri Nov 14 12:24:50 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_dbw0_7084.trc:
ORA-00472: процесс PMON завершился с ошибкой

Fri Nov 14 12:24:50 2014
Errors in file d:\oracle\product\10.2.0\admin\shuba16\bdump\shuba16_psp0_6832.trc:
ORA-00472: процесс PMON завершился с ошибкой

Instance terminated by PMON, pid = 7840
 
14.11.2014 17:06  
OlegON
А бекап-то через RMAN делали?
 
16.11.2014 14:55  
iiadre89
Да.
 
17.11.2014 08:37  
Dim
помогло пересоздание undo
 
 
Опции темы



Часовой пояс GMT +3, время: 05:24.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.