by issuing "alter tablespace begin backup;" what happens to
tablespace?
Answer Posted / ravindra
When alter tablespace begin backup?
Ans:Oracle will write all changes to the datafile by rising
checkpoint and freezes the datafile header with latest SCN.
and backup will take upto latest SCN and transactions are
updating to datafiles also changes will be generate many
archivelogs because all changed transactions information
written to Redologs.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can a session indicate its interest in receiving alerts?
what do you understand by flashback feature of oracle?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is ora 24313?what is the procedure to exclude that error?
What the different types of replication and why are they used? : sql server DBA
What is replication? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Why would you call update statistics? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.