Backup and recovery in no archive log mode
When the database is running in no archive log mode, only cold back up can be taken.
The steps are :
1. Shutdown the database
2. Copy data files, control files, redo log files using OS commands to a backup location.
3. Startup database
If any of the files (data/control/redo) is corrupt in no archive log mode, you need to restore all files from backup. If relocation of files is necessary, you need to open the database in mount stage and issue rename command to specify new location of the files. Then you should open database for normal use. In no archive log mode, you can only recover data, which was taken during back up period. Even if only one file is corrupt, you need to restore all files and recover entire database.
1. Shutdown the database
2. Copy data files, control files, redo log files using OS commands to a backup location.
3. Startup database
If any of the files (data/control/redo) is corrupt in no archive log mode, you need to restore all files from backup. If relocation of files is necessary, you need to open the database in mount stage and issue rename command to specify new location of the files. Then you should open database for normal use. In no archive log mode, you can only recover data, which was taken during back up period. Even if only one file is corrupt, you need to restore all files and recover entire database.
No comments:
Post a Comment