High Level steps:
1. Create pfile from spfile and shutdown database
2. Startup database in mount state using PFILE
3. Run NID command at server level (at the end of
this DB will be shut down by this command)
4. Change DB_NAME parameter in create pfile to new
name want to set.
5. Startup database in mount state using pfile and
create new spfile from pfile.
6. Open database in resetlogs
7. Restart the database