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

Question Posted / kittu_chintu2005

2 Answers
7227 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

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers

what is the difference between hot backup n rman backup?

1 Answers Value Labs,

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers IBM,

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

Describe what redo logs are.

1 Answers

internal architecture

0 Answers CSC,

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers

What is the default port no on which sql server listens? : sql server DBA

0 Answers

when does an alert gets signaled?

0 Answers Oracle,

What does coalescing a tablespace do?

1 Answers

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

1 Answers STC,

For more DB Administration Interview Questions Click Here