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
what is a crs resource?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is replication? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
which background process invoke at the time of upgradation tell me???
what do you understand by flashback feature of oracle?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what functionality does oracle provide to secure sensitive information?
Can you redefine a table online?
who owns the operating system files created by the utl_file package?