Using CLUSTER_DATABASE parameter
Hi
we are working on a process to move our 9i 2 node RAC database to 11g 2 node RAC database with ASM
we intend to use Transportable tablespace option to move the data over. The sequence is as follows
1. On production, place the Table space in READ ONLY mode
2. Export the meta data
3. Copy over the meta data and physical database file to new 11g RAC database on file system
4. Import the meta data
5. Take the tablespace offline
6. Move over the database files to ASM from File System using RMAN
7. Place the table space ONLINE
We have 2 questions
Q# 1
We dont have any shared storage other then ASM on the new system. Now for step # 3, we need a temporary staging area
we are working on a process to move our 9i 2 node RAC database to 11g 2 node RAC database with ASM
we intend to use Transportable tablespace option to move the data over. The sequence is as follows
1. On production, place the Table space in READ ONLY mode
2. Export the meta data
3. Copy over the meta data and physical database file to new 11g RAC database on file system
4. Import the meta data
5. Take the tablespace offline
6. Move over the database files to ASM from File System using RMAN
7. Place the table space ONLINE
We have 2 questions
Q# 1
We dont have any shared storage other then ASM on the new system. Now for step # 3, we need a temporary staging area
0