| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: !HELP!-max number of record...
On Wed, 10 Jun 1998 22:49:26 -0600, "Andre M. J." <andreas_at_xmission.com> wrote:
>When I created the database and transfer a lot of records
>(ca. 48,000,000), the database crash.
>
>part of or01ALRT.log
>.....[SNIP].....
>I know what the problem was - to many log sequences records
>- to small redo log files.
>I recreated the database with 100 times biger redo log files.
>Now (today) the sequence log# is ca. 350, but after a few months I will
>be again close the maximum number of records.
>I fund a info:
> "There is a bug No - 485937"
>but I don't have idea how solve the bug.
>
>If somebody have any sugestions, please mail me back.
The workaround could be to restart the database with RESETLOGS option when the log sequence number aproaches 64K, i.e.
ALTER DATABASE RESETLOGS; This will reset your log sequence back to 1. It is advisable to perform a database backup after reseting logs.
>Thaks,
> Andre
Regards,
Jurij Modic Republic of Slovenia jurij.modic_at_mf.sigov.mail.si Ministry of Finance ============================================================The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Jun 11 1998 - 00:00:00 CDT
 |
 |