|
|
|
standby 8.1.6
|
|||
|---|---|---|---|
|
#18+
SVRMGR> connect sys/a2@craft AS SYSDBA; Connected. SVRMGR> startup nomount pfile=d:\oracle\admin\craft\pfile\initcraft.ora ORACLE instance started. Total System Global Area 36996364 bytes Fixed Size 70924 bytes Variable Size 20008960 bytes Database Buffers 16777216 bytes Redo Buffers 139264 bytes SVRMGR> ALTER DATABASE MOUNT STANDBY DATABASE; Statement processed. SVRMGR> RECOVER MANAGED STANDBY DATABASE; {тут я перевожу в другой сессии standby в read only и получаю на свою голову:} ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'D:\ORACLE\ORADATA\CRAFT\SYSTEM01.DBF' ORA-16037: user requested cancel of sustained recovery operation SVRMGR> содержимое лога такое: Wed Oct 16 17:03:12 2002 alter database mount standby database Wed Oct 16 17:03:16 2002 Successful mount of redo thread 1, with mount id 1739026132. Wed Oct 16 17:03:16 2002 Standby Database mounted. Completed: alter database mount standby database Wed Oct 16 17:03:34 2002 ALTER DATABASE RECOVER managed standby database Wed Oct 16 17:03:34 2002 Media Recovery Start: Managed Standby Recovery Media Recovery Log Media Recovery Waiting for thread 1 seq# 120 Wed Oct 16 17:09:37 2002 ALTER DATABASE RECOVER managed standby database cancel Wed Oct 16 17:09:37 2002 Sustained Standby Recovery Cancelled Completed: ALTER DATABASE RECOVER managed standby database Wed Oct 16 17:09:49 2002 ORA-1547 signalled during: ALTER DATABASE RECOVER managed standby database ... Wed Oct 16 17:09:49 2002 ALTER DATABASE RECOVER CANCEL ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL... 120 seq подкачался с основной базы и находится в каталоге передачи логов. Так что ему еще надо? Чего-то не понимаю... ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 16.10.2002, 18:31 |
|
||
|
standby 8.1.6
|
|||
|---|---|---|---|
|
#18+
Oracle8i Standby Database Concepts and Administration 5 Standby Database Scenarios ........... Identify and apply the logs in the gap sequence. On the standby database, enable managed recovery by issuing the following statement: SQL> RECOVER MANAGED STANDBY DATABASE; You may get the following error messages when you try to enable managed recovery: ORA-00308: cannot open archived log 'standby1' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/vobs/oracle/dbs/stdby/tbs_1.f' If you get the ORA-00308 error, cancel recovery by issuing the following statement: SQL> CANCEL These error messages are issued when one or more logs in the gap sequence have not been successfully applied. If you receive these errors, repeat steps 8 and 9. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 17.10.2002, 09:56 |
|
||
|
standby 8.1.6
|
|||
|---|---|---|---|
|
#18+
а какие steps 8 and 9 ? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 17.10.2002, 10:11 |
|
||
|
standby 8.1.6
|
|||
|---|---|---|---|
|
#18+
Номерочки просто пропали.... 8. Identify and apply the logs in the gap sequence. 9. On the standby database, enable managed recovery by issuing the following statement: SQL> RECOVER MANAGED STANDBY DATABASE; У тебя нет доки? http://tahiti.oracle.com ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 17.10.2002, 13:17 |
|
||
|
standby 8.1.6
|
|||
|---|---|---|---|
|
#18+
У меня пересылка архивных файлов идет нормально. При переключении они появляются в основном архивном каталоге и затем - в каталоге standby базы. Т.е. seq 120 уже есть, но он почему-то не выбирается. Я так понимаю, в файле ALERT после строк Media Recovery Start: Managed Standby Recovery Media Recovery Log Media Recovery Waiting for thread 1 seq# 120 должно быть что-то типа applying seq120 successfull(ну, примерно, в таком роде). А у меня в файле ALERT похожего ничего нет, хотя seq 120 есть. :( ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 17.10.2002, 14:44 |
|
||
|
standby 8.1.6
|
|||
|---|---|---|---|
|
#18+
Есть два пути: 1. RECOVER AUTOMATIC STANDBY DATABASE; 2. перенести проблемный таблеспейс с рабочего сервера на стендбай. Процесс переноса описан очень хорошо в Oracle8i Standby Database Concepts and Administration Release 2 (8.1.6) Part Number A76995-01 5 Standby Database Scenarios ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 18.10.2002, 09:55 |
|
||
|
|
start [/forum/topic.php?fid=52&msg=32059232&tid=1991396]: |
0ms |
get settings: |
7ms |
get forum list: |
14ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
80ms |
get topic data: |
11ms |
get forum data: |
3ms |
get page messages: |
51ms |
get tp. blocked users: |
1ms |
| others: | 233ms |
| total: | 408ms |
| 0 / 0 |
