<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="Function: replay - Virtuoso Functions Guide" />
<meta name="dc.subject" content="Function: replay - Virtuoso Functions Guide" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="functions.html" title="Chapter Contents" />
<link rel="prev" href="appendixa.html" title="Appendix" />
<link rel="next" href="functions.html#.html" title="" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>Function: replay - Virtuoso Functions Guide</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="fn_replay" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>22. Virtuoso Functions Guide - replay</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_backup_context_clear.html" title="backup_context_clear">Prev</a> | <a class="link" href="functions.html#bpel" title="BPEL APIs">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div>
<a class="selected" href="functions.html">Virtuoso Functions Guide</a>
</div>
<br />
<div>
<a href="functions.html#admin">Administration</a>
</div>
<div>
<a href="functions.html#aggr">Aggregate Functions</a>
</div>
<div>
<a href="functions.html#array">Array Manipulation</a>
</div>
<div>
<a href="functions.html#bpel">BPEL APIs</a>
</div>
<div>
<a class="selected" href="functions.html#backup">Backup</a>
</div>
<div class="selected">
<div>
<a href="fn_backup.html">backup</a>
</div>
<div>
<a href="fn_backup_context_clear.html">backup_context_clear</a>
</div>
<div>
<a href="fn_backup_online.html">backup_online</a>
</div>
<div>
<a class="selected" href="fn_replay.html">replay</a>
</div>
</div>
<div>
<a href="functions.html#compression">Compression</a>
</div>
<div>
<a href="functions.html#cursors">Cursor</a>
</div>
<div>
<a href="functions.html#time">Date & Time Manipulation</a>
</div>
<div>
<a href="functions.html#debug">Debug</a>
</div>
<div>
<a href="functions.html#dict">Dictionary Manipulation</a>
</div>
<div>
<a href="functions.html#encoding">Encoding & Decoding</a>
</div>
<div>
<a href="functions.html#file">File Manipulation</a>
</div>
<div>
<a href="functions.html#ft">Free Text</a>
</div>
<div>
<a href="functions.html#hash">Hashing / Cryptographic</a>
</div>
<div>
<a href="functions.html#ldap">LDAP</a>
</div>
<div>
<a href="functions.html#localization">Locale</a>
</div>
<div>
<a href="functions.html#mail">Mail</a>
</div>
<div>
<a href="functions.html#misc">Miscellaneous</a>
</div>
<div>
<a href="functions.html#number">Number</a>
</div>
<div>
<a href="functions.html#phrz">Phrases</a>
</div>
<div>
<a href="functions.html#rdf">RDF data</a>
</div>
<div>
<a href="functions.html#rmt">Remote SQL Data Source</a>
</div>
<div>
<a href="functions.html#repl">Replication</a>
</div>
<div>
<a href="functions.html#soap">SOAP</a>
</div>
<div>
<a href="functions.html#sql">SQL</a>
</div>
<div>
<a href="functions.html#string">String</a>
</div>
<div>
<a href="functions.html#txn">Transaction</a>
</div>
<div>
<a href="functions.html#type">Type Mapping</a>
</div>
<div>
<a href="functions.html#uddi">UDDI</a>
</div>
<div>
<a href="functions.html#udt">User Defined Types & The CLR</a>
</div>
<div>
<a href="functions.html#vad">VAD</a>
</div>
<div>
<a href="functions.html#jvmpl">Virtuoso Java PL API</a>
</div>
<div>
<a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a>
</div>
<div>
<a href="functions.html#ws">Web & Internet</a>
</div>
<div>
<a href="functions.html#xml">XML</a>
</div>
<div>
<a href="functions.html#XPATH">XPATH & XQUERY</a>
</div>
<br />
<div>
<a href="functionidx.html">Functions Index</a>
</div>
<br />
</div>
<div id="text">
<h2>replay</h2>
<div class="refpurpose">starts the roll forward of the given log</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">replay</span>
</span>
(<span class="paramdef">in <span class="parameter">log_file</span> varchar</span>);
</div>
<div class="refsect1">
<div class="refsect1title">Description</div>
<p>This starts a roll forward of the given log. The log may have been
produced by normal transaction logging, backup or crash dump. Logs
may not be transferred between databases and thus cannot be rolled forward
anywhere except on the database that generated them.</p>
<p>This function is for example useful after restoring a backup.
It should be called for each archived transaction log produced since the
backup, including and starting with the one that was current when the
backup was made.</p>
<p>The operation blocks until the roll forward is complete.
Other clients are not affected.</p>
</div>
<div class="refsect1title">Errors</div>
<p>
<a href="errors.html#datatypeerror">Parameter data type checking errors</a>
</p>
<table class="data">
<tr>
<td class="data">sqlstate</td>
<td class="data">error code</td>
<td class="data">error text</td>
</tr>
<tr>
<td class="data">
<a name="err25000" />
<span class="errorcode">25000</span>
</td>
<td class="data">
<a name="errSR074" />
<span class="errorcode">SR074</span>
</td>
<td class="data">
<span class="errorname">replay must be run in a fresh transaction.</span>
</td>
</tr>
<tr>
<td class="data">
<a name="err42000" />
<span class="errorcode">42000</span>
</td>
<td class="data">
<a name="errFA002" />
<span class="errorcode">FA002</span>
</td>
<td class="data">
<span class="errorname">Can't open file <fname>, error <OS errno> (<OS description>)</span>
</td>
</tr>
</table>
<br />
<p />
<div class="refsect1">
<div class="refsect1title">Parameters</div>
<div class="refsect2">
<span class="refsect2title">log_file – </span>
Full pathname of file containing the transactions to be replayed.
The file must be produced by <a href="fn_backup.html">backup</a>.
</div>
</div>
<div class="refsect1">
<div class="refsect1title">Return Values</div>
<p>Zero, if no error is signalled.</p>
</div>
<div class="refsect1">
<div class="refsect1title">Examples</div>
<a name="backupreplay" />
<div class="example">
<div class="exampletitle">Replaying A Log File</div>
<div>
<pre class="programlisting">
checkpoint 'new.log';
backup 'bak.log';
shutdown 'new2.log';
</pre>
</div>
<p>
The above sequence of commands makes a checkpoint and starts logging subsequent
transactions into new.log. The backup statement makes bak.log, which represents the state
prior to starting new.log. The shutdown statement makes a new checkpoint and marks new2.log as the log
file to be used for logging transactions after the database restarts. The database server exits at the completion of the
SHUTDOWN statement.
</p>
<div>
<pre class="programlisting">
replay ('bak.log');
replay ('new.log');
</pre>
</div>
<p>
These statements executed on an empty database will recreate the state in effect after the last transaction
to commit before the SHUTDOWN statement of the previous example.
</p>
</div>
</div>
<div class="refsect1">
<div class="refsect1title">See Also</div>
<p>
<a href="fn_backup.html">backup</a>
</p>
</div>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
507
