Restore a coordinator without renaming the utility database to use
the coordinator's name. This is the only supported read-only selective restore method 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 read-only
dbspaces that have been backed up on the separate read-only 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 read-only
dbspace.
Next
You may restore databases either completely or selectively (by restoring only
read-write dbspaces, or a set of read-only dbspaces or read-only files).