Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / July 2003

Tip: Looking for answers? Try searching our database.

Applying Logical Logs for a restore ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jack A - 31 Jul 2003 20:44 GMT
I'm an informix newbie. So my question is very basic.

After I have backed up the logical logs how is the process of
reapplying them to the database to get it current done ? The logs have
been backed up using ontape -a

Thanks,
Jack
Art S. Kagel - 31 Jul 2003 22:09 GMT
> I'm an informix newbie. So my question is very basic.
>
> After I have backed up the logical logs how is the process of reapplying
> them to the database to get it current done ? The logs have been backed
> up using ontape -a

You would only have to reapply logical logs as part of restoring an
archive, and so, it is done as part of the physical/logical restore with
ontape -r.

Art S. Kagel
Davis Kwong - 01 Aug 2003 00:01 GMT
Hi

After backing up the logical logs via "ontape -a", you can reapply those
logs in one of 2 ways:
(1) "ontape -r" which will restore the physical backups (level 0, 1, 2),
then it will prompt you to restore the logical logs.
(2) "ontape -p" which will only restore the physical backup, then "ontape
-l" which will restore the logical logs.

thanks. Davis.

                                                                                                                                     
                     hrehal@yahoo.com                                                                                                
                     (Jack A)                 To:       informix-list@iiug.org                                                        
                     Sent by:                 cc:                                                                                    
                     owner-informix-li        Subject:  Applying Logical Logs for a restore ?                                        
                     st@iiug.org                                                                                                      
                                                                                                                                     
                                                                                                                                     
                     07/31/2003 12:44                                                                                                
                     PM                                                                                                              
                     Please respond to                                                                                                
                     hrehal                                                                                                          
                                                                                                                                     

I'm an informix newbie. So my question is very basic.

After I have backed up the logical logs how is the process of
reapplying them to the database to get it current done ? The logs have
been backed up using ontape -a

Thanks,
Jack

sending to informix-list
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.