rcc50886
asked on
export/import
hi...
we have a database on a single instance having size 15GB and using file system for storage.
we want to migrate that database (full exp/imp) into a new RAC database which is using ASM.
what are the options i had?
for full exp/imp, i can take the full exp from single instance database (which is using file system)
then how to import into RAC database (2-node) having ASM?
following are my questions.......
1) on 2node RAC, we have 2 instances up and running.
so can i import through one instance ??
2) how to importing from non-ASM to ASM??
we have a database on a single instance having size 15GB and using file system for storage.
we want to migrate that database (full exp/imp) into a new RAC database which is using ASM.
what are the options i had?
for full exp/imp, i can take the full exp from single instance database (which is using file system)
then how to import into RAC database (2-node) having ASM?
following are my questions.......
1) on 2node RAC, we have 2 instances up and running.
so can i import through one instance ??
2) how to importing from non-ASM to ASM??
Last Comment
SOLUTION
THIS SOLUTION IS 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 IS 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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS 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.
ASKER
thanks it works!!!
When you do a impdp into a RAC db is faster if you shutdown one of the nodes (or just have 1 up) do the import and start it (the nodes) again after the import.
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
can you please explain it? i didn't understand it....
Thanks