Hi DBAs,
I am in the situation to add a 2 more control file in my production DB for future recovery purpose.
I tried something but failed.
Can anyone let me know how to proceed.
OS - WIN NT 4
DB - 8.1.5 Production.
Thanx in adavance.
Printable View
Hi DBAs,
I am in the situation to add a 2 more control file in my production DB for future recovery purpose.
I tried something but failed.
Can anyone let me know how to proceed.
OS - WIN NT 4
DB - 8.1.5 Production.
Thanx in adavance.
1. Shutdown
2. OS copy the control file to the new location ( or give it a new name)
3. Add the control file you've just added in the CONTROL_FILE section in the init file.
4. Restart.