Business Continuity Manager allows applications to run on a second Teradata system while the offline backup has tables locked.
Use the bcmadmin shell.
- Start a Read-only outage on the table, database, or system that you want to archive:
Option Description table bcmadmin -u admin -P admin -e 'object freeze <db.tablename> on <system_name>' database bcmadmin -u admin -P admin -e 'database freeze <db_name> on <system_name>' system bcmadmin -u admin -P admin -e 'system freeze <system_name>' For example, to begin an outage on a table named 'dbtest.table1' on Teradata 'system1', enter the following: bcmadmin -u admin -P admin -e 'object freeze dbtest.table1 on system1' - Recover the system, database, or table:
Option Description table bcmadmin -u admin -P admin -e 'object recover <db.tablename> on <system_name>' database bcmadmin -u admin -P admin -e 'database recover <db_name> on <system_name>' system bcmadmin -u admin -P admin -e 'system recover <system_name>'