🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.lang.perl
Article #52240

Polaczenie informacji z dwoch tablic hash

#52240
From: Scottie
Date: Sun, 05 Jun 2011 08:55
63 lines
3329 bytes
Hej!
Utknalem na dobre :-/ Pomozecie?!

Po wykonaniu backupu Oracle'owym narzedziem RMAN, parsuje plik logu i
tworze dwie tablice hash z wieloma wartosciami na klucz:

%channel  #zbiera informacje z logu specyficzne dla kazdego kanalu
 {ch1}
    ->[0]   allocated channel: ch1
	->[1]   channel ch1: SID=596 device type=DISK
	->[2]   channel ch1: starting compressed full datafile backup set
	->[3]   channel ch1: specifying datafile(s) in backup set
 {ch2}
    ->[0]   allocated channel: ch2
	->[1]   channel ch2: SID=15 device type=DISK
	->[2]   channel ch2: starting compressed full datafile backup set
	->[3]   channel ch2: specifying datafile(s) in backup set

%channel_files #zbiera informacje o plikach zbackupowanych przez dany
kanal
 {ch1}
    ->[0]   input datafile file number=00014 name=/foo/oradata/foo/foo-
data04.dbf
    ->[1]   input datafile file number=00019 name=/foo/oradata/foo/foo-
data05.dbf
 {ch2}
    ->[0]   input datafile file number=00013 name=/foo/oradata/foo/foo-
index03.dbf
    ->[1]   input datafile file number=00012 name=/foo/oradata/foo/foo-
data03.dbf


Chcialbym powiazac informacje z tych dwoch tablic, aby output byl
taki:
============================

Files for channel 'ch1':
  Channel name    Channel type   File Number      File Name
  --------------- -------------- ----------------
---------------------------
  ch1             DISK           00014            /foo/oradata/foo/foo-
data04.dbf
  ch1             DISK           00019            /foo/oradata/foo/foo-
data05.dbf

Files for channel 'ch2':
  Channel name    Channel type   File Number      File Name
  --------------- -------------- ----------------
---------------------------
  ch2             DISK           00013            /foo/oradata/foo/foo-
index03.dbf
  ch2             DISK           00012            /foo/oradata/foo/foo-
data03.dbf

============================

Kombinuje na prawo i lewo, ale w ogole nie wiem jak sie za to zabrac.
Pracuje jako DBA i ten problem wykracza poza moja znajomosc Perla.
Bylbym wdzieczny za udzielona pomoc, abym mogl pojsc dalej.

Pozdrawiam,
--
Scottie
Technical Details
Message-ID: <8f691faa-4f4a-43af-b3b8-5f2d3916fcb1@k17g2000vbn.googlegroups.com>
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!plix.pl!newsfeed1.plix.pl!goblin1!goblin.stu.neva.ru!postnews.google.com!k17g2000vbn.googlegroups.com!not-for-mail

Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!plix.pl!newsfeed1.plix.pl!goblin1!goblin.stu.neva.ru!postnews.google.com!k17g2000vbn.googlegroups.com!not-for-mail
From: Scottie <scottie383@gmail.com>
Newsgroups: pl.comp.lang.perl
Subject: Polaczenie informacji z dwoch tablic hash
Date: Sun, 5 Jun 2011 01:55:36 -0700 (PDT)
Organization: http://groups.google.com
Lines: 63
Message-ID: <8f691faa-4f4a-43af-b3b8-5f2d3916fcb1@k17g2000vbn.googlegroups.com>
NNTP-Posting-Host: 95.41.247.113
Mime-Version: 1.0
X-Trace: posting.google.com 1307264137 6913 127.0.0.1 (5 Jun 2011 08:55:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 5 Jun 2011 08:55:37 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k17g2000vbn.googlegroups.com; posting-host=95.41.247.113; posting-account=ELxU3goAAAC0N9FXVO0mEF4trg5o1BZ0
User-Agent: G2/1.0
X-Google-Web-Client: true
X-Google-Header-Order: ASELCHRU
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.204 Safari/534.16,gzip(gfe)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit