Looking for ontape -p/-r script for multiple resto

OS: AIX IDS: 7.31 Does anyone have a script (ksh or perl), that will perform a multiple backup file automated restore? I have 70 3GB backup files, that I need to restore on another server. The script needs to read each file and change the backup link each time the ontape command request for the next file. It also needs to bypass the log backup and other restore questions, except for the initial need to restore from level 0 question. Thanks, ******************************************************************************** ********** Ernie Knox Sr. Technologist, I&TG - Database Management Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com> Corp. Cell: 224-465-0553 Corp. Text: 2244650553@txt.att.net Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team: InformixDBA@searshc.com<mailto:InformixDBA@searshc.com> Informix Primary: INFORMIXDBAPrimaryPager@searshc.com<mailto:INFORMIXDBAPrimaryPager@searshc.com> Informix Secondary: INFORMIXDBASecondaryPager@searshc.com<mailto:INFORMIXDBASecondaryPager@searshc.c om> MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team: MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com> MySQL Primary: MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.com> MySQL Secondary: MYSQLDBASecondaryPager@searshc.com<mailto:MYSQLDBASecondaryPager@searshc.com> For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management#Dat abaseManagement<http://wiki.intra.sears.com/confluence/display/TechStrag/Databas e+Management> For creating SUCCEED and/or CCMDB request, use the link below: https://succeed.intra.searshc.com<https://succeed.intra.searshc.com/>; Have I provided a WOW member experience today? Send a Members' First Recognition to this Associate<http://searslabs.intra.searshc.com/irlabs/recognition/>; Nominate this Associate for a Technology Excellence Award<http://support.searshc.com/it/Home/TechExcellenceAwards/tabid/4271/Default .aspx> My Area: " Yes we can make a Change! " " IF you can think it, you can do it! " " Sometimes to secure the future, you have to let go of the past! " " IT'S always a great day to watch Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends. I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual success. I will protect and value integrity. I will admit and quickly correct my mistakes. I will be a self-starter. I will be a caring person. I will be a good listener with an open mind. I will continue to grow and learn. I will facilitate and celebrate the success of others. " ******************************************************************************** ********** This message, including any attachments, is the property of Sears Holdings Corporation and/or one of its subsidiaries. It is confidential and may contain proprietary or legally privileged information. If you are not the intended recipient, please delete it without reading the contents. Thank you.

Easy to code using Expect Ernie. It's like 5 lines of script. Art On Jun 9, 2015 6:40 PM, "Knox, Ernest" <Ernest.Knox@searshc.com> wrote: > OS: AIX > IDS: 7.31 > > Does anyone have a script (ksh or perl), that will perform a multiple > backup > file automated restore? > > I have 70 3GB backup files, that I need to restore on another server. The > script needs to read each file and change the backup link each time the > ontape> command request for the next file. > > It also needs to bypass the log backup and other restore questions, except > for > the initial need to restore from level 0 question. > > Thanks, > > > ******************************************************************************** ********** > Ernie Knox > Sr. Technologist, I&TG - Database Management > Sears Holdings Management Corp > 3333 Beverly Rd. > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com> > Corp. Cell: 224-465-0553 > Corp. Text: 2244650553@txt.att.net > Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team: > InformixDBA@searshc.com<mailto:InformixDBA@searshc.com> > Informix Primary: > INFORMIXDBAPrimaryPager@searshc.com<mailto: > INFORMIXDBAPrimaryPager@searshc.com> > Informix Secondary: > INFORMIXDBASecondaryPager@searshc.com<mailto: > INFORMIXDBASecondaryPager@searshc.com> > MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team: > MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com> > MySQL Primary: > MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.com> > MySQL Secondary: > MYSQLDBASecondaryPager@searshc.com<mailto: > MYSQLDBASecondaryPager@searshc.com> > > For more information, view our DBA Wiki page link below: > > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management#Dat abaseManagement > < > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management > > > > For creating SUCCEED and/or CCMDB request, use the link below: > https://succeed.intra.searshc.com<https://succeed.intra.searshc.com/>; > > Have I provided a WOW member experience today? > Send a Members' First Recognition to this > Associate<http://searslabs.intra.searshc.com/irlabs/recognition/>; > Nominate this Associate for a Technology Excellence > Award< > http://support.searshc.com/it/Home/TechExcellenceAwards/tabid/4271/Default.aspx > > > > My Area: > " Yes we can make a Change! " > " IF you can think it, you can do it! " > " Sometimes to secure the future, you have to let go of the past! " > " IT'S always a great day to watch Sports: FOOTBALL " > GSU > MISSION: > " The focus of my life begins at home with family, loved ones, and > friends. I > want to use my resources to create a > secure environment that fosters love, learning, laughter, and mutual > success. > I will protect and value integrity. I > will admit and quickly correct my mistakes. I will be a self-starter. I > will > be a caring person. I will be a good listener > with an open mind. I will continue to grow and learn. I will facilitate and > celebrate the success of others. " > > > ******************************************************************************** ********** > > This message, including any attachments, is the property of Sears Holdings > Corporation and/or one of its subsidiaries. It is confidential and may > contain > proprietary or legally privileged information. If you are not the intended > recipient, please delete it without reading the contents. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1140727a26d02c05181da7e7

Do you have any examples, that do not utilize the spawn command? Thanks, ***************************************************************************= *************** Ernie Knox Sr. Technologist, I&TG - Database Management Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Corp. Cell: 224-465-0553=A0 Corp. Text: 2244650553@txt.att.net Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement For creating SUCCEED and/or CCMDB request, use the link below: https://succeed.intra.searshc.com Have I provided a WOW member experience today? Send a Members' First Recognition to this Associate Nominate this Associate for a Technology Excellence Award My Area: " Yes we can make a Change! " " IF you can think it, you can do it! " " Sometimes to secure the future, you have to let go of the past! " " IT'S always a great day to watch=A0Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends.= =A0 I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual succes= s.=A0 I will protect and value integrity.=A0 I will admit and quickly correct my mistakes.=A0 I will be a self-starter.=A0= I will be a caring person.=A0 I will be a good listener with an open mind.=A0 I will continue to grow and learn.=A0 I will facilita= te and celebrate the success of others. " ***************************************************************************= *************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art K= agel Sent: Tuesday, June 09, 2015 6:55 PM To: ids@iiug.org Subject: Re: Looking for ontape -p/-r script for multip.... [35248] Easy to code using Expect Ernie. It's like 5 lines of script.=20 Art On Jun 9, 2015 6:40 PM, "Knox, Ernest" <Ernest.Knox@searshc.com> wrote:=20 > OS: AIX > IDS: 7.31 >=20 > Does anyone have a script (ksh or perl), that will perform a multiple=20 > backup file automated restore? >=20 > I have 70 3GB backup files, that I need to restore on another server.=20 > The script needs to read each file and change the backup link each=20 > time the ontape command request for the next file. >=20 > It also needs to bypass the log backup and other restore questions,=20 > except for the initial need to restore from level 0 question. >=20 > Thanks, >=20 >=20 >=20 ***************************************************************************= ***************=20 > Ernie Knox > Sr. Technologist, I&TG - Database Management Sears Holdings Management=20 > Corp > 3333 Beverly Rd.=20 > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com> > Corp. Cell: 224-465-0553 > Corp. Text: 2244650553@txt.att.net > Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team:= =20 > InformixDBA@searshc.com<mailto:InformixDBA@searshc.com> > Informix Primary:=20 > INFORMIXDBAPrimaryPager@searshc.com<mailto:=20 > INFORMIXDBAPrimaryPager@searshc.com> > Informix Secondary:=20 > INFORMIXDBASecondaryPager@searshc.com<mailto:=20 > INFORMIXDBASecondaryPager@searshc.com> > MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team= :=20 > MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com> > MySQL Primary:=20 > MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.c > om> > MySQL Secondary:=20 > MYSQLDBASecondaryPager@searshc.com<mailto:=20 > MYSQLDBASecondaryPager@searshc.com> >=20 > For more information, view our DBA Wiki page link below:=20 >=20 >=20 >=20 http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement=20 > < > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Mana > gement > >=20 >=20 > For creating SUCCEED and/or CCMDB request, use the link below:=20 > https://succeed.intra.searshc.com<https://succeed.intra.searshc.com/>; >=20 > Have I provided a WOW member experience today?=20 > Send a Members' First Recognition to this=20 > Associate<http://searslabs.intra.searshc.com/irlabs/recognition/>; > Nominate this Associate for a Technology Excellence Award< >=20 http://support.searshc.com/it/Home/TechExcellenceAwards/tabid/4271/Default.= aspx=20 > >=20 >=20 > My Area:=20 > " Yes we can make a Change! "=20 > " IF you can think it, you can do it! "=20 > " Sometimes to secure the future, you have to let go of the past! "=20 > " IT'S always a great day to watch Sports: FOOTBALL "=20 > GSU > MISSION:=20 > " The focus of my life begins at home with family, loved ones, and=20 > friends. I want to use my resources to create a secure environment=20 > that fosters love, learning, laughter, and mutual success. > I will protect and value integrity. I will admit and quickly correct=20 > my mistakes. I will be a self-starter. I will be a caring person. I=20 > will be a good listener with an open mind. I will continue to grow and=20 > learn. I will facilitate and celebrate the success of others. " >=20 >=20 >=20 ***************************************************************************= ***************=20 >=20 > This message, including any attachments, is the property of Sears=20 > Holdings Corporation and/or one of its subsidiaries. It is=20 > confidential and may contain proprietary or legally privileged=20 > information. If you are not the intended recipient, please delete it=20 > without reading the contents. Thank you. >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --001a1140727a26d02c05181da7e7=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.