a hot backup is basically taking a backup of the database while it is still up and running and it must be archive log mode.
a cold backup is taking a backup of the database while it is shut down and does not require being in archive log mode. 唔使理我
原帖由 灰袍聖徒 於 2007-6-7 12:59 AM 發表
a hot backup is basically taking a backup of the database while it is still up and running and it must be archive log mode.
a cold backup is taking a backup of the database while it is shut down and d ...
the benefit of taking a hot backup is that the database is stille available for use while the backup is occuring and you can recover the database to any pint in time.
the benefit of taking a cold backup is that it is typically easier to administer the backup and recovery process.Since you are taking cold backups the database does not require being in archive log mode and thus there will be a slight preformance gain as the database is not cutting archive log to disk
原帖由 灰袍聖徒 於 2007-6-7 01:03 AM 發表
the benefit of taking a hot backup is that the database is stille available for use while the backup is occuring and you can recover the database to any pint in time.
the benefit of taking a cold back ...
backup is the duplication of the database at a time when the database is consistent
no transaction should be in progress while is copied
in an incremental backup at a cretain level, only htose blocks that had changed since the last lower-level backup are copied. a full backup has level zero
PMON - Process Monitor; releases resources once processes are done with them.REstart serber and iser processes if they appear to have stopped unexpextedly
原帖由 灰袍聖徒 於 2007-6-7 01:14 AM 發表
backup is the duplication of the database at a time when the database is consistent
no transaction should be in progress while is copied
in an incremental backup at a cretain level, only htose blocks ...
DBWs - the last character will be a number, designating different Database writer processes. the default precess is DBW0. it writes data drom change buffers to datafiles.