Rename - Migration filespace's Oracle.

[chris_magic]

Hi,

I have a question for you .... Oracle server was renamed and therefore I must create a new node for the TDP Oracle.

My question is how to "migrate" the old filespace from Oracle DB to the new node?

 

[moon-buddy]

I haven't tried doing this for Oracle nodes being controlled by RMAN. There is no issue for plain vanilla BA nodes

I believe the command 'rename node' works as well on these types of nodes. Obviously, the file space will be carried over.

Just remember, if you rename the node, don't forget to regenerate the passwords for the new node name/s and modify your RMAN scripts to match.

 

[ChrisRees]

Hi

If you use "rename node" and then "rename filespace" you should be able to carry on as normal I think

>>-REName FIlespace--node_name---------------------------------->
>--current_file_space_name--new_file_space_name----------------->
.-NAMEType--=--SERVER------.
>--+--------------------------+--------------------------------->
'-NAMEType--=--+-SERVER--+-'
+-UNIcode-+
'-FSID----'
.-NEWNAMEType--=--SERVER-----------.
>--+----------------------------------+------------------------><
| (1) |
'-NEWNAMEType--=--+-UNIcode------+-'
'-HEXadecimal--'

 

[moon-buddy]

Hi

If you use "rename node" and then "rename filespace" you should be able to carry on as normal I think

>>-REName FIlespace--node_name---------------------------------->
>--current_file_space_name--new_file_space_name----------------->
.-NAMEType--=--SERVER------.
>--+--------------------------+--------------------------------->
'-NAMEType--=--+-SERVER--+-'
+-UNIcode-+
'-FSID----'
.-NEWNAMEType--=--SERVER-----------.
>--+----------------------------------+------------------------><
| (1) |
'-NEWNAMEType--=--+-UNIcode------+-'
'-HEXadecimal--'

When you use rename node, the new node name carries the filespace UNLESS you want the filespace to have a different name. This is most likely what you want to do with DB filespace names. By renaming a node, you will also want to rename the associated DB names, and is reflected as filespace names.