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


Please Help Members By Posting Answers For Below Questions

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1555


how can you implement fine-grained auditing?

604


What is transparent data encryption? : sql server DBA

562


when does an alert gets signaled?

578


What is replication? : sql server DBA

624






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.

1748


Where do you find the default index fill factor and how to change it? : sql server DBA

554


how can you enable flashback feature?

536


How would you best determine why your MVIEW couldn't FAST REFRESH?

1826


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1589


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

1901


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

556


what is the diffrence between core dba and apps dba?

2087


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1834


what is the use of ocr?

597