If we issue alter database begin backup. What happens to database?
Answer Posted / 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 View All Answers
how can you process messages in order asynchronously?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
when does an alert gets signaled?
What is the difference between clustered and non-clustered index? : sql server DBA
how can you enable flashback feature?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you record information about current session?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Explain materialized views and how they are used.
. 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?
What is a system database and what is a user database? : 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 functionality does oracle provide to secure sensitive information?