- 论坛徽章:
- 0
|
回复 4# liaosnet
请教一下,单表恢复支持分片的表吗?
我上面那个恢复这是因为需要恢复的表失败了而找的一个简单表进行测试,真正要恢复的表是分片的,而且建表脚本指定了dbspace,应该是正确的,但是还是报同样的错
database npmdb;
create table tcc_ne_snap_bak_xy
(
ne_id integer not null ,
ne_type integer not null ,
first_result datetime year to second not null ,
compress_date date not null ,
s_month smallint,
related_ne1 integer not null ,
related_type1 integer not null ,
related_ne2 integer,
related_type2 integer,
related_site integer,
related_bsc integer,
related_bss integer,
related_msc integer,
related_omc integer,
city_id integer,
admin_level integer,
region_id integer,
area_id integer,
parent_ne_id integer not null ,
parent_ne_type integer not null ,
pm_rdn varchar(255) not null ,
userlabel varchar(255),
zh_label varchar(12,
vendor_id smallint,
gsmdcsindicator integer,
locationname varchar(127),
version varchar(127),
adminstate smallint,
optstate smallint,
usagestate smallint,
unknownstatus smallint,
native_int_id integer,
upd_flag smallint,
ne_code varchar(127),
int_id integer,
object_class integer,
confirmed smallint,
province_id integer,
tmsc_cat integer,
carrier_id integer,
stp_cat integer,
area_code integer,
related_lac integer,
ci integer,
lpt_type varchar(20),
related_ne3 integer,
related_type3 integer,
foreign_obj_ind integer
default 0 not null ,
resource_status smallint
default 1 not null ,
is_locked smallint
default 0 not null ,
lock_time datetime year to second,
machroom_id integer,
new_rdn varchar(12,
import_label varchar(127),
d_province_id integer,
d_area_id integer,
d_admin_level integer,
d_region_id integer,
d_city_id integer,
d_related_omc integer,
d_related_msc integer,
d_related_bss integer,
d_related_bsc integer,
d_related_site integer,
d_tmsc_cat integer,
d_stp_cat integer,
d_carrier_id integer,
d_related_lac integer,
d_vendor_id integer,
related_stp integer,
related_linkset integer,
related_smp integer,
related_scp integer,
related_sdp integer,
related_sau integer,
related_ip integer,
d_related_stp integer,
d_related_linkset integer,
d_related_smp integer,
d_related_scp integer,
d_related_sdp integer,
d_related_sau integer,
d_related_ip integer,
cat1_sv_id integer,
cat2_sv_id integer,
cat3_sv_id integer,
cat4_sv_id integer,
cat5_sv_id integer,
cat6_sv_id integer,
cat7_sv_id integer,
cat8_sv_id integer,
cat9_sv_id integer,
cat10_sv_id integer,
cat11_sv_id integer,
cat12_sv_id integer,
cat13_sv_id integer,
cat14_sv_id integer,
cat15_sv_id integer,
cat16_sv_id integer,
cat17_sv_id integer,
cat18_sv_id integer,
cat19_sv_id integer,
d_related_smsrv integer,
divide_in_time datetime year to second,
divide_out_time datetime year to second,
related_smsrv integer,
time_putinto_use datetime year to second,
d_related_smsc integer,
related_smsc integer,
country_id integer,
d_country_id integer,
cat20_sv_id integer,
cat21_sv_id integer,
cat22_sv_id integer,
cat23_sv_id integer,
cat24_sv_id integer,
cat25_sv_id integer,
cat26_sv_id integer,
cat27_sv_id integer,
cat28_sv_id integer,
cat29_sv_id integer,
related_tmg integer,
d_related_tmg integer,
related_tserver integer,
d_related_tserver integer,
mgw_cat integer,
mss_cat integer,
related_managedelement varchar(255),
related_managedelement_id integer,
managementipaddress varchar(255),
patchinfo varchar(255),
related_rns integer,
related_rnc integer,
related_nodeb integer,
related_mscserver integer,
d_related_rns integer,
d_related_rnc integer,
d_related_nodeb integer,
d_related_mscserver integer,
network_type integer,
primary key (compress_date,ne_type,ne_id)
)fragment by round robin in apmdbs1 , apmdbs2 , apmdbs3 , apmdbs4 , apmdbs5
, apmdbs6 , apmdbs7 , apmdbs8 , apmdbs9 , apmdbs10 , apmdbs11
, apmdbs12;
create table tcc_ne_snap_bak_20110218
(
ne_id integer not null ,
ne_type integer not null ,
first_result datetime year to second not null ,
compress_date date not null ,
s_month smallint,
related_ne1 integer not null ,
related_type1 integer not null ,
related_ne2 integer,
related_type2 integer,
related_site integer,
related_bsc integer,
related_bss integer,
related_msc integer,
related_omc integer,
city_id integer,
admin_level integer,
region_id integer,
area_id integer,
parent_ne_id integer not null ,
parent_ne_type integer not null ,
pm_rdn varchar(255) not null ,
userlabel varchar(255),
zh_label varchar(12,
vendor_id smallint,
gsmdcsindicator integer,
locationname varchar(127),
version varchar(127),
adminstate smallint,
optstate smallint,
usagestate smallint,
unknownstatus smallint,
native_int_id integer,
upd_flag smallint,
ne_code varchar(127),
int_id integer,
object_class integer,
confirmed smallint,
province_id integer,
tmsc_cat integer,
carrier_id integer,
stp_cat integer,
area_code integer,
related_lac integer,
ci integer,
lpt_type varchar(20),
related_ne3 integer,
related_type3 integer,
foreign_obj_ind integer
default 0 not null ,
resource_status smallint
default 1 not null ,
is_locked smallint
default 0 not null ,
lock_time datetime year to second,
machroom_id integer,
new_rdn varchar(12,
import_label varchar(127),
d_province_id integer,
d_area_id integer,
d_admin_level integer,
d_region_id integer,
d_city_id integer,
d_related_omc integer,
d_related_msc integer,
d_related_bss integer,
d_related_bsc integer,
d_related_site integer,
d_tmsc_cat integer,
d_stp_cat integer,
d_carrier_id integer,
d_related_lac integer,
d_vendor_id integer,
related_stp integer,
related_linkset integer,
related_smp integer,
related_scp integer,
related_sdp integer,
related_sau integer,
related_ip integer,
d_related_stp integer,
d_related_linkset integer,
d_related_smp integer,
d_related_scp integer,
d_related_sdp integer,
d_related_sau integer,
d_related_ip integer,
cat1_sv_id integer,
cat2_sv_id integer,
cat3_sv_id integer,
cat4_sv_id integer,
cat5_sv_id integer,
cat6_sv_id integer,
cat7_sv_id integer,
cat8_sv_id integer,
cat9_sv_id integer,
cat10_sv_id integer,
cat11_sv_id integer,
cat12_sv_id integer,
cat13_sv_id integer,
cat14_sv_id integer,
cat15_sv_id integer,
cat16_sv_id integer,
cat17_sv_id integer,
cat18_sv_id integer,
cat19_sv_id integer,
d_related_smsrv integer,
divide_in_time datetime year to second,
divide_out_time datetime year to second,
related_smsrv integer,
time_putinto_use datetime year to second,
d_related_smsc integer,
related_smsc integer,
country_id integer,
d_country_id integer,
cat20_sv_id integer,
cat21_sv_id integer,
cat22_sv_id integer,
cat23_sv_id integer,
cat24_sv_id integer,
cat25_sv_id integer,
cat26_sv_id integer,
cat27_sv_id integer,
cat28_sv_id integer,
cat29_sv_id integer,
related_tmg integer,
d_related_tmg integer,
related_tserver integer,
d_related_tserver integer,
mgw_cat integer,
mss_cat integer,
related_managedelement varchar(255),
related_managedelement_id integer,
managementipaddress varchar(255),
patchinfo varchar(255),
related_rns integer,
related_rnc integer,
related_nodeb integer,
related_mscserver integer,
d_related_rns integer,
d_related_rnc integer,
d_related_nodeb integer,
d_related_mscserver integer,
network_type integer,
primary key (compress_date,ne_type,ne_id)
);
insert into tcc_ne_snap_bak_20110218 select * from tcc_ne_snap_bak_xy;
restore to "2011-02-04 12:00:00"; |
|