René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
The ARCHIVE LOG command in SQL*PLUS | ||
archive log list archive log stop archive log start archive log next archive log all archive log n
From within SQL*PLUS, an archive log {opt} command can be started that can be used
to start or stop
archiving
online redo log
files. Further, it can be used to display inofrmation
about
redo log files.
archive log list
This command displays:
archive log start [to destination]
Starts automatic archiving of redo logs (actually starts the arch process).
If destination is specified, it uses it a archiving destination. Otherwise
log_archive_dest_n is used to find out the destination.
|