Bonjour,
J'ai un souci avec mes rman backups, j'ai du recréer une standby, et j'ai eu l'erreur RMAN-05507: standby control file checkpoint (52894782200) is more recent than duplication point-in-time (52894782107)
J'ai pu m'en sortir en copiant le fichier archivelog qui a été généré après le rman.
Mais du coup, ça veut dire que mes backups rman ne me permettent pas de recréer une base.. et ça c'est problématique.
J'ai pourtant suivi les indications données par des gens sur le net qui ont fait des pdf.. donc je me suis dit que c'était fiable à 100%
Est-ce que vous avez une explication et une recommandation pour être sûr d'avoir un rman backup qui permet de recréer une base.
Y a-t-il une commande pour vérifier ?
Voici les diverses commandes et logs et analyses de mon problème
J'ai récupéré les heures des SCN
SCN_TO_TIMESTAMP(52894782107) : 09/09/2018 23:35:29.000000000
SCN_TO_TIMESTAMP(52894782200) : 09/09/2018 23:36:41.000000000
Et les 2 archive logs (le dernier qui a été rmané, et le suivant)
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2 SELECT recid, sequence#, first_change#, first_time, next_change#, next_time, creator, completion_time, BLOCKS, block_size FROM v$archived_log WHERE sequence# in (245915, 245916) ORDER BY 1Si je ne me trompe pas, Rman commence par faire son backup, puis fait un switch logfile et archive ensuite les archivelogs généré depuis le début du backup.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3 RECID SEQUENCE# FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME CREATOR COMPLETION_TIME BLOCKS BLOCK_SIZE 487245 245915 52894782001 09/09/2018 23:33:29 52894782107 09/09/2018 23:35:32 FGRD 09/09/2018 23:35:32 91 512 487246 245916 52894782107 09/09/2018 23:35:32 52894783123 09/09/2018 23:53:30 ARCH 09/09/2018 23:53:30 1065 512
Est-ce que c'est le CONTROLFILE AUTOBACKUP ON qui pose problème ?
commande rman backup
config rman
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11 CONNECT TARGET / run { crosscheck backup ; crosscheck archivelog all ; backup incremental level 0 database plus archivelog not backed up 1 times; change archivelog until time 'sysdate-2' delete; delete force noprompt obsolete; backup spfile; backup current controlfile; }
Log rman
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/ora11/rmanbackup/%d_%F'; CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/home/ora11/rmanbackup/%d_%T_%U'; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/home/ora11/rmanbackup/snapcf_mcm.f';
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78 ... ... Fin backup datas channel ORA_DISK_1: finished piece 1 at 09/09/2018 23:35:31 piece handle=/home/ora11/rmanbackup/MCM_20180909_tktcnbas_1_1 tag=TAG20180909T180654 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:10:15 Finished backup at 09/09/2018 23:35:31 Starting backup at 09/09/2018 23:35:32 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=245882 RECID=487212 STAMP=986407993 ... input archived log thread=1 sequence=245915 RECID=487245 STAMP=986427332 channel ORA_DISK_1: starting piece 1 at 09/09/2018 23:35:33 channel ORA_DISK_1: finished piece 1 at 09/09/2018 23:36:18 piece handle=/home/ora11/rmanbackup/MCM_20180909_tltcnbu4_1_1 tag=TAG20180909T233532 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45 Finished backup at 09/09/2018 23:36:18 Starting Control File and SPFILE Autobackup at 09/09/2018 23:36:18 piece handle=/home/ora11/rmanbackup/MCM_c-423707768-20180909-00 comment=NONE Finished Control File and SPFILE Autobackup at 09/09/2018 23:36:21 released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1666 device type=DISK deleted archived log archived log file name=/home/ora11/archlog/mcm/archlocal/1_245491_814372600.dbf RECID=486789 STAMP=986151402 ... deleted archived log archived log file name=/home/ora11/archlog/mcm/archlocal/1_245655_814372600.dbf RECID=486985 STAMP=986255492 Deleted 197 objects RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 7 days using channel ORA_DISK_1 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 21195 26/08/2018 19:20:59 Backup Piece 21195 26/08/2018 19:20:59 /home/ora11/rmanbackup/MCM_20180826_mqtbhre0_1_1 ... deleted backup piece backup piece handle=/home/ora11/rmanbackup/MCM_20180903_qstc714g_1_1 RECID=21325 STAMP=985891984 Deleted 77 objects Starting backup at 09/09/2018 23:36:40 using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 09/09/2018 23:36:40 channel ORA_DISK_1: finished piece 1 at 09/09/2018 23:36:41 piece handle=/home/ora11/rmanbackup/MCM_20180909_tntcnc08_1_1 tag=TAG20180909T233640 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 09/09/2018 23:36:41 Starting backup at 09/09/2018 23:36:41 using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 09/09/2018 23:36:42 channel ORA_DISK_1: finished piece 1 at 09/09/2018 23:36:43 piece handle=/home/ora11/rmanbackup/MCM_20180909_totcnc09_1_1 tag=TAG20180909T233641 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 09/09/2018 23:36:43 Starting Control File and SPFILE Autobackup at 09/09/2018 23:36:43 piece handle=/home/ora11/rmanbackup/MCM_c-423707768-20180909-01 comment=NONE Finished Control File and SPFILE Autobackup at 09/09/2018 23:36:46 Recovery Manager complete.
Recréation Standby
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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 RMAN> DUPLICATE DATABASE FOR STANDBY BACKUP LOCATION '/home/ora11/rmanbackup/' NOFILENAMECHECK DORECOVER; Starting Duplicate Db at 10/09/2018 11:04:11 contents of Memory Script: { restore clone standby controlfile from '/home/ora11/rmanbackup/MCM_c-423707768-20180909-01'; } executing Memory Script Starting restore at 10/09/2018 11:04:19 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=1143 device type=DISK channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/home/ora11/data/mcm/control01.ctl output file name=/home/ora11/index/mcm/control02.ctl Finished restore at 10/09/2018 11:04:20 contents of Memory Script: { sql clone 'alter database mount standby database'; } executing Memory Script sql statement: alter database mount standby database released channel: ORA_AUX_DISK_1 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=1143 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 09/10/2018 11:04:42 RMAN-05501: aborting duplication of target database RMAN-05507: standby control file checkpoint (52894782200) is more recent than duplication point-in-time (52894782107)
Partager