Export the databases from secondary

Dear Group IDS, I used HDR solution from Informix which means that I have primary und seconday servers concept. my quesion: I want to export the databases that i have to sicher it later on tape drive. Can i do the export from secondary? to make sure that the primary 24 hours online. if i cannot do that, then what shall do to make the export of data and the database still online which is mean without downtime. Regards Muthana AL-Temimi M.Sc. Informations- und Kommunikations-Systeme Technische Universitaet Hamburg Harburg -Rechenzentrum- Schwarzenbergstr. 95 (E) D-21073 Hamburg Tel.: +49.40.42878.2338 Fax.: +49.40.42793.5160 E-Mail: m.al@tu-harburg.de http://www.tu-harburg.de/rzt

You can use the Informix ontape utility on the primary server to archive it while the server is fully online. No downtime needed. You should also be archiving the logical logs using ontape so you can restore the instance to the point of failure as closely as possible on the case of a catastrophic failure. Look at the Backup and Restore manual for details. Art On Nov 9, 2010 5:50 AM, "Muthana.AL-...." < Muthana.AL-Temimi@tu-harburg.hamburg.de> wrote: > Dear Group IDS, > > I used HDR solution from Informix which means that I have primary und > seconday servers concept. > my quesion: I want to export the databases that i have to sicher it > later on tape drive. > > Can i do the export from secondary? to make sure that the primary 24 > hours online. > if i cannot do that, then what shall do to make the export of data and > the database still online which is mean without downtime. > > Regards > > Muthana AL-Temimi > > M.Sc. Informations- und Kommunikations-Systeme > > Technische Universitaet Hamburg Harburg > > -Rechenzentrum- > > Schwarzenbergstr. 95 (E) > > D-21073 Hamburg > > Tel.: +49.40.42878.2338 > > Fax.: +49.40.42793.5160 > > E-Mail: m.al@tu-harburg.de > > http://www.tu-harburg.de/rzt > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --0016e640d506cdadb404949cac28

Yes, you can do that. You can do dbexport on HDR secondary but sometimes export taken on that way (when HDR is still active) may have different number of rows for some tables in database.sql file, and real .unl file which is in database.exp folder ... To resolve this, you must edit database.sql in .exp folder and make this number identically, or before a couple of days, I start using this strategy on HDR secondary server for dbexport: 1. Temporary stop HDR: onmode -wf STOP_APPLY=1 onmode -wf USELASTCOMMITTED=ALL 2. Do dbexport: dbexport my_database 3. Continue HDR: onmode -wf STOP_APPLY=0 onmode -wf USELASTCOMMITTED=NONE I don't quite sure if STOP_APPLY really temporary stop HDR - because I see logical log on secondary growing even after this command, but my dbexport is OK (accidentally or not). On 09.11.2010 11:50, Muthana.AL-.... wrote: > Dear Group IDS, > > I used HDR solution from Informix which means that I have primary und > seconday servers concept. > my quesion: I want to export the databases that i have to sicher it > later on tape drive. > > Can i do the export from secondary? to make sure that the primary 24 > hours online. > if i cannot do that, then what shall do to make the export of data and > the database still online which is mean without downtime. > > Regards > > Muthana AL-Temimi > > M.Sc. Informations- und Kommunikations-Systeme > > Technische Universitaet Hamburg Harburg > > -Rechenzentrum- > > Schwarzenbergstr. 95 (E) > > D-21073 Hamburg > > Tel.: +49.40.42878.2338 > > Fax.: +49.40.42793.5160 > > E-Mail: m.al@tu-harburg.de > > http://www.tu-harburg.de/rzt > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Ivan Zaviç System& DB Administrator Mobile:+381-64-846-99-08 mail: ivan.zavis@mi-system.co.rs _________________________________________________________ M&I SYSTEMS CO. Cirila i Metodija 13/a, 21000 Novi Sad, Serbia Tel/Fax: +381-(0)21-68-98-600 Mail: info@mi-system.co.rs, URL: http://www.mi-system.co.rs