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

Question Posted / kittu_chintu2005

2 Answers
7425 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

What is the importance of a recovery model? : sql server DBA

0 Answers

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

What view would you use to look at the size of a data file?

3 Answers

What questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers Cognizant,

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers STC,

what functionality does oracle provide to secure sensitive information?

0 Answers Oracle,

what are the performance views in an oracle rac environment?

0 Answers Oracle,

From the database level, how can you tell under which time zone a database is operating?

1 Answers

what is the use of ocr?

0 Answers Oracle,

how can you create a user-defined lock?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here