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