Oracle Database Discussions

Hi there,

Here are some questions which are real time based. If you could answer that will be very helpful.

1. Archivelog destination gets filling up and it is now 98%. I have more transactions at this time. DB is going to crash or hang in another 2 minutes? what is the step to be followed here?

2. First day you are taking up archivelog backup? next day morning you find some archivelogs missing? will RMAN show some logs are missing or it will take up backup when you give backup archive log command?

3.During RMAN backup of database, if your destination drive (mount point) found corrupted, how do you mount the new mount point with the same name as the corrupted mount point in another server , if no catalog database or with catalog db?

4.While at a peak time, where there is a huge transactions takesplace, you just happended to find PMON died ? will there be transactions happen after PMON's crash or database will go crash after finishing up all the transactions? Will database do instance recovery after bouncing up db after such a scenario?

5. You are issuing sqlplus username/password@connstring. what is actually happening at the background in db after you give that sqlplus command?
For this question my answer was oracle is creating a session for that particular user process. is this right?

6.If a user is telling you that i could not connect to the database? what should be checked here?


Thanks,
Balu.