Restoring Database DBC to another Teradata RDBMS

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Restoring Database DBC to another Teradata...

Rate Topic

Display Mode

Topic Options

Author

Message

rglass

Posted 11/11/2008 8:20:12 PM

Forum Newbie

Group: Forum Members
Last Login: 11/11/2008 8:14:01 PM
Posts: 2, Visits: 10

To Restore DBC from Prodction System to DR system does Sysinit and Dip need to be run ?
They both are 12.0 but Produciton has more nodes/amps.

Thanks, RG

Post #13491

JvR

Posted 11/21/2008 5:30:38 AM

Forum Newbie

Group: Forum Members
Last Login: 2/3/2009 10:56:50 AM
Posts: 5, Visits: 7

Sysinit/DIP shouldn't be necessary. There can be an issue however if you have UDF's on the source-system. But normally, you do an archive data tables from DBC from arcmain on the source-system, then a delete database DBC on the target system and then (after transferring the archive), restore that archive on the target system.

Success,

Jos.

Post #13639

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 1 ( 1 guest, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 9:15pm