Восстановление БД из Бекапа : Oracle

Всем привет.

Есть бекап файловый, с остановленными службами до, безусловно.

путь БД 1 в 1, но после того как подкладываешь пишет ошибку:

SQL> startup
Экземпляр ORACLE запущен.

Total System Global Area 6413680640 bytes
Fixed Size 2293216 bytes
Variable Size 1107296800 bytes
Database Buffers 5284823040 bytes
Redo Buffers 19267584 bytes
База данных смонтирована.
ORA-03113: принят сигнал конца файла по коммуникационному каналу
Идентификатор процесса: 1572
Идентификатор сеанса: 241 Порядковый номер: 3


Как обойти?

попытался сделать вот такой финт:

SQL> recover database until cancel using backup controlfile;
ORA-00279: изменение 393350642, сгенерированное 08/01/2019 23:31:10, необходимо
для 1
ORA-00289: предложение : C:\ORACLE\SERVER\RDBMS\ARC0000016891_0926173947.0001
ORA-00280: изменение 393350642 для потока 1 в последовательности #16891


Задайте журнал: {<RET>=предложенный | имя файла | AUTO | CANCEL}
d:\REDO01.LOG
ORA-00308: cannot open archived log 'd:\REDO01.LOG'
ORA-27047: unable to read the header block of file
OSD-04006: сбой ReadFile(), чтение из файла невозможно
O/S-Error: (OS 87) Параметр задан неверно.


Задайте журнал: {<RET>=предложенный | имя файла | AUTO | CANCEL}
cancel
Восстановление носителя отменено.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ошибка в строке 1:
ORA-00344: невозможно пересоздать оперативный журнал
'D:\ORACLE\ORADATA\MAG\REDO01.LOG'
ORA-27040: ошибка создания файла, невозможно создать файл
OSD-04001: недопустимый размер логического блока (OS 512)


SQL>

что из этого не понятно?

Версия Oracle, был ли установлен оптимизатор? Что в алерте?

Ну явно не может прочитать файлик, вопрос что мешает ему?

11.2.0.4

нет

<msg time='2019-08-06T12:07:00.191+03:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:3076:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='DESKTOP-KB6RJHE'
host_addr='fe80::7446:2a89:80b2:f01d%14' module='sqlplus.exe' pid='7720'>
<txt>ALTER DATABASE RECOVER LOGFILE &apos;d:\REDO02.log&apos;
</txt>
</msg>
<msg time='2019-08-06T12:07:00.191+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module='sqlplus.exe'
pid='7720'>
<txt>Media Recovery Log d:\REDO02.log
</txt>
</msg>
<msg time='2019-08-06T12:07:00.206+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module=''
pid='1156'>
<txt>WARNING! THE LOGICAL BLOCKSIZE (512) OF LOGFILE MEMBER D:\REDO02.LOG IS LESS THAN THE PHYSICAL SECTOR SIZE (4096). LOGFILE WRITES ARE NOT SECTOR ALIGNED. THIS MAY LEAD TO DEGRADED PERFORMANCE DUE TO THE READ-MODIFY-WRITE OPERATIONS.
</txt>
</msg>

видимо надо сменить размер блока в параметрах бд, да?

Перезапусти базу и дай нормальный алерт почитать с момента старта.

Простите за тупость, а как сюда файлик добавить, ну просто текстом живым, то вот...

<txt>Starting up:
</txt>
</msg>
<msg time='2019-08-06T12:36:12.949+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15674:3284844642' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt>Oracle Database 11g Release 11.2.0.4.0 - 64bit Production.
</txt>
</msg>
<msg time='2019-08-06T12:36:12.949+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15687:4222364190' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt>Windows NT Version V6.2
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:13842M/16258M, Ph+PgF:10803M/19202M
</txt>
</msg>
<msg time='2019-08-06T12:36:12.964+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15756:1489803337' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt>Using parameter settings in server-side spfile C:\ORACLE\SERVER\DATABASE\SPFILEMAG.ORA
</txt>
</msg>
<msg time='2019-08-06T12:36:12.964+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15789:144004252' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt>System parameters with non-default values:
</txt>
</msg>
<msg time='2019-08-06T12:36:12.964+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15825:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> processes = 300
</txt>
</msg>
<msg time='2019-08-06T12:36:12.964+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15825:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> sessions = 472
</txt>
</msg>
<msg time='2019-08-06T12:36:12.964+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15825:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> sga_target = 6G
</txt>
</msg>
<msg time='2019-08-06T12:36:12.964+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> control_files = &quot;D:\ORACLE\ORADATA\MAG\CONTROL01.CTL&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:12.964+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> control_files = &quot;D:\ORACLE\ORADATA\MAG\CONTROL02.CTL&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:12.964+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15825:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> db_block_size = 8192
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> compatible = &quot;11.2.0.4.0&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> undo_tablespace = &quot;UNDOTBS1&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15825:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> O7_DICTIONARY_ACCESSIBILITY= TRUE
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> remote_login_passwordfile= &quot;EXCLUSIVE&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> db_domain = &quot;&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> audit_file_dest = &quot;D:\ORACLE\ORADATA\ADMIN\MAG\ADUMP&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> audit_trail = &quot;DB&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> db_name = &quot;MAG&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15825:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> open_cursors = 300
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15825:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> pga_aggregate_target = 2G
</txt>
</msg>
<msg time='2019-08-06T12:36:12.980+03:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:15816:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8164'>
<txt> diagnostic_dest = &quot;D:\ORACLE\ORADATA&quot;
</txt>
</msg>
<msg time='2019-08-06T12:36:23.432+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='3664'>
<txt>PMON started with pid=2, OS id=3664
</txt>
</msg>
<msg time='2019-08-06T12:36:23.432+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='2468'>
<txt>PSP0 started with pid=3, OS id=2468
</txt>
</msg>
<msg time='2019-08-06T12:36:24.447+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='7784'>
<txt>VKTM started with pid=4, OS id=7784 at elevated priority
</txt>
</msg>
<msg time='2019-08-06T12:36:24.447+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module=''
pid='7784'>
<txt>VKTM running at (10)millisec precision with DBRM quantum (100)ms
</txt>
</msg>
<msg time='2019-08-06T12:36:24.510+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='540'>
<txt>GEN0 started with pid=5, OS id=540
</txt>
</msg>
<msg time='2019-08-06T12:36:24.510+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='5688'>
<txt>DIAG started with pid=6, OS id=5688
</txt>
</msg>
<msg time='2019-08-06T12:36:24.510+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='1576'>
<txt>DBRM started with pid=7, OS id=1576
</txt>
</msg>
<msg time='2019-08-06T12:36:24.510+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8352'>
<txt>DIA0 started with pid=8, OS id=8352
</txt>
</msg>
<msg time='2019-08-06T12:36:24.525+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='4988'>
<txt>MMAN started with pid=9, OS id=4988
</txt>
</msg>
<msg time='2019-08-06T12:36:24.525+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='5264'>
<txt>DBW0 started with pid=10, OS id=5264
</txt>
</msg>
<msg time='2019-08-06T12:36:24.525+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='9048'>
<txt>LGWR started with pid=11, OS id=9048
</txt>
</msg>
<msg time='2019-08-06T12:36:24.541+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='1620'>
<txt>CKPT started with pid=12, OS id=1620
</txt>
</msg>
<msg time='2019-08-06T12:36:24.541+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='6188'>
<txt>SMON started with pid=13, OS id=6188
</txt>
</msg>
<msg time='2019-08-06T12:36:24.541+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='7588'>
<txt>RECO started with pid=14, OS id=7588
</txt>
</msg>
<msg time='2019-08-06T12:36:24.541+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8004'>
<txt>MMON started with pid=15, OS id=8004
</txt>
</msg>
<msg time='2019-08-06T12:36:24.541+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:4257:1214121915' type='NOTIFICATION' group='process start'
level='16' host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14'
pid='8916'>
<txt>MMNL started with pid=16, OS id=8916
</txt>
</msg>
<msg time='2019-08-06T12:36:24.557+03:00' org_id='oracle' comp_id='rdbms'
msg_id='ksu_setup_oracle_base:26401:2787919602' client_id='' type='NOTIFICATION'
group='startup' level='16' host_id='DESKTOP-KB6RJHE'
host_addr='fe80::7446:2a89:80b2:f01d%14' module='' pid='8164'>
<txt>ORACLE_BASE from environment = D:\Oracle\Oradata
</txt>
</msg>
<msg time='2019-08-06T12:36:24.572+03:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:3076:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='DESKTOP-KB6RJHE'
host_addr='fe80::7446:2a89:80b2:f01d%14' module='oradim.exe' pid='3236'>
<txt>alter database mount exclusive
</txt>
</msg>
<msg time='2019-08-06T12:36:28.712+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module=''
pid='9048'>
<txt>Successful mount of redo thread 1, with mount id 1148236296
</txt>
</msg>
<msg time='2019-08-06T12:36:28.712+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module='oradim.exe'
pid='3236'>
<txt>Database mounted in Exclusive Mode
</txt>
</msg>
<msg time='2019-08-06T12:36:28.712+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module='oradim.exe'
pid='3236'>
<txt>Lost write protection disabled
</txt>
</msg>
<msg time='2019-08-06T12:36:28.993+03:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:3147:2802784106' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='DESKTOP-KB6RJHE'
host_addr='fe80::7446:2a89:80b2:f01d%14' module='oradim.exe' pid='3236'>
<txt>Completed: alter database mount exclusive
</txt>
</msg>
<msg time='2019-08-06T12:36:28.993+03:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:3076:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='DESKTOP-KB6RJHE'
host_addr='fe80::7446:2a89:80b2:f01d%14' module='oradim.exe' pid='3236'>
<txt>alter database open
</txt>
</msg>
<msg time='2019-08-06T12:36:29.071+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module=''
pid='9048'>
<txt>Errors in file D:\ORACLE\ORADATA\diag\rdbms\mag\mag\trace\mag_lgwr_9048.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: &apos;D:\ORACLE\ORADATA\MAG\REDO01.LOG&apos;
ORA-27047: unable to read the header block of file
OSD-04006: 񡮩 ReadFile(), ��?? ?? ��࡭森譮箮
O/S-Error: (OS 87) ? ? ???? ??? �棥𭮮
</txt>
</msg>
<msg time='2019-08-06T12:36:29.071+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module=''
pid='9048'>
<txt>Errors in file D:\ORACLE\ORADATA\diag\rdbms\mag\mag\trace\mag_lgwr_9048.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: &apos;D:\ORACLE\ORADATA\MAG\REDO01.LOG&apos;
ORA-27047: unable to read the header block of file
OSD-04006: 񡮩 ReadFile(), ��?? ?? ��࡭森譮箮
O/S-Error: (OS 87) ? ? ???? ??? �棥𭮮
</txt>
</msg>
<msg time='2019-08-06T12:36:29.071+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module='oradim.exe'
pid='3236'>
<txt>Errors in file D:\ORACLE\ORADATA\diag\rdbms\mag\mag\trace\mag_ora_3236.trc:
ORA-00313: ???? ??? ???????? ?????? ???????????? ?????? 1 ????????
ORA-00312: ??????????? ???????? 1 ???????? 1: &apos;D:\ORACLE\ORADATA\MAG\REDO01.LOG&apos;
</txt>
</msg>
<msg time='2019-08-06T12:36:29.103+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module='oradim.exe'
pid='3236'>
<txt>USER (ospid: 3236): terminating the instance due to error 313
</txt>
</msg>
<msg time='2019-08-06T12:36:29.587+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module=''
pid='5688'>
<txt>System state dump requested by (instance=1, osid=3236), summary=[abnormal instance termination].
</txt>
</msg>
<msg time='2019-08-06T12:36:29.587+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module=''
pid='5688'>
<txt>System State dumped to trace file D:\ORACLE\ORADATA\diag\rdbms\mag\mag\trace\mag_diag_5688_20190806123629.trc
</txt>
</msg>
<msg time='2019-08-06T12:36:29.634+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module=''
pid='5688'>
<txt>Dumping diagnostic data in directory=[cdmp_20190806123629], requested by (instance=1, osid=3236), summary=[abnormal instance termination].
</txt>
</msg>
<msg time='2019-08-06T12:36:30.840+03:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DESKTOP-KB6RJHE' host_addr='fe80::7446:2a89:80b2:f01d%14' module='oradim.exe'
pid='3236'>
<txt>Instance terminated by USER, pid = 3236
</txt>
</msg>

Во-первых, это не алерт. И внимательно читать его я не буду. Тут гора упоминаний, как найти алерт.
Во-вторых, рассказывай, чем делал бекап, что было установлено и где, что случилось, и что сделал для восстановления, более подробно. Как я понимаю, сдохла серверная машина и теперь ты пытаешься поднять все на рядом стоящем засраном вирусами и антивирусами десктопе?
Ну и, наконец, D:\ORACLE\ORADATA\MAG\REDO01.LOG восстановил из бекапа?