If we issue alter database begin backup. What happens to database?

Answers were Sorted based on User's Feedback



If we issue alter database begin backup. What happens to database?..

Answer / raj

it locks the header #SCN number of the datafiles and
datafiles will be updated continuously.
If the db is coming out from begin backup mode it updates
the header #SCN number.

Is This Answer Correct ?    16 Yes 1 No

If we issue alter database begin backup. What happens to database?..

Answer / 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

More DB Administration Interview Questions

How would you determine the time zone under which a database was operating?

2 Answers  


If we issue alter database begin backup. What happens to database?

2 Answers  


What is dbcc? : sql server DBA

0 Answers  


What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  


Name a tablespace automatically created when you create a database.

5 Answers  






How can we know the exact updation date of a particular database?

2 Answers   Satyam,


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  


How would you go about increasing the buffer cache hit ratio?

2 Answers  


any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,


Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  


Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  


what are the types of connection load-balancing?

0 Answers   Oracle,


Categories