In which of the scenario will the DBA perform recovery? (Choose all that apply.)
A.
The alert log file is corrupted
B.
A tablespace is accidentally dropped
C.
One of the redo log members is corrupted
D.
A database user terminates the session abnormally
E.
The hard disk on which the data files is stored is corrupted
Answers:
B.A tablespace is accidentally dropped.
E.The hard disk on which the data files is stored is corrupted
According to me,anything related to datafile corruption or dropping,DBA will have to perform recovery.
1.Tablespace consists of datafiles,if the tablespace is dropped the datafiles will get dropped,so recovery is needed as data is available in datafiles.
2.Hard disk on which datafiles are stored is corrupted.
i.e. this will in turn affect the datafiles.
Terminating an Active Session
If a user session is processing a transaction (ACTIVE status) when you terminate the session, the transaction is rolled back and the user immediately receives the following message:
ORA-00028: your session has been killed
If, after receiving the ORA-00028 message, a user submits additional statements before reconnecting to the database, Oracle Database returns the following message:
ORA-01012: not logged on
An active session cannot be interrupted when it is performing network I/O or rolling back a transaction. Such a session cannot be terminated until the operation completes. In this case, the session holds all resources until it is terminated. Additionally, the session that issues the ALTER SYSTEM statement to terminate a session waits up to 60 seconds for the session to be terminated. If the operation that cannot be interrupted continues past one minute, the issuer of the ALTER SYSTEM statement receives a message indicating that the session has been marked to be terminated. A session marked to be terminated is indicated in V$SESSION with a status of KILLED and a server that is something other than PSEUDO
Hi mates, nice piece of writing and good urging commented here, I am in fact enjoying by these.
athletic bilbao transfermarkt
If you are going for finest contents like myself, simply visit this web site everyday for
the reason that it gives quality contents, thanks
arsenal kläder