This procedure lets you restore a coordinator without renaming the utility database to use the coordinator's name. This is the only supported way to do a read-only selective restore for a multiplex coordinator.
Use this procedure to correct problems resulting from inadvertently restoring read-only dbspaces from a read-write archive or vice versa.
- Start the utility server with any server name except that of a secondary node.
- Connect to the utility_db and run the RESTORE statement for the read-write database. Use RENAME clauses to move dbfiles to the corresponding locations.
- Disconnect and stop the utility server.
- Start the restored database. If the database has been moved to a different location, start the server with -iqmpx_sn 1and -iqmpx_ov 1 flags.
- Run ALTER DBSPACE <dbspace name> offline for the RO dbspaces that have been backed up on the separate RO backup only.
- Disconnect and stop the server.
- Start the utility database with any server name except that of a secondary node.
- Connect to the utility server and run the restore command for the RO dbspace.