Impact of the new feature
DBS internal
Is your feature request related to a problem? Please describe.
In the context of the few development and operations requests received lately, which would impose intrusive database interventions, we need to create a full copy of the production DBS schema from the CMSR database to INT2R, and also to document the procedure with all supplementary information and documentation links, such that those operations can be repeated any time when needed, or even better, to automate this procedure and have it executed on a regular basis.
Describe the solution you'd like
Create a copy of the DBS schema from the CMSR database into INT2R
Describe alternatives you've considered
None.
It is a MUST DO!
Additional context
- Internally ticket with the CERN DBAs: INC4445090
- Knowledge base:
- Instructions for the cp procedures: KB0001169 it provides 3 alternative methods:
- Method 1: SQl Developer - Using the client's
dbCopy feature
- Method 2:
DP tool - Scripts developed at CERN
- Method 3:
DataPump - Original Oracle Utility
- Setting up Oracle env @ lxplus (EOS/AFS): KB0001167
- Setting up SQL Developer: KB0001276
Impact of the new feature
DBS internal
Is your feature request related to a problem? Please describe.
In the context of the few development and operations requests received lately, which would impose intrusive database interventions, we need to create a full copy of the production DBS schema from the CMSR database to INT2R, and also to document the procedure with all supplementary information and documentation links, such that those operations can be repeated any time when needed, or even better, to automate this procedure and have it executed on a regular basis.
Describe the solution you'd like
Create a copy of the DBS schema from the CMSR database into INT2R
Describe alternatives you've considered
None.
It is a MUST DO!
Additional context
dbCopyfeatureDP tool- Scripts developed at CERNDataPump- Original Oracle Utility