RMAN-05507 standby control file checkpoint is more recent than duplication point-in-time
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:
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 1 |
Code:
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 |
Si 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.
Est-ce que c'est le CONTROLFILE AUTOBACKUP ON qui pose problème ?
commande rman backup
Code:
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;
} |
config rman
Code:
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'; |
Log rman
Code:
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:
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) |
