blob: bed12e8c4248347e4214aa090bbe80b4c608123a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Chapter 5. Administrating Berkeley DB SQL Databases</title>
<link rel="stylesheet" href="gettingStarted.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
<link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" />
<link rel="up" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" />
<link rel="prev" href="rep_usageexamples.html" title="Replication Usage Examples" />
<link rel="next" href="sync.html" title="Syncing with Oracle Databases" />
</head>
<body>
<div xmlns="" class="navheader">
<div class="libver">
<p>Library Version 12.1.6.1</p>
</div>
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center">Chapter 5. Administrating Berkeley DB SQL Databases</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="rep_usageexamples.html">Prev</a> </td>
<th width="60%" align="center"> </th>
<td width="20%" align="right"> <a accesskey="n" href="sync.html">Next</a></td>
</tr>
</table>
<hr />
</div>
<div class="chapter" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title"><a id="admin"></a>Chapter 5. Administrating Berkeley DB SQL Databases</h2>
</div>
</div>
</div>
<div class="toc">
<p>
<b>Table of Contents</b>
</p>
<dl>
<dt>
<span class="sect1">
<a href="admin.html#backup">Backing Up Berkeley DB SQL Databases</a>
</span>
</dt>
<dd>
<dl>
<dt>
<span class="sect2">
<a href="admin.html#idp51296616">Backing Up Replicated Berkeley DB SQL Databases</a>
</span>
</dt>
</dl>
</dd>
<dt>
<span class="sect1">
<a href="sync.html">Syncing with Oracle Databases</a>
</span>
</dt>
<dd>
<dl>
<dt>
<span class="sect2">
<a href="sync.html#syncunix">Syncing on Unix Platforms</a>
</span>
</dt>
<dt>
<span class="sect2">
<a href="sync.html#syncwin">Syncing on Windows Platforms</a>
</span>
</dt>
<dt>
<span class="sect2">
<a href="sync.html#syncwinmobile">Syncing on Windows Mobile Platforms</a>
</span>
</dt>
</dl>
</dd>
<dt>
<span class="sect1">
<a href="datamigration.html">Data Migration</a>
</span>
</dt>
<dd>
<dl>
<dt>
<span class="sect2">
<a href="datamigration.html#shellmigrate">Migration Using the Shells</a>
</span>
</dt>
</dl>
</dd>
<dt>
<span class="sect1">
<a href="recoverysql.html">Catastrophic Recovery</a>
</span>
</dt>
<dt>
<span class="sect1">
<a href="statsql.html">Database Statistics</a>
</span>
</dt>
<dt>
<span class="sect1">
<a href="verifysql.html">Verify Database Structure</a>
</span>
</dt>
</dl>
</div>
<p>
This chapter provides administrative procedures that are unique
to the Berkeley DB SQL interface.
</p>
<div class="sect1" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title" style="clear: both"><a id="backup"></a>Backing Up Berkeley DB SQL Databases</h2>
</div>
</div>
</div>
<div class="toc">
<dl>
<dt>
<span class="sect2">
<a href="admin.html#idp51296616">Backing Up Replicated Berkeley DB SQL Databases</a>
</span>
</dt>
</dl>
</div>
<p>
You can use the standard SQLite <code class="literal">.dump</code>
command to backup the data managed by the BDB SQL interface.
</p>
<p>
The BDB SQL interface supports the standard SQLite Online Backup API.
However, there is a small difference between the two interfaces.
In the BDB SQL interface, the value returned by the <code class="literal">sqlite3_backup_remaining</code> method
and the number of pages passed to the <code class="literal">sqlite3_backup_step</code> method,
are estimates of the number of pages to be copied and not exact values.
To be certain that the backup process is complete,
check if the <code class="literal">sqlite3_backup_step</code> method has returned <code class="literal">SQLITE_DONE</code>.
To learn how to use SQLite Online Backup API, see the official <a class="ulink" href="http://www.sqlite.org/backup.html" target="_top">SQLite
Documentation Page.</a>
</p>
<div class="sect2" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h3 class="title"><a id="idp51296616"></a>Backing Up Replicated Berkeley DB SQL Databases</h3>
</div>
</div>
</div>
<p>
When BDB SQL interface databases are replicated .dump and the SQLite Online
Backup API are not sufficient to create a backup. In a separate
process you should use the <a href="../api_reference/C/db_hotbackup.html" class="olink">db_hotbackup</a> utility or other methods
described in the
<a href="../gsg_txn/C/backuprestore.html" class="olink">Oracle Berkeley DB Backup Procedures</a>
section. You must then copy
some additional files for the backup to be complete.
</p>
<p>
The additional files can be found in the journal directory of
the source database, and should be copied into the journal
directory of the backup copy. The journal directory is
automatically created when a Berkeley DB SQL interface database is created.
The journal directory is created in the same directory as the
database file, it has the name of the database file with a
<code class="literal">-journal</code> appendix.
</p>
<p>
The files that need to be copied into the backup journal directory are:
</p>
<div class="itemizedlist">
<ul type="disc">
<li>
<code class="literal">__db.rep.egen</code>
</li>
<li>
<code class="literal">__db.rep.gen</code>
</li>
<li>
<code class="literal">__db.rep.init</code>
</li>
<li>
<code class="literal">__db.rep.system</code>
</li>
<li>
<code class="literal">pragma</code>
</li>
</ul>
</div>
<p>
</p>
</div>
</div>
</div>
<div class="navfooter">
<hr />
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="rep_usageexamples.html">Prev</a> </td>
<td width="20%" align="center"> </td>
<td width="40%" align="right"> <a accesskey="n" href="sync.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top">Replication Usage Examples </td>
<td width="20%" align="center">
<a accesskey="h" href="index.html">Home</a>
</td>
<td width="40%" align="right" valign="top"> Syncing with Oracle Databases</td>
</tr>
</table>
</div>
</body>
</html>
|
