>Goulet, Dick > As an Oracle DBA primarily, moving more towards PostGreSQL as time > passes, the "alter system switch logfile" command is very often used at > the end of a hot backup to force a logfile switch and consequently > provide a full archive log set. The command causes the database engine > to cease using the current online redo log and have it archived to the > archive log destination. This is the only way to be sure that all > required archive logs are present in a backup to reconstitute the > database at another location. >
Yep, know what it does - just wanted to check that people really used it. I always felt I did that as a precaution rather than for good reason. OK - 8.1 it is then, Best Regards Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
