|
Действия ...
Новые сообщения [новые:0]
Дайджест
Горячие темы
Избранное [новые:0]
Форумы
Пользователи
Статистика
Статистика нагрузки
Мод. лог
Поиск
|
|
25.02.2003, 15:53
|
|||
|---|---|---|---|
|
|||
Read-only tablespace backup scripts & recovery catalog |
|||
|
#18+
Kak lutshe delatj backup skript dlja read-only tablespaces ? Ja izpoljzovaju RMAN s catalog DB i hochetsja sdelatj skript, katorij atdeljno delal read-only (RO) tablespaces (TS) backup. Kazhduju nedjelju pojavljajutsja noviji i noviji RO TS, potomu script dolzhen sam znatj, katoriji TS nado trogatj, katoriju bolshe njenado. Shto pasovetuitje? (pisatj rukami tablespace_name njesaberajusj) :)) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
25.02.2003, 18:43
|
|||
|---|---|---|---|
|
|||
Read-only tablespace backup scripts & recovery catalog |
|||
|
#18+
Aizej uz varoni paka4ajies, pasedi pirtinja , iedzer alinju un atbilde pati atnaks ... Ja tev veel kadas probzas ar oracle DBA dro6i raksti... ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
25.02.2003, 18:58
|
|||
|---|---|---|---|
Read-only tablespace backup scripts & recovery catalog |
|||
|
#18+
see : http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96521/tspaces.htm#6884 tam chetko napisano: After making the tablespace read-only, it is advisable to back it up immediately. As long as the tablespace remains read-only, no further backups of the tablespace are necessary since no changes can be made to it. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
26.02.2003, 10:45
|
|||
|---|---|---|---|
|
|||
Read-only tablespace backup scripts & recovery catalog |
|||
|
#18+
ShgGena - ja harasho znaju, shto 'it is advisable to back it up immediately' no TS delajutsja read-only v aplikaciji i jeslji ja budu smotretj, kogda novaja TS stanjet RO i budu delatj back-up v ruchnuju, eto zaimjot mnje vsjo vremja. Rech njeidjot o 1 ilji 2 TS ... ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
26.02.2003, 18:27
|
|||
|---|---|---|---|
Read-only tablespace backup scripts & recovery catalog |
|||
|
#18+
Metod ne vpolne correktniy no dopustimiy: dliy tablicy sys.ts$ kak sys sozday trigger --> after insert / update i analiziruy izmenenie polya: if :new.ts.online$ <> :old.ts.online$ and :new.ts.online$ = 4 then -- start backup dlya dannoy ts -- (4 - eto kod dlya READ_ONLY TABLESPACE) end if; i, k slovu, poskolku "Rech njeidjot o 1 ilji 2 TS" to kto-to ili chto-to v lubom sluche vidayet komandu: alter tablespace ...; pochemu ne privyazat kod zapuska backup k etoy komande? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
26.02.2003, 18:50
|
|||
|---|---|---|---|
|
|||
Read-only tablespace backup scripts & recovery catalog |
|||
|
#18+
Alter tablespace delajetsja v formah. Delo v tom, shto nu ochenj hochetsja imetj odinakovij interfeiss backup procedur vseh dannih. Teper OEM kontroljirujet rabotu backup skriptov katoriji rabotajut s rman i legato networker. Eto dajot vazmozhnostj harasho kontroljirovatj status vseh backup'ov, zapuskatj v ruchnuju ... No ja podumaju o triggere na ts$ Spasibo za sovet! > i, k slovu, poskolku "Rech njeidjot o 1 ilji 2 TS" to kto-to ili chto-to v lubom > sluche vidayet komandu: alter tablespace ...; > pochemu ne privyazat kod zapuska backup k etoy komande? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
start [/forum/topic.php?fid=52&tablet=1&tid=1991693]: |
0ms |
get settings: |
10ms |
get forum list: |
19ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
191ms |
get topic data: |
11ms |
get forum data: |
3ms |
get page messages: |
46ms |
get tp. blocked users: |
1ms |
| others: | 241ms |
| total: | 530ms |
| 0 / 0 |
