Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
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
How to start SQL Server in minimal configuration mode?
Can you redefine a table online?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is the use of recording information about current session?
Query processing is slow(eg select query)how will u solve that
what do you understand by flashback feature of oracle?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What is replication? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
which background process invoke at the time of upgradation tell me???
what is the diffrence between core dba and apps dba?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you find out if a table can be redefined?