by issuing "alter tablespace begin backup;" what happens to
tablespace?
Answer Posted / 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 |
Post New Answer View All Answers
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How would you go about verifying the network name that the local_listener is currently using?
How do you open a cluster administrator? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
how does an oracle clusterware manage crs resources?
Why would you use sql agent? : sql server DBA
How to start SQL Server in minimal configuration mode?
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?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is a system database and what is a user database? : sql server DBA
what is the use of ocr?
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
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?