Friday, November 13, 2009

Using Cluster Commands on a Console to create New Copy, Replica, Template

We know it but hardly use it, its a great feature to use.

Using Cluster Commands on a Console to create New Copy, Replica, Template

  • Special “documented” cluster commands : The server does not have to be in a cluster
        Enabled by the following console command -->  
Set Config CLUSTER_ADMIN_ON=1

  • Copy a Database Using the Console :  You can copy a database from one server to another using the console
         Type the following:   
CL copy serverA!!db1.nsf serverB!!db2.nsf

  • Create Replica Using Console :  You can create a replica of a database from one server to another
        Type the following:   
CL copy serverA!!db1.nsf serverB!!db2.nsf REPLICA

  • Create Template Copy Using Console : You can create a template copy of a database from one server to another
         Type the following:  
CL copy serverA!!db1.nsf serverB!!db2.nsf TEMPLATE

  • Create Copy on Same Server :  You can create a copy of a database on the same server
         Type the following:   
CL copy db1.nsf db2.nsf

2 comments: