Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 24195 Views
- I also Faced
- E-Mail Answers
Answer Posted / pv bhaskar
Archivelog mode : We can recover the database at any point
in time.
No Archivelog mode : There is no Recovery Process.
Because Online Redologs are overwritten. so there is no
Archives in this mode.
If there is Media Failure(loss of Disks or files) in this
mode we can restore from a backup but we will loss all
changes made to the database,After the backup was performed.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What would you do with an "in-doubt" distributed transaction?
what is a crs resource?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How do you troubleshoot errors in a sql server agent job? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the operating modes in which database mirroring runs? : sql server DBA
what do you understand by flashback feature of oracle?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What is dcl? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
how to restore files with rman?
