|
|
|
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, 15:53 |
|
||
|
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:43 |
|
||
|
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. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.02.2003, 18:58 |
|
||
|
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, 10:45 |
|
||
|
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:27 |
|
||
|
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? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.02.2003, 18:50 |
|
||
|
|
start [/forum/topic.php?fid=52&msg=32111710&tid=1991693]: |
0ms |
get settings: |
6ms |
get forum list: |
15ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
154ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
50ms |
get tp. blocked users: |
2ms |
| others: | 207ms |
| total: | 452ms |
| 0 / 0 |
