OK, this is a version trying to output the commands in the order you described. Since you only gave an example but did not give any specific rules as to how to get to the result in your example, I based the code on the idea that the DB sequence break must occur after each occurrence of a record containing "exch remove". 

use strict;
use warnings;

my @db= qw /db1 db2/;
my @commands =( "HPRMCLI exch create -s EXCHDAGNODE1 ",
 "HPRMCLI exch mount  -h RMEBackupSvr",
 "HPRMCLI exch validate -level Log",
 "HPRMCLI exch unmount ",
 "HPRMCLI exch remove ",
 "HPRMCLI exch create -s EXCHDAGNODE2  -nc",
 "HPRMCLI exch mount   -h RMEBackupSvr",
 "HPRMCLI exch validate  -level Full",
 "HPRMCLI exch unmount ",
 "HPRMCLI exch remove ");
 
my @out_com;
 
for (@commands) {
      push @out_com, $_;
      if (/exch remove/) {
          for my $database (@db) {
              print map {"$_ -mdb $database \n"} @out_com;
          }
          @out_com = ();
      }
}

[download]
This gives the following output: 
$ perl commands.pl
HPRMCLI exch create -s EXCHDAGNODE1  -mdb db1
HPRMCLI exch mount  -h RMEBackupSvr -mdb db1
HPRMCLI exch validate -level Log -mdb db1
HPRMCLI exch unmount  -mdb db1
HPRMCLI exch remove  -mdb db1
HPRMCLI exch create -s EXCHDAGNODE1  -mdb db2
HPRMCLI exch mount  -h RMEBackupSvr -mdb db2
HPRMCLI exch validate -level Log -mdb db2
HPRMCLI exch unmount  -mdb db2
HPRMCLI exch remove  -mdb db2
HPRMCLI exch create -s EXCHDAGNODE2  -nc -mdb db1
HPRMCLI exch mount   -h RMEBackupSvr -mdb db1
HPRMCLI exch validate  -level Full -mdb db1
HPRMCLI exch unmount  -mdb db1
HPRMCLI exch remove  -mdb db1
HPRMCLI exch create -s EXCHDAGNODE2  -nc -mdb db2
HPRMCLI exch mount   -h RMEBackupSvr -mdb db2
HPRMCLI exch validate  -level Full -mdb db2
HPRMCLI exch unmount  -mdb db2
HPRMCLI exch remove  -mdb db2

[download]
which I think is what you are looking for. I kept the @out_com array, but this time only as a temporary array to store and group the lines needing to go together between the db breaks.

In reply to Re: Perl array output sorting by Laurent_R
in thread Perl array output sorting by dvinay

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.