Oracle8.1.7.3(.4) for Linux.
Были сделаны бэкапы:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
RMAN> list backupset;
RMAN- 03022 : compiling command: list
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
98 1 496856504 0 496856481 2 16 . 06 . 03
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
101 1 1 AVAILABLE 16 . 06 . 03 /oracle8i/dbs/02epqrd1_1_1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
1 /oracle8i/oradata/epsdb01/sys1.ora 0 Full 23727 16 . 06 . 03
2 /oracle8i/oradata/epsdb01/rbtabsp1.ora 0 Full 23727 16 . 06 . 03
3 /oracle8i/oradata/epsdb01/users01.ora 0 Full 23727 16 . 06 . 03
4 /oracle8i/oradata/epsdb01/indx01.ora 0 Full 23727 16 . 06 . 03
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
99 2 496859115 0 496859111 3 16 . 06 . 03
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
102 1 1 AVAILABLE 16 . 06 . 03 /oracle8i/dbs/03epqtv7_1_1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
1 /oracle8i/oradata/epsdb01/sys1.ora 0 Full 23743 16 . 06 . 03
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
100 3 496860713 0 496860703 4 16 . 06 . 03
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
103 1 1 AVAILABLE 16 . 06 . 03 /oracle8i/dbs/04epqvgv_1_1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
2 /oracle8i/oradata/epsdb01/rbtabsp1.ora 0 Full 23746 16 . 06 . 03
3 /oracle8i/oradata/epsdb01/users01.ora 0 Full 23746 16 . 06 . 03
4 /oracle8i/oradata/epsdb01/indx01.ora 0 Full 23746 16 . 06 . 03
Хочу удалить backupset. Для этого нужно сделать выделение канала так:
allocate channel for delete или allocate channel for maintenance. Однако не получается:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
RMAN> run {
2 > allocate channel for delete type disk;
RMAN- 00571 : ===========================================================
RMAN- 00569 : =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN- 00571 : ===========================================================
RMAN- 00558 : error encountered while parsing input commands
RMAN- 01005 : syntax error: found "for" : expecting one of: "channel_id, double-quoted-string, identifier, single-quoted-string"
RMAN- 01007 : at line 2 column 18 file: standard input
RMAN> run {
2 > allocate channel for maintenance type disk;
RMAN- 00571 : ===========================================================
RMAN- 00569 : =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN- 00571 : ===========================================================
RMAN- 00558 : error encountered while parsing input commands
RMAN- 01005 : syntax error: found "for" : expecting one of: "channel_id, double-quoted-string, identifier, single-quoted-string"
RMAN- 01007 : at line 2 column 18 file: standard input
В чём грабли? Причём под Windows я подобное делал - всё получалось.
