![]() Related Questions Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode? Latest Answer : Take backup of redologfiles only when you are doing cold backup not when you are taking hot backup in that case take backup of datafiles and controlfiles (thru backup trace command) and archivelogs. ... If we are running in NOARCHIVELOG mode and my all redo log files are full and data is still not committed by the current session. What activity will Oracle perform and what will happen with the un-comitted Latest Answer : NONARCHIVE log will Protect the DB from Instence faliure but not from Media failure.The Redo files will be covered until the last backup taken , but after that all uncommited datae will be lost for the period (after the last backup) taken. ... A Database is running in NoArchiveLog mode then which type of backups you can take? Latest Answer : If your database is in NOARCHIVELOG mode, then the only type of backups that you should perform are closed, consistent (COLD BACKUP), whole database backups. The files in this type of backup are all consistent and do not need recovery, so the online logs ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||