Context, currently I have a oracle 11g db instance with fine tuned parameters from my team.
My Request is
How can I export/extract all parameter, (from all level, db param, init.ora, etc)??
Is there a way to create a script snapshot from the existing db (will all sizing, parameters, locaiton, etc)
Reason for my request is...next week I will get another fresh db instance.
If I have above 2 information
1. I can apply these parameters very easily or as a guidline
2. if I have the script I can run the script to create the db instance with all parameters
I like the 2nd option
but if you think I was wrong, and you have a much better suggestions...please advise
SQL> BACKUP CONTROLFILE TO TRACE;
then from the OS read the resulting trace file. It will contain the DDL to create the instance.