Hi all,
I have a typical interview question, I searched for the solution, but didn't find it.
1-Int Que: RMAN scheduled backup is running and DBA executed "shutdown normal" command for some maintenance without knowing about backup, will the RMAN job completes or gets killed?
My Ans: As it is a shutdown normal, it should wait until existing processes completes and restricts new connections
2-Int Que: If there are two channels allocated for db backup and a separate channel for archivelog, the rman job status is db backup completed, and shutdown was initiated, will it start archivelog backup channel?
run {allocate channel d1 type disk;
allocate channel d2 type disk;
backup database;
release channel d1;
release channel d2;
allocate channel d3 type disk;
backup archivelog all;
release channel d3;
}
I got puzzled here, I tried to find the answer on the forum, as well as google, but didn't find it. Unfortunately I don't have a test machine to try this scenario myself. Therefore, request your valuable inputs.
Also let me know if my first assumption is correct and for what all connections shutdown normal and transactional waits(only users, or RMAN, expdp, etc as well) I did check this link, but it doesn't categorize the connections http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve042.htm
Thanks a lot in advance!!!
AbbasDBA