1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
|
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "AMBT" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
'/oradatD10/AMBT/redo11_AMBT.rlg',
'/oradatD10/AMBT/redo12_AMBT.rlg'
) SIZE 300M,
GROUP 2 (
'/oradatD10/AMBT/redo21_AMBT.rlg',
'/oradatD10/AMBT/redo22_AMBT.rlg'
) SIZE 300M,
GROUP 3 (
'/oradatD10/AMBT/redo31_AMBT.rlg',
'/oradatD10/AMBT/redo32_AMBT.rlg'
) SIZE 300M
DATAFILE
'/oradatD10/AMBT/SYSTEM01_AMBT.dbf',
'/oradatD10/AMBT/UNDO01_AMBT.dbf',
'/oradatD10/AMBT/SYSAUX01_AMBT.dbf',
'/oradatD10/AMBT/WORKSPACE01_AMBT.dbf',
'/oradatD10/AMBT/CFL_AMBT_01.dbf',
'/oradatD10/AMBT/HDRR52_AMBT_01.dbf',
'/oradatD10/AMBT/HDRR68_AMBT_01.dbf',
'/oradatD10/AMBT/HDRRFRANCE_AMBT_01.dbf',
'/oradatD10/AMBT/TDFVS_AMBT_01.dbf',
'/oradatD10/AMBT/TOWERFRANCE_AMBT_01.dbf',
'/oradatD10/AMBT/TOWERINTERNATIONAL_AMBT_01.dbf',
'/oradatD10/AMBT/TOWERMANAGEMENT_AMBT_01.dbf',
'/oradatD10/AMBT/TOWERPARTICIPATIONS_AMBT_01.dbf',
'/oradatD10/AMBT/TYROL1_AMBT_01.dbf',
'/oradatD10/AMBT/TYROL2_AMBT_01.dbf',
'/oradatD10/AMBT/ANTALISTV_AMBT_01.dbf',
'/oradatD10/AMBT/RADIOFR_AMBT_01.dbf',
'/oradatD10/AMBT/MEDIAMOBILE_AMBT_01.dbf',
'/oradatD10/AMBT/CJI_AMBT_01.dbf',
'/oradatD10/AMBT/ATRIUM1_AMBT_01.dbf',
'/oradatD10/AMBT/ATRIUM5_AMBT_01.dbf',
'/oradatD10/AMBT/ATRIUM6_AMBT_01.dbf',
'/oradatD10/AMBT/VOLTAIREIMAGE_AMBT_01.dbf',
'/oradatD10/AMBT/TDFI_AMBT_01.dbf',
'/oradatD10/AMBT/MOBILOC_AMBT_01.dbf',
'/oradatD10/AMBT/HDRRIDF_AMBT_01.dbf',
'/oradatD10/AMBT/IMMOISIS_AMBT_01.dbf',
'/oradatD10/AMBT/ESPNUM_AMBT_01.dbf',
'/oradatD10/AMBT/SMARTJOG_AMBT_01.dbf',
'/oradatD10/AMBT/MODELE_AMBT_01.dbf',
'/oradatD10/AMBT/IMMOGUYANE_AMBT_01.dbf',
'/oradatD10/AMBT/TOPAZEBELF_AMBT.dbf'
CHARACTER SET WE8ISO8859P1
;
RECOVER DATABASE USING BACKUP CONTROLFILE
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TMP ADD TEMPFILE '/oradatD10/AMBT/TMP01_AMBT.dbf'
SIZE 238026752 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 2048M; |
Partager