Skip to Main Content

Portuguese

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Restaurar banco 10g não carregou todos archives log

user605968Nov 29 2023

Boa noite, se alguém pudem auxiliar, abradeço….

Ultimo backup do oracle foi processado em 03/07/2023, as pastas (C:\oraclexe\app\oracle\flash_recovery_area e Archive) tem backup recente em 28/11/2023 com todos os arquivos de log desse período…

Foi necessário restaurar essa base mas os dados foram recuperados somente até 03/07/2023, os arquivos de log apos essa data não foram carregados na base… Como proceder para o backup utilizar esses logs pra atualizar a base até 28/11/2023 ?

Na pasta Archive tem 290 arquivos:

11/07/2023 14:05 39.434.240 ARC00001_1141566586.001
11/07/2023 22:00 51.761.664 ARC00002_1141566586.001
12/07/2023 09:06 7.782.400 ARC00003_1141566586.001
12/07/2023 09:06 116.224 ARC00004_1141566586.001
14/09/2022 12:04 42.980.864 ARC00005_1114861879.001
15/07/2023 00:00 51.761.152 ARC00005_1141566586.001
14/09/2022 13:11 855.040 ARC00006_1114861879.001
16/07/2023 02:00 51.759.616 ARC00006_1141566586.001
22/09/2022 00:01 49.038.336 ARC00007_1114861879.001
18/07/2023 07:35 51.761.664 ARC00007_1141566586.001
29/09/2022 08:25 51.761.664 ARC00008_1114861879.001
19/07/2023 07:41 12.633.600 ARC00008_1141566586.001
03/10/2022 17:24 29.785.600 ARC00009_1114861879.001
19/07/2023 16:35 6.811.648 ARC00009_1141566586.001
11/10/2022 07:47 51.761.664 ARC00010_1114861879.001
20/07/2023 08:37 4.307.968 ARC00010_1141566586.001
13/10/2022 17:14 23.596.544 ARC00011_1114861879.001
22/07/2023 00:00 51.761.664 ARC00011_1141566586.001
14/10/2022 07:33 365.056 ARC00012_1114861879.001
24/07/2023 07:54 37.342.208 ARC00012_1141566586.001
14/10/2022 10:24 7.002.624 ARC00013_1114861879.001
24/07/2023 22:00 51.761.664 ARC00013_1141566586.001
14/10/2022 15:54 4.551.680 ARC00014_1114861879.001
25/07/2023 07:22 10.675.200 ARC00014_1141566586.001
18/10/2022 07:39 13.720.064 ARC00015_1114861879.001
26/07/2023 22:00 51.761.664 ARC00015_1141566586.001
19/10/2022 07:41 12.422.144 ARC00016_1114861879.001
27/07/2023 22:00 51.761.664 ARC00016_1141566586.001
20/10/2022 07:46 8.540.160 ARC00017_1114861879.001
31/07/2023 08:01 51.761.664 ARC00017_1141566586.001
21/10/2022 07:20 13.357.568 ARC00018_1114861879.001
01/08/2023 07:41 39.558.656 ARC00018_1141566586.001
24/10/2022 07:43 14.736.896 ARC00019_1114861879.001
01/08/2023 22:00 51.757.568 ARC00019_1141566586.001
26/10/2022 07:30 28.769.280 ARC00020_1114861879.001
02/08/2023 07:50 21.261.312 ARC00020_1141566586.001
27/10/2022 09:58 12.350.464 ARC00021_1114861879.001
02/08/2023 08:29 820.224 ARC00021_1141566586.001
28/10/2022 08:07 12.988.928 ARC00022_1114861879.001
03/08/2023 18:04 51.761.664 ARC00022_1141566586.001
28/10/2022 13:17 4.250.112 ARC00023_1114861879.001
04/08/2023 16:01 51.761.664 ARC00023_1141566586.001
01/11/2022 08:06 17.692.672 ARC00024_1114861879.001
08/08/2023 00:00 51.759.104 ARC00024_1141566586.001
03/11/2022 07:32 14.175.232 ARC00025_1114861879.001
08/08/2023 16:54 11.333.120 ARC00025_1141566586.001
04/11/2022 07:48 15.055.872 ARC00026_1114861879.001
08/08/2023 19:51 2.467.840 ARC00026_1141566586.001
08/11/2022 07:22 25.340.928 ARC00027_1114861879.001
09/08/2023 09:30 46.769.664 ARC00027_1141566586.001
08/11/2022 22:00 51.758.592 ARC00028_1114861879.001
09/08/2023 15:06 5.498.368 ARC00028_1141566586.001
09/11/2022 07:26 14.714.880 ARC00029_1114861879.001
09/08/2023 15:10 240.640 ARC00029_1141566586.001
10/11/2022 07:38 40.748.544 ARC00030_1114861879.001
10/08/2023 22:00 51.761.664 ARC00030_1141566586.001
11/11/2022 07:51 32.689.152 ARC00031_1114861879.001
14/08/2023 08:26 51.761.664 ARC00031_1141566586.001
18/11/2022 07:46 51.759.104 ARC00032_1114861879.001
16/08/2023 23:33 51.761.664 ARC00032_1141566586.001
18/11/2022 17:14 10.832.384 ARC00033_1114861879.001
17/08/2023 07:32 8.538.624 ARC00033_1141566586.001
21/11/2022 07:38 58.880 ARC00034_1114861879.001
17/08/2023 17:22 8.126.464 ARC00034_1141566586.001
22/11/2022 13:19 19.497.984 ARC00035_1114861879.001
18/08/2023 07:59 53.760 ARC00035_1141566586.001
22/11/2022 14:53 815.616 ARC00036_1114861879.001
18/08/2023 14:57 16.419.840 ARC00036_1141566586.001
23/11/2022 07:55 43.316.736 ARC00037_1114861879.001
19/08/2023 06:00 51.759.616 ARC00037_1141566586.001
24/11/2022 07:41 31.453.184 ARC00038_1114861879.001
21/08/2023 07:54 1.519.104 ARC00038_1141566586.001
24/11/2022 14:56 6.000.128 ARC00039_1114861879.001
22/08/2023 09:35 34.733.056 ARC00039_1141566586.001
26/11/2022 09:00 16.676.352 ARC00040_1114861879.001
23/08/2023 13:00 51.753.984 ARC00040_1141566586.001
28/11/2022 07:59 49.470.976 ARC00041_1114861879.001
28/08/2023 08:14 51.761.664 ARC00041_1141566586.001
29/11/2022 07:37 32.806.912 ARC00042_1114861879.001
29/08/2023 14:01 51.757.568 ARC00042_1141566586.001
29/11/2022 11:35 5.225.984 ARC00043_1114861879.001
31/08/2023 23:22 51.761.664 ARC00043_1141566586.001
01/12/2022 07:38 21.309.952 ARC00044_1114861879.001
01/09/2023 15:28 14.624.256 ARC00044_1141566586.001
01/12/2022 08:57 1.546.752 ARC00045_1114861879.001
01/09/2023 15:34 506.880 ARC00045_1141566586.001
01/12/2022 22:00 51.760.128 ARC00046_1114861879.001
01/09/2023 16:52 1.287.680 ARC00046_1141566586.001
02/12/2022 08:00 11.236.352 ARC00047_1114861879.001
01/09/2023 23:22 51.761.664 ARC00047_1141566586.001
05/12/2022 08:05 6.547.968 ARC00048_1114861879.001
02/09/2023 23:24 51.761.664 ARC00048_1141566586.001
06/12/2022 07:37 15.790.080 ARC00049_1114861879.001
04/09/2023 08:34 41.159.168 ARC00049_1141566586.001
08/12/2022 07:20 35.229.184 ARC00050_1114861879.001
05/09/2023 17:00 51.761.664 ARC00050_1141566586.001
08/12/2022 22:00 51.761.664 ARC00051_1114861879.001
08/09/2023 08:19 51.761.664 ARC00051_1141566586.001
09/12/2022 07:45 10.243.584 ARC00052_1114861879.001
11/09/2023 07:52 15.912.960 ARC00052_1141566586.001
12/12/2022 07:38 30.180.352 ARC00053_1114861879.001
11/09/2023 08:22 51.761.664 ARC00053_1141566586.001
12/12/2022 22:00 51.761.664 ARC00054_1114861879.001
12/09/2023 08:51 39.846.912 ARC00054_1141566586.001
13/12/2022 07:49 10.561.024 ARC00055_1114861879.001
12/09/2023 18:45 7.497.728 ARC00055_1141566586.001
14/12/2022 07:19 41.017.344 ARC00056_1114861879.001
13/09/2023 22:00 51.761.664 ARC00056_1141566586.001
14/12/2022 18:57 7.986.688 ARC00057_1114861879.001
15/09/2023 07:00 51.761.664 ARC00057_1141566586.001
15/12/2022 07:19 26.448.896 ARC00058_1114861879.001
15/09/2023 13:51 4.776.960 ARC00058_1141566586.001
16/12/2022 07:45 35.275.264 ARC00059_1114861879.001
19/09/2023 20:23 51.761.664 ARC00059_1141566586.001
21/12/2022 07:42 39.360.000 ARC00060_1114861879.001
21/09/2023 16:00 51.758.080 ARC00060_1141566586.001
21/12/2022 12:57 8.544.768 ARC00061_1114861879.001
25/09/2023 09:06 47.502.336 ARC00061_1141566586.001
23/12/2022 07:43 14.247.936 ARC00062_1114861879.001
26/09/2023 04:00 51.760.128 ARC00062_1141566586.001
23/12/2022 11:09 8.756.224 ARC00063_1114861879.001
28/09/2023 12:00 51.761.664 ARC00063_1141566586.001
02/10/2023 23:34 51.761.664 ARC00064_1141566586.001
04/10/2023 07:50 51.761.664 ARC00065_1141566586.001
05/10/2023 23:09 51.761.664 ARC00066_1141566586.001
09/10/2023 07:45 14.062.080 ARC00067_1141566586.001
09/10/2023 22:00 51.761.664 ARC00068_1141566586.001
10/10/2023 22:00 51.761.664 ARC00069_1141566586.001
11/10/2023 04:51 23.800.832 ARC00070_1141566586.001
11/10/2023 18:38 9.721.856 ARC00071_1141566586.001
12/10/2023 22:00 51.761.664 ARC00072_1141566586.001
13/10/2023 13:08 36.144.640 ARC00073_1141566586.001
17/10/2023 05:00 51.761.664 ARC00074_1141566586.001
19/10/2023 13:01 51.760.128 ARC00075_1141566586.001
20/10/2023 13:10 23.940.608 ARC00076_1141566586.001
23/10/2023 08:13 3.549.696 ARC00077_1141566586.001
23/10/2023 09:43 9.092.096 ARC00078_1141566586.001
24/10/2023 16:00 51.760.640 ARC00079_1141566586.001
25/10/2023 22:00 51.761.664 ARC00080_1141566586.001
26/10/2023 22:00 51.761.664 ARC00081_1141566586.001
30/10/2023 07:58 45.112.320 ARC00082_1141566586.001
01/11/2023 07:37 40.089.600 ARC00083_1141566586.001
01/11/2023 22:08 51.761.664 ARC00084_1141566586.001
03/11/2023 04:00 51.761.664 ARC00085_1141566586.001
04/11/2023 21:00 51.759.616 ARC00086_1141566586.001
06/11/2023 08:05 27.241.984 ARC00087_1141566586.001
07/11/2023 11:35 51.761.664 ARC00088_1141566586.001
08/11/2023 21:08 51.761.664 ARC00089_1141566586.001
09/11/2023 22:00 51.761.664 ARC00090_1141566586.001
21/01/2023 16:06 41.623.552 ARC00091_1114861879.001
10/11/2023 21:10 51.761.664 ARC00091_1141566586.001
21/01/2023 16:07 1.024 ARC00092_1114861879.001
11/11/2023 19:00 51.759.616 ARC00092_1141566586.001
23/01/2023 07:58 8.192 ARC00093_1114861879.001
13/11/2023 01:01 51.755.008 ARC00093_1141566586.001
24/01/2023 07:27 30.190.080 ARC00094_1114861879.001
13/11/2023 22:12 51.761.664 ARC00094_1141566586.001
25/01/2023 07:35 32.814.592 ARC00095_1114861879.001
14/11/2023 20:39 15.871.488 ARC00095_1141566586.001
25/01/2023 13:10 5.026.816 ARC00096_1114861879.001
15/11/2023 22:00 51.761.664 ARC00096_1141566586.001
26/01/2023 07:33 41.402.880 ARC00097_1114861879.001
16/11/2023 22:00 51.761.664 ARC00097_1141566586.001
27/01/2023 07:50 33.723.904 ARC00098_1114861879.001
17/11/2023 22:00 51.761.152 ARC00098_1141566586.001
30/01/2023 07:58 16.440.320 ARC00099_1114861879.001
18/11/2023 20:15 51.761.664 ARC00099_1141566586.001
20/11/2023 22:00 51.761.664 ARC00100_1141566586.001
21/11/2023 07:36 21.058.048 ARC00101_1141566586.001
22/11/2023 07:38 33.562.624 ARC00102_1141566586.001
23/11/2023 07:45 40.342.528 ARC00103_1141566586.001
24/11/2023 07:33 39.085.056 ARC00104_1141566586.001
27/11/2023 07:59 7.832.576 ARC00105_1141566586.001
27/11/2023 08:29 51.761.664 ARC00106_1141566586.001
27/11/2023 09:04 12.470.784 ARC00107_1141566586.001
27/11/2023 10:14 933.888 ARC00108_1141566586.001
01/03/2023 21:24 24.629.760 ARC00127_1114861879.001
01/03/2023 21:24 1.024 ARC00128_1114861879.001
02/03/2023 07:40 1.867.264 ARC00129_1114861879.001
02/03/2023 22:11 51.761.664 ARC00130_1114861879.001
03/03/2023 08:02 16.412.672 ARC00131_1114861879.001
06/03/2023 12:00 51.759.104 ARC00132_1114861879.001
07/03/2023 07:43 7.547.904 ARC00133_1114861879.001
07/03/2023 10:46 2.977.280 ARC00134_1114861879.001
07/03/2023 10:46 1.024 ARC00135_1114861879.001
07/03/2023 22:13 51.761.664 ARC00136_1114861879.001
08/03/2023 08:13 4.858.368 ARC00137_1114861879.001
09/03/2023 07:45 34.929.664 ARC00138_1114861879.001
10/03/2023 07:28 48.540.160 ARC00139_1114861879.001
14/03/2023 07:45 39.594.496 ARC00140_1114861879.001
15/03/2023 07:49 50.014.720 ARC00141_1114861879.001
15/03/2023 08:24 4.424.704 ARC00142_1114861879.001
16/03/2023 07:47 27.801.088 ARC00143_1114861879.001
17/03/2023 07:49 38.031.872 ARC00144_1114861879.001
20/03/2023 07:59 30.795.264 ARC00145_1114861879.001
20/03/2023 22:00 51.758.080 ARC00146_1114861879.001
21/03/2023 07:27 2.749.440 ARC00147_1114861879.001
22/03/2023 07:43 39.863.808 ARC00148_1114861879.001
23/03/2023 07:40 39.634.432 ARC00149_1114861879.001
24/03/2023 07:52 37.997.056 ARC00150_1114861879.001
27/03/2023 10:33 35.056.640 ARC00151_1114861879.001
29/03/2023 07:40 29.497.856 ARC00152_1114861879.001
29/03/2023 22:11 51.761.664 ARC00153_1114861879.001
30/03/2023 07:35 5.005.824 ARC00154_1114861879.001
31/03/2023 07:31 43.132.416 ARC00155_1114861879.001
04/04/2023 07:30 39.683.072 ARC00156_1114861879.001
05/04/2023 07:34 42.878.976 ARC00157_1114861879.001
10/04/2023 07:55 28.007.936 ARC00158_1114861879.001
10/04/2023 17:00 51.758.080 ARC00159_1114861879.001
11/04/2023 07:58 24.084.992 ARC00160_1114861879.001
12/04/2023 08:09 25.264.640 ARC00161_1114861879.001
12/04/2023 17:24 13.664.768 ARC00162_1114861879.001
13/04/2023 07:48 345.600 ARC00163_1114861879.001
14/04/2023 08:02 48.425.984 ARC00164_1114861879.001
17/04/2023 07:51 30.299.136 ARC00165_1114861879.001
17/04/2023 22:00 51.755.520 ARC00166_1114861879.001
18/04/2023 07:45 7.935.488 ARC00167_1114861879.001
19/04/2023 07:40 41.945.088 ARC00168_1114861879.001
20/04/2023 07:36 28.387.328 ARC00169_1114861879.001
24/04/2023 08:00 51.761.664 ARC00170_1114861879.001
24/04/2023 17:28 14.928.384 ARC00171_1114861879.001
26/04/2023 07:49 15.246.848 ARC00172_1114861879.001
27/04/2023 07:30 41.848.320 ARC00173_1114861879.001
27/04/2023 09:28 5.534.208 ARC00174_1114861879.001
28/04/2023 07:33 30.256.640 ARC00175_1114861879.001
02/05/2023 07:57 11.725.824 ARC00176_1114861879.001
02/05/2023 22:00 51.761.664 ARC00177_1114861879.001
03/05/2023 07:33 17.047.040 ARC00178_1114861879.001
04/05/2023 07:45 38.482.432 ARC00179_1114861879.001
05/05/2023 07:51 38.281.728 ARC00180_1114861879.001
09/05/2023 07:35 42.576.896 ARC00181_1114861879.001
10/05/2023 07:49 39.447.552 ARC00182_1114861879.001
10/05/2023 09:33 5.223.936 ARC00183_1114861879.001
11/05/2023 07:51 21.675.520 ARC00184_1114861879.001
12/05/2023 07:55 44.999.680 ARC00185_1114861879.001
15/05/2023 15:19 39.216.640 ARC00186_1114861879.001
16/05/2023 07:49 28.141.056 ARC00187_1114861879.001
17/05/2023 13:12 40.274.944 ARC00188_1114861879.001
18/05/2023 07:55 27.778.560 ARC00189_1114861879.001
19/05/2023 07:45 29.677.568 ARC00190_1114861879.001
19/05/2023 10:23 13.913.088 ARC00191_1114861879.001
19/05/2023 10:23 1.024 ARC00192_1114861879.001
22/05/2023 07:48 5.042.176 ARC00193_1114861879.001
23/05/2023 07:58 50.756.096 ARC00194_1114861879.001
24/05/2023 07:50 33.593.856 ARC00195_1114861879.001
25/05/2023 07:22 33.444.864 ARC00196_1114861879.001
25/05/2023 09:21 4.235.776 ARC00197_1114861879.001
29/05/2023 15:01 51.761.664 ARC00198_1114861879.001
31/05/2023 07:22 19.004.928 ARC00199_1114861879.001
31/05/2023 22:00 51.761.664 ARC00200_1114861879.001
01/06/2023 07:39 2.497.024 ARC00201_1114861879.001
02/06/2023 07:28 32.217.088 ARC00202_1114861879.001
05/06/2023 07:52 42.439.168 ARC00203_1114861879.001
05/06/2023 22:00 51.761.152 ARC00204_1114861879.001
06/06/2023 07:32 6.395.392 ARC00205_1114861879.001
07/06/2023 07:43 26.326.528 ARC00206_1114861879.001
09/06/2023 07:21 36.176.384 ARC00207_1114861879.001
12/06/2023 13:01 51.761.664 ARC00208_1114861879.001
13/06/2023 07:30 7.223.808 ARC00209_1114861879.001
14/06/2023 07:31 47.529.472 ARC00210_1114861879.001
14/06/2023 07:55 694.272 ARC00211_1114861879.001
15/06/2023 07:34 28.363.264 ARC00212_1114861879.001
16/06/2023 07:39 28.966.912 ARC00213_1114861879.001
19/06/2023 07:48 38.529.024 ARC00214_1114861879.001
19/06/2023 22:00 51.760.640 ARC00215_1114861879.001
20/06/2023 07:41 4.605.440 ARC00216_1114861879.001
21/06/2023 07:24 30.581.248 ARC00217_1114861879.001
21/06/2023 07:34 59.392 ARC00218_1114861879.001
22/06/2023 07:25 33.344.512 ARC00219_1114861879.001
26/06/2023 08:07 37.902.848 ARC00220_1114861879.001
26/06/2023 22:00 51.761.664 ARC00221_1114861879.001
27/06/2023 07:23 8.424.448 ARC00222_1114861879.001
28/06/2023 07:47 39.294.976 ARC00223_1114861879.001
29/06/2023 07:42 38.133.760 ARC00224_1114861879.001
30/06/2023 07:32 30.344.192 ARC00225_1114861879.001
30/06/2023 13:55 11.316.224 ARC00226_1114861879.001
30/06/2023 14:13 667.648 ARC00227_1114861879.001
03/07/2023 07:50 22.695.936 ARC00228_1114861879.001
03/07/2023 07:57 1.317.376 ARC00229_1114861879.001
03/07/2023 10:28 31.201.280 ARC00230_1114861879.001
03/07/2023 10:43 69.120 ARC00231_1114861879.001
03/07/2023 11:00 532.992 ARC00232_1114861879.001
03/07/2023 11:00 1.024 ARC00233_1114861879.001
03/07/2023 13:17 2.527.744 ARC00234_1114861879.001
03/07/2023 14:55 1.699.328 ARC00235_1114861879.001
04/07/2023 09:28 37.813.248 ARC00236_1114861879.001
05/07/2023 10:00 51.761.664 ARC00237_1114861879.001
06/07/2023 07:58 42.013.696 ARC00238_1114861879.001
07/07/2023 13:49 8.177.152 ARC00239_1114861879.001
07/07/2023 13:49 48.720.384 ARC00240_1114861879.001

Comments
Post Details
Added on Nov 29 2023
0 comments
22 views