Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archive mode
hi,
you have to do a manual archive:
Performing Manual Archiving
If a database is operating in ARCHIVELOG mode, inactive groups of filled
online redo log files must be archived. You can manually archive groups of
the online redo log whether or not automatic archiving is enabled:
If automatic archiving is not enabled, you must manually archive groups of
filled online redo log files in a timely fashion. If all online redo log
groups are filled but not archived, LGWR cannot reuse any inactive groups of
online redo log members to continue writing redo log entries. Therefore,
database operation is temporarily suspended until the necessary archiving is
performed.
If automatic archiving is enabled, but you want to rearchive an inactive
group of filled online redo log members to another location, you can use
manual archiving. (However, the instance can decide to reuse the redo log
group before you have finished manually archiving, and thereby overwrite the
files; if this happens, Oracle will put an error message in the ALERT file.)
To manually archive a filled online redo log group, you must be connected
with administrator privileges.
Manually archive inactive groups of filled online redo log members using the SQL command ALTER SYSTEM with the ARCHIVE LOG clause.
The following statement archives all unarchived log files:
ALTER SYSTEM ARCHIVE LOG ALL;
Hope this helps
Adolf
CME Systems <support_at_cmesys.demon.co.uk> schrieb in im Newsbeitrag:
972554296.16975.0.nnrp-03.c2de4217_at_news.demon.co.uk...
> Thanks again. I have checked what you said and these lines were commented
> out so I have changed to archive = true but this will not have any affect
> until I restart the service. I am still waiting for srvmgr to sut down the
> service and it is just sat there. I really do not know what is happening
and
> what is going on in the background but I am the only person with access to
> the database and the service will not shut down. Any ideas?
> Thanks in advance
> Andy
>
>
Received on Thu Oct 26 2000 - 05:24:33 CDT