Re: DB recovery using ontape
Hi Kenji,
Are you sure that the database you are testing with has logging
turned on? If not, no log records will be generated ( except for
ddl ), and it will appear the logical log roll forward has failed,
when in fact there was nothing to roll forward.
Did you get any messages when you answered yes to roll forward the
logs during the restore?
Mike Ballentine
--------------------------( Forwarded letter 1 follows )---------------------
Date: Wednesday, 20 August 1997 4:09pm
From: kenji@alcatraz.net
Subject: Re: DB recovery using ontape
Date: Wed, 20 Aug 1997 14:36:43 -0500
Reply-To: kenji@alcatraz.net
Organization: VE Information Systems, Inc.
Sender: informix-list-owner@rmy.emory.edu
To: informix-list@rmy.emory.edu
X-Informix-List-Id: <news.41881>
I did say "No" to that but I still didn't get the update. Do I need to
do something else ?
Kenji
Mark D. Stock wrote:
} Kenji Hino wrote:
} >
} > I am new to the utility "ontape". I hope somebody can explain to me
}
} > what's going on.
} > To get familiar with the tool, I created a dataspace and put data in
}
} > it
} > and created a level-0 archive using "ontape -s". Then, I updated one
}
} > of
} > the record and created a logical log archive using "ontape -a". For
} > the
} > testing purpose, I used UNIX files (not devices) to specify the
} > destination for both system and logincal archive tape devices.
} > When I try to do full recovery using those two files, I get the
} system
} > archive recovered fine but I can't get the logical log to
} rollforward
} > which means that I can't get any update after I created the system
} > archive. Does anybody know what I am doing wrong ? During the
} > recovery,
}
} During the restore it asks if you want to backup the current logs. You
}
} MUST say NO. Otherwise you will overwrite your previous backup, and
} have no logs to restore.
}
} Hope that helps,
} --
} Mark.
}
} +----
} -----------------------------------------------------+-----------+
} |Mark D. Stock - Informix SA http://www.informix.com |////////
} /|
} |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// /
} //|
} | +-----------------------------------+//// /
} ///|
} | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// /
} ////|
} | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// /
} /////|
} |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/
} ////////|
} +--------
} -------------+-----------------------------------+-----------+