Skip to Main Content

Portuguese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
131 views