troubleshooting Question

extract oracle database instance all parameters

Avatar of grind67
grind67 asked on
Oracle Database
6 Comments3 Solutions542 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
it-rex

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros