|
|
|
при попытке дуплицировать базы rman выдает ошибку ora 19870
|
|||
|---|---|---|---|
|
#18+
Подключение к standby базе проходит нормально, но дуплицирование не происходит ,хотя все каталоги на двух серверах имеются. RMAN> connect auxiliary sys@teststan auxiliary database Password: connected to auxiliary database: TEST (not mounted) RMAN> duplicate target database for standby nofilenamecheck dorecover; Starting Duplicate Db at 06-MAY-17 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=12 device type=DISK current log archived contents of Memory Script: { set until scn 1364886; restore clone standby controlfile; } executing Memory Script executing command: SET until clause Starting restore at 06-MAY-17 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: reading from backup piece E:\DATA\BACKUP\0AS3JGAK channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece E:\DATA\BACKUP\0AS3JGAK ORA-19505: failed to identify file "E:\DATA\BACKUP\0AS3JGAK" ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 3) ╤шёЄхьх эх єфрхЄё эрщЄш єърчрээ√щ яєЄ№. failover to previous backup channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: reading from backup piece E:\DATA\BACKUP\STANDBYCONTROL.CTL channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece E:\DATA\BACKUP\STANDBYCONTROL.CTL ORA-19505: failed to identify file "E:\DATA\BACKUP\STANDBYCONTROL.CTL" ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 3) ╤шёЄхьх эх єфрхЄё эрщЄш єърчрээ√щ яєЄ№. failover to previous backup channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: reading from backup piece E:\APP\ORACLE\DATA\BACKUP\04S3IBTA channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece E:\APP\ORACLE\DATA\BACKUP\04S3IBTA ORA-19505: failed to identify file "E:\APP\ORACLE\DATA\BACKUP\04S3IBTA" ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) ═х єфрхЄё эрщЄш єърчрээ√щ Їрщы. failover to previous backup channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: reading from backup piece E:\APP\ORACLE\DATA\BACKUP\STANDBYCONTROL.CTL channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece E:\APP\ORACLE\DATA\BACKUP\STANDBYCONTROL.CTL ORA-19608: E:\APP\ORACLE\DATA\BACKUP\STANDBYCONTROL.CTL is not a backup piece ORA-19837: invalid blocksize 0 in backup piece header failover to previous backup RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 05/06/2017 22:30:32 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-06026: some targets not found - aborting restore RMAN-06024: no backup or copy of the control file found to restore RMAN> ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.05.2017, 22:31 |
|
||
|
при попытке дуплицировать базы rman выдает ошибку ora 19870
|
|||
|---|---|---|---|
|
#18+
Судя по всему, версия до 11.2? Собственно, в любом случае перед восстановлением БД для стендбая правилом хорошего тона (ну, или я консерватор) является сделать бэкап контролфайла FOR STANDBY, а после этого переключение архивлогов и их бэкап PS. не увидел сразу, ведь он у тебя и просит "E:\DATA\BACKUP\STANDBYCONTROL.CTL" (видимо, одна из старых копий), только не находит ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 09.05.2017, 13:09 |
|
||
|
|

start [/forum/topic.php?fid=52&fpage=164&tid=1885975]: |
0ms |
get settings: |
10ms |
get forum list: |
16ms |
check forum access: |
5ms |
check topic access: |
5ms |
track hit: |
45ms |
get topic data: |
10ms |
get forum data: |
4ms |
get page messages: |
35ms |
get tp. blocked users: |
1ms |
| others: | 210ms |
| total: | 341ms |

| 0 / 0 |
