RelationalDBDesign RelationalDBDesign


Archiving Redo log   «Prev 

Manually archiving Log Files

Manual archive
Manually archiving Log Files
THREAD thread_number Identifies the thread number. This is necessary only in Oracle Parallel Server environments.
SEQUENCE seq_num Archives the log file corresponding to the specified sequence number.
CHANGE change_num Archives the log files containing the specified system change number.
CURRENT Archives the current redo log file. Note that Oracle will do a log switch first.
GROUP group_num Archives the specified redo log file group.
LOGFILE 'filename' Archives the named log file.
NEXT Archives the next log file in the sequence that needs archiving.
ALL Archives all log files that haven't been archived yet.
TO 'location' Allows you to override the archive log destination for this one operation.