Your circuit is not quite correct. If V1 is present and you close the switch V1 and the battery will be shorted together, and you don't want that. Their voltages will never be exactly the same, and that will cause a large short-circuit current. More about this in a minute.
When V1 is present the LED will be on through the battery, regardless of the position of SW1.
If V1 is gone the relay will be off, and so will the LED.
How to solve these issues? Use a switch-over relay to switch between V1 and battery and place it at the node next to the LED's anode.
A minor thing, though it will not change the circuit's functionality: you're interrupting the ground with your relay. Don't. Swap the relay contacts and the LED, so that you interrupt the positive voltage instead. Just a good habit. Has been fixed anyway in the previous paragraph.
And don't forget to place a series resistor with the LED. For a 20mA indicator LED a 1k\$\Omega\$/1W will do.
And clean it up a bit. The ground line at the bottom, going to the contact of SW3 is superfluous, and draw a single ground line for both power sources, so that it's obvious that they're connected.
edit (re your revised circuit)
We're almost there. The switch is in series with the relay coil, so closing it will create a path from coil through R1 and LED to ground. The -
of the coil should go directly to ground, and the switch should go between V1 and the unused relay contact.
But schematic-wise it looks already much better, don't you think? It may even pass the olin test ;-).
A RC circuit with long time constant + buffer with Schmitt trigger + relay will probably do the job. When you flip the lamp switch a capacitor is charged. When you flip it back, the capacitor will start to discharge slowly. When its voltage reaches certain voltage lamp is turned off.
Best Answer
What id use is a 555 in monostable vibrator mode.
Comprehensive information here and obv Google: http://www.electronics-tutorials.ws/waveforms/555_timer.html
Quick, simple and cheap. Should be pretty reliable and a great starter project for someone new to electronics...
If you use a pot for the timing resistor, you will be able to adjust the on time :)