Updating spfile dating a scythian tomb


One can roll-forward until a specific point-in-time (before the disaster occurred), or roll-forward until the last transaction recorded in the log files.

updating spfile-57updating spfile-61

This can be done to replace damaged files or to copy/move a database to a new location.

Recovery is the process of applying redo logs to the database to roll it forward.

Issue the following commands to put a database into ARCHIVELOG mode: NOTE 1: Remember to take a baseline database backup right after enabling archivelog mode. Also, implement an archivelog backup to prevent the archive log directory from filling-up.

NOTE 2:' ARCHIVELOG mode was introduced with Oracle 6, and is essential for database point-in-time recovery.

Hardware and software can always be replaced, but your data may be irreplaceable!