If we issue alter database begin backup. What happens to database?
Answer Posted / kittu_chintu2005
It freezes the entire database and it won’t take any transaction to datafile then excessive redologs generates.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is grd?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how can a session indicate its interest in receiving alerts?
What is replication? : sql server DBA
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?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is the role of dip user in our database?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What the different topologies in which replication can be configured? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you record information about current session?
what are the benefits of flashback feature?