If we issue alter database begin backup. What happens to database?
Answer Posted / 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 |
Post New Answer View All Answers
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What authentication modes does sql server support? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What happens on checkpoint? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
what are the performance views in an oracle rac environment?
What purpose does the model database server? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Can you redefine a table online?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
which background process invoke at the time of upgradation tell me???