by issuing "alter tablespace begin backup;" what happens to
tablespace?

Answers were Sorted based on User's Feedback



by issuing "alter tablespace begin backup;" what happens to tablespace?..

Answer / kittu

by issuing above statement it freezes tablespace it won't
allow single transaction to datafile. by this time redologs are generated & excessive redologs also

Is This Answer Correct ?    7 Yes 3 No

by issuing "alter tablespace begin backup;" what happens to tablespace?..

Answer / 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

by issuing "alter tablespace begin backup;" what happens to tablespace?..

Answer / naveen

when u place a tablespace/database in backup (restore) mode(usually it's better idea to place only one tablespace at a time, as more logging is written, it should be done during a low activity period. And for the same reason, it is better to place the tablespaces one after one instead of putting all the tablespaces in backup mode)
when u alter the tablespace in begin backup mode - The datafile header is frozen so that whenever tablespace/datafile is copied, it reflects the checkpointSCN that was at the beginning of the backup. Then, when the copy will be restored, Oracle knows that it needs to start recovery at that SCN to apply the archived redo logs.This is to avoid the header inconsistency issue.That means that any further checkpoints do not update the datafile header SCN (but they do update a 'backup' SCN).
Each first modification to a block in buffer cache will write the full block into the redolog (in addition to the default behaviour that writes only the change vector).
At checkpoint the datafile header SCN is not updated - when updating a block, the first time it is updated since it came in the buffer cache,the whole before image of the block is recorded in redo- direct path writes do not go through the buffer cache, but they always write full blocks and then full block is written to redo log (if not in nologging)
This is to avoid the fractured block issue. There may be a fractured block in the copy, but it will be overwritten during the recovery with the full block image.

Is This Answer Correct ?    1 Yes 0 No

by issuing "alter tablespace begin backup;" what happens to tablespace?..

Answer / suman

alter tablespace begin backup; it means we can take the
backup of tablespace in hotbackup begin backup mode will be
start

Is This Answer Correct ?    2 Yes 3 No

by issuing "alter tablespace begin backup;" what happens to tablespace?..

Answer / kittu

by issuing above statement it freezes tablespace it won't
allow single transaction to datafile

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB Administration Interview Questions

Why would you call update statistics? : sql server DBA

0 Answers  


I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  


What type of index should you use on a fact table?

1 Answers  


hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,


suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,






Can we take incremental backups in datapump?

1 Answers  


who owns the operating system files created by the utl_file package?

0 Answers   Oracle,


Explain what partitioning is and what its benefit is.

2 Answers  


What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  


what are the differences of where and if in SAS?

0 Answers  


What are the steps you will take to improve performance of a poor performing query?

0 Answers  


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  


Categories