asked on
extract oracle database instance all parameters
Hi,
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
thanks in advance
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
thanks in advance
Oracle Database
Last Comment
probinson7
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
1-any oracle instance will have hunderds of parameters ;the ones that usually of concern are the non default ones which are in your parametr file or spfile.
what I mean by that if you open your parametr file and you find say just 30 parametrs it does not mean you are not using the others it means the others are started with the DB as default (how they were shipped with the DB specific to release,version and platform)
so rephrase your Q how can I get the current parametrs of my current system simply from the pfile/init.ora;if you have an spfile just do
create pfile from spfile;
what I mean by that if you open your parametr file and you find say just 30 parametrs it does not mean you are not using the others it means the others are started with the DB as default (how they were shipped with the DB specific to release,version and platform)
so rephrase your Q how can I get the current parametrs of my current system simply from the pfile/init.ora;if you have an spfile just do
create pfile from spfile;
2-there is avery important point here you need to pay attention too;
is the other instance will be installed using the same release,version on the same plaftorm?
will it be using HA like datagaurd?
is it going to be behinf firewall?
is it going to be clustered RAC or fail safe fior windows?
if so and the original system you have mentioned is diifferent ;importing parameters like that;will not be a good solution.
is the other instance will be installed using the same release,version on the same plaftorm?
will it be using HA like datagaurd?
is it going to be behinf firewall?
is it going to be clustered RAC or fail safe fior windows?
if so and the original system you have mentioned is diifferent ;importing parameters like that;will not be a good solution.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SQL> BACKUP CONTROLFILE TO TRACE;
then from the OS read the resulting trace file. It will contain the DDL to create the instance.