ORACLE BACKUP ISSUE
Budget: $10 – $30 USD
Taking backup in SERVER1 with the command expdp then copying it to SERVER2 and importing with impdp gives me the following:
1.- SERVER1 - TABLE1: Before backup:
ID|DATA
1|AAA
2|BBB
3|CCC
4|DDD
2.- SERVER2 - TABLE1: After import the backup
ID|DATA
1|AAA
2|BBB
3|CCC
4|DDD
3.- SERVER1 - TABLE1: After Inserting a record the sequence defined in the table gives the correlative ID=5 and so on
ID|DATA
1|AAA
2|BBB
3|CCC
4|DDD
5|EEE
6|FFF
7|GGG
4.- SERVER2 - TABLE1: After Inserting a record the sequence defined in the table first gives non-correlative ID for example ID=11, then gives correlatives
ID|DATA
1|AAA
2|BBB
3|CCC
4|DDD
11|EEE
12|FFF
13|GGG
Is there any way to use the expdp/impdp command in order to have correlatives ID after importing the backup and then inserting on SERVER2 ? (Maybe using RMAN or other method?)
I need SERVER1 and SERVER2 with the same ID. I have linux server oracle 11g standart
1.- SERVER1 - TABLE1: Before backup:
ID|DATA
1|AAA
2|BBB
3|CCC
4|DDD
2.- SERVER2 - TABLE1: After import the backup
ID|DATA
1|AAA
2|BBB
3|CCC
4|DDD
3.- SERVER1 - TABLE1: After Inserting a record the sequence defined in the table gives the correlative ID=5 and so on
ID|DATA
1|AAA
2|BBB
3|CCC
4|DDD
5|EEE
6|FFF
7|GGG
4.- SERVER2 - TABLE1: After Inserting a record the sequence defined in the table first gives non-correlative ID for example ID=11, then gives correlatives
ID|DATA
1|AAA
2|BBB
3|CCC
4|DDD
11|EEE
12|FFF
13|GGG
Is there any way to use the expdp/impdp command in order to have correlatives ID after importing the backup and then inserting on SERVER2 ? (Maybe using RMAN or other method?)
I need SERVER1 and SERVER2 with the same ID. I have linux server oracle 11g standart