ReSQL.ru
     
powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Мобильная версия    Контакт    Правила    FAQ    Помощь
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр
Форумы / Oracle [игнор отключен] [закрыт для гостей] / rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
24 сообщений из 24, страница 1 из 1
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39121248
BadRobot
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
BadRobot
Гость
Oracle 11.2.3 64-bit Linux
Сделал бэкап RMAN командой

backup as compressed backupset database format '/XXXXXX/AR_20151118_%U.bkp' tag 'AR_ARH20151118' keep until time sysdate+5;

Бэкап прошел нормально

 
Код: plsql
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.
Starting backup at 25-NOV-15
current log archived

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=230 device type=DISK
backup will be obsolete on date 02-DEC-15
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=XXXXXX.DBF
input datafile file number=00005 name=XXXXXX.DBF
input datafile file number=00007 name=XXXXXX.DBF
---------
channel ORA_DISK_1: starting piece 1 at 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=/XXXXXX_20151125_iuqn5qsg_1_1.bkp tag=AR20151125 comment=NONE
channel ORA_DISK_1: starting piece 2 at 25-NOV-15
channel ORA_DISK_1: finished piece 2 at 25-NOV-15
piece handle=XXXXXX_iuqn5qsg_2_1.bkp tag=ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 02:03:21
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=XXXXXX/V81C_INDEX_BIG.DBF
channel ORA_DISK_1: starting piece 1 at 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=XXXXXX_20151125_j3qn623p_1_1.bkp tag=XXXXXX_ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

using channel ORA_DISK_1
backup will be obsolete on date 02-DEC-15
archived logs required to recover from this backup will be backed up
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 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=XXXXXX_20151125_j4qn623r_1_1.bkp tag=ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

current log archived
using channel ORA_DISK_1
backup will be obsolete on date 02-DEC-15
archived logs required to recover from this backup will be backed up
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=27837 RECID=27789 STAMP=896730619
input archived log thread=1 sequence=27838 RECID=27790 STAMP=896730927
input archived log thread=1 sequence=27839 RECID=27791 STAMP=896731260
channel ORA_DISK_1: starting piece 1 at 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=/XXXXXX_20151125_j5qn623u_1_1.bkp tag=ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

using channel ORA_DISK_1
backup will be obsolete on date 02-DEC-15
archived logs required to recover from this backup will be backed up
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 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=/XXXXXX_20151125_j6qn6243_1_1.bkp tag=ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-NOV-15

RMAN> exit



Перенес эти бэкапы на другой хост и восстанавливаю

restore проходит нормально, вот recover требует архивный лог 27836

Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
run{
allocate channel ch1 type disk;
restore database from tag 'ORAUPP_ARH20151125';
release channel ch1;
}

run{
allocate channel ch1 type disk;
recover database from tag 'ORAUPP_ARH20151125';
release channel ch1;
}





Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/XXXXXX/system01.dbf'

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/05/2015 13:23:05
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 27836 and starting SCN of 565421795 found to restore



Ав бэкапе лежат логи только
List of Archived Logs in backup set 18741
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 27837 565473450 25-NOV-15 565520482 25-NOV-15
1 27838 565520482 25-NOV-15 565524828 25-NOV-15
1 27839 565524828 25-NOV-15 565531061 25-NOV-15

Почему он требует этот лог - вроде ведь должен все нужные логи рман положить в бэкап?
...
Рейтинг: 0 / 0
05.12.2015, 10:40
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39121519
ctlvv
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ctlvv
Гость
BadRobot,
А контрольник какой используется
?
...
Рейтинг: 0 / 0
06.12.2015, 00:36
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39121548
BadRobot
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
BadRobot
Гость
Контрольник используется тот, который вместе с бэкапом делается. Я его восстанавливаю командой restore controlfile from и указываю имя файла с бэкапом
...
Рейтинг: 0 / 0
06.12.2015, 08:12
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39121665
ctlv
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ctlv
Гость
BadRobot,

> keep until time sysdate+5;

А когда восстанавливаете? Может нужный бэкап был удален по obsolete критерию?
...
Рейтинг: 0 / 0
06.12.2015, 15:53
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39121805
BadRobot
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
BadRobot
Гость
Нет, этот бэкап я делал в отдельную папку и скопировал на другую машину сразу же после бэкапа. Проблема в том, что оракл пишет, что сохранит все архивлоги, нужные для восстановления с этого бэкапа, но один лог 27836 не кладёт в бэкап, хотя кладёт туда последующие 3 лога - 27837, 27838, 27839 - они сформированы во время бэкапа и явно нужны, но почему также нужный 27836 лог не бэкапит? Хотя написано, что 11 оракл сам заботится о том, чтобы все нужные файлы присутствовали в бэкапе, сделанном командой backup ... Keep.получается никому нельзя верить (((
...
Рейтинг: 0 / 0
06.12.2015, 21:43
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39121806
Фотография Vadim Lejnin
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Vadim Lejnin
Участник
Судя по всему один из багов этой версии
Смотрите например duplicate from active database
...
Рейтинг: 0 / 0
06.12.2015, 21:47
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39121833
ctlv
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ctlv
Гость
BadRobot,
Странно, почему тогда RECOVER succeeded, как будто что-то делал








,.,
...
Рейтинг: 0 / 0
07.12.2015, 00:08
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39122201
0_011_11
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
0_011_11
Гость
BadRobotOracle 11.2.3 64-bit Linux
Сделал бэкап RMAN командой

backup as compressed backupset database format '/XXXXXX/AR_20151118_%U.bkp' tag 'AR_ARH20151118' keep until time sysdate+5;

Бэкап прошел нормально

 
Код: plsql
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.
Starting backup at 25-NOV-15
current log archived

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=230 device type=DISK
backup will be obsolete on date 02-DEC-15
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=XXXXXX.DBF
input datafile file number=00005 name=XXXXXX.DBF
input datafile file number=00007 name=XXXXXX.DBF
---------
channel ORA_DISK_1: starting piece 1 at 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=/XXXXXX_20151125_iuqn5qsg_1_1.bkp tag=AR20151125 comment=NONE
channel ORA_DISK_1: starting piece 2 at 25-NOV-15
channel ORA_DISK_1: finished piece 2 at 25-NOV-15
piece handle=XXXXXX_iuqn5qsg_2_1.bkp tag=ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 02:03:21
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=XXXXXX/V81C_INDEX_BIG.DBF
channel ORA_DISK_1: starting piece 1 at 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=XXXXXX_20151125_j3qn623p_1_1.bkp tag=XXXXXX_ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

using channel ORA_DISK_1
backup will be obsolete on date 02-DEC-15
archived logs required to recover from this backup will be backed up
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 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=XXXXXX_20151125_j4qn623r_1_1.bkp tag=ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

current log archived
using channel ORA_DISK_1
backup will be obsolete on date 02-DEC-15
archived logs required to recover from this backup will be backed up
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=27837 RECID=27789 STAMP=896730619
input archived log thread=1 sequence=27838 RECID=27790 STAMP=896730927
input archived log thread=1 sequence=27839 RECID=27791 STAMP=896731260
channel ORA_DISK_1: starting piece 1 at 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=/XXXXXX_20151125_j5qn623u_1_1.bkp tag=ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

using channel ORA_DISK_1
backup will be obsolete on date 02-DEC-15
archived logs required to recover from this backup will be backed up
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 25-NOV-15
channel ORA_DISK_1: finished piece 1 at 25-NOV-15
piece handle=/XXXXXX_20151125_j6qn6243_1_1.bkp tag=ARH20151125 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-NOV-15

RMAN> exit



Перенес эти бэкапы на другой хост и восстанавливаю

restore проходит нормально, вот recover требует архивный лог 27836

Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
run{
allocate channel ch1 type disk;
restore database from tag 'ORAUPP_ARH20151125';
release channel ch1;
}

run{
allocate channel ch1 type disk;
recover database from tag 'ORAUPP_ARH20151125';
release channel ch1;
}





Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/XXXXXX/system01.dbf'

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/05/2015 13:23:05
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 27836 and starting SCN of 565421795 found to restore



Ав бэкапе лежат логи только
List of Archived Logs in backup set 18741
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 27837 565473450 25-NOV-15 565520482 25-NOV-15
1 27838 565520482 25-NOV-15 565524828 25-NOV-15
1 27839 565524828 25-NOV-15 565531061 25-NOV-15

Почему он требует этот лог - вроде ведь должен все нужные логи рман положить в бэкап?

Лог то хоть от какого бэкапа? Где в доке написано, что backup as compressed backupset database бэкапит archivelog?
...
Рейтинг: 0 / 0
07.12.2015, 12:43
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39122231
ctlv
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ctlv
Гость
0_011_11,
Сами-то доку смотрели?
When KEEP is specified, RMAN creates multiple backup sets. RMAN backs up datafiles, archived redo logs, the control file, and the server parameter file
...
Рейтинг: 0 / 0
07.12.2015, 12:59
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39123730
Hrundel
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Hrundel
Гость
ctlv,



Точно не бэкапы?

backup as compressed backupset database format '/XXXXXX/AR_20151118_%U.bkp' tag ' AR_ARH20151118' keep until time sysdate+5;

run{
allocate channel ch1 type disk;
restore database from tag 'ORAUPP_ARH20151125';
release channel ch1;
}

run{
allocate channel ch1 type disk;
recover database from tag 'ORAUPP_ARH20151125';
release channel ch1;
}
...
Рейтинг: 0 / 0
09.12.2015, 06:12
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39123742
BadRobot
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
BadRobot
Гость
Hrundel,

нет, всё верно, я просто восстанавливал с двух аналогичных бэкапов разных дат и обе дали такую ошибку - когда писал в форум, то по запарке указал команду восстановления от позднего бэкапа, а лог от раннего. Но проблема, в любом, случае одна и та же.

А вообще, я очень надеялся на строчку лога

archived logs required to recover from this backup will be backed up

но, оказывается, что рман таки не все логи кладет нужные, хотя при бэкапе это обещает.
...
Рейтинг: 0 / 0
09.12.2015, 07:25
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39123764
Q.Tarantino
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Q.Tarantino
Участник
BadRobotно, оказывается, что рман таки не все логи кладет нужные, хотя при бэкапе это обещает.
...
Рейтинг: 0 / 0
09.12.2015, 08:50
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39123841
ctlv
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ctlv
Гость
BadRobot,
Я протестировал на 10.2.0.4 , там в дополнение к KEEP указывается LOG.
Так вот в бэкапсете вообще ни одного архивного журнала в течение бэкапа не оказывается.
...
Рейтинг: 0 / 0
09.12.2015, 10:15
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39123925
BadRobot
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
BadRobot
Гость
ctlv,
 

все верно, вот что написано у Алапати
Иногда бывает необходимо подготовить резервную копию для долгосрочного хране-
ния. Преследуемой при этом целью является не обеспечение возможности однажды ис-
пользовать эту резервную копию для восстановления базы данных, а обеспечение воз-
можности применить эту резервную копию для восстановления того вида, в котором
данные находились на момент ее создания. Кроме того, создание подобной резервной
копии может требоваться исключительно для соблюдения установленных регуляторных
норм. Резервные копии подобного рода называются архивными резервными копиями
(archival backup) или долгосрочными резервными копиями (long-term backup) и, как пра-
вило, сохраняются на устройствах типа магнитных лент за пределами сайта.
Для создания долгосрочных резервных копий достаточно указать в команде BACKUP
конструкцию KEEP. Эта конструкция делает так, чтобы на резервную копию не распро-
странялось действие сконфигурированной в текущий момент политики сохранности
резервных копий (RETENTION POLICY). Она указывает утилите RMAN делать резервную
копию всех файлов данных, управляющего файла и файла SPFILE. Помимо этого, RMAN
также автоматически генерирует и резервную копию архивных журналов повторного
выполнения для обеспечения возможности восстановления базы данных до согласован-
ного состояния.


Это относится к 11g. В 11g нет опции LOGS/NOLOGS - там логи всегда включаются в бэкап при KEEP. В 10g включались все логи имеющиеся при указании опции LOGS

Improved Handling of Long-Term Backups

oracle-base.com
---
The BACKUP command includes a KEEP option to override the default retention policy and create an all-inclusive backup. The backups are considered all-inclusive because they contain all files necessary to restore and recover the database. This allows for long term backups, also known as archival backups.

In previous versions, an archival backup would include all archived redo logs present. Oracle 11g has improved this situation by retaining only the archived redo log files needed to make the backup consistent. This may represent a substantial space saving.
------

Типа в 10-ке нужно самому заботиться о нужных архивных логах, а 11-я должна сама с этим раобраться.
...
Рейтинг: 0 / 0
09.12.2015, 11:29
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39124037
Kamael
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Kamael
Участник
BadRobotHrundel,
но, оказывается, что рман таки не все логи кладет нужные, хотя при бэкапе это обещает.
Всё нормально. Может уже покажите полные логи
 
Код: plaintext
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.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
[oracle@ora12c ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 9 14:59:37 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL12C (DBID=727195943)

RMAN> backup as compressed backupset database format='/home/oracle/bkp/%U' tag='keep-backup' keep until time 'sysdate+5';

Starting backup at 09-DEC-15

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=377 device type=DISK
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=+ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/example.261.897920231
input datafile file number=00008 name=+ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/system.260.897920231
input datafile file number=00009 name=+ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/sysaux.259.897920231
input datafile file number=00010 name=+ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/users.266.897920231
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/0vqod22v_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+ORCL12/ORCL12C/DATAFILE/sysaux.265.897920295
input datafile file number=00001 name=+ORCL12/ORCL12C/DATAFILE/system.264.897920295
input datafile file number=00004 name=+ORCL12/ORCL12C/DATAFILE/undotbs1.263.897920295
input datafile file number=00006 name=+ORCL12/ORCL12C/DATAFILE/users.268.897920295
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/10qod25a_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=+ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/sysaux.267.897920391
input datafile file number=00005 name=+ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/system.274.897920391
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/11qod28k_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
current log archived

using channel ORA_DISK_1
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will be backed up
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=13 RECID=34 STAMP=898009029
input archived log thread=1 sequence=14 RECID=35 STAMP=898009069
input archived log thread=1 sequence=15 RECID=36 STAMP=898009186
input archived log thread=1 sequence=16 RECID=37 STAMP=898009189
input archived log thread=1 sequence=17 RECID=38 STAMP=898009192
input archived log thread=1 sequence=18 RECID=39 STAMP=898009193
input archived log thread=1 sequence=19 RECID=40 STAMP=898009195
input archived log thread=1 sequence=20 RECID=41 STAMP=898009224
input archived log thread=1 sequence=21 RECID=42 STAMP=898009225
input archived log thread=1 sequence=22 RECID=43 STAMP=898009229
input archived log thread=1 sequence=23 RECID=44 STAMP=898009231
input archived log thread=1 sequence=24 RECID=45 STAMP=898009234
input archived log thread=1 sequence=25 RECID=46 STAMP=898009246
input archived log thread=1 sequence=26 RECID=47 STAMP=898009250
input archived log thread=1 sequence=27 RECID=48 STAMP=898009252
input archived log thread=1 sequence=28 RECID=49 STAMP=898009255
input archived log thread=1 sequence=29 RECID=50 STAMP=898009258
input archived log thread=1 sequence=30 RECID=51 STAMP=898009281
input archived log thread=1 sequence=31 RECID=52 STAMP=898009282
input archived log thread=1 sequence=32 RECID=53 STAMP=898009285
input archived log thread=1 sequence=33 RECID=54 STAMP=898009288
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/12qod2a3_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15

using channel ORA_DISK_1
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will be backed up
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-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/13qod2aj_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

using channel ORA_DISK_1
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will be backed up
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-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/14qod2ak_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-15

RMAN> exit

Recovery Manager complete.

[oracle@ora12c ~]$ sqlplus / as sysdba
cd
SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 9 15:07:59 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> shutdown abort;
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
[oracle@ora12c ~]$ cd ./arc/
[oracle@ora12c arc]$ rm -rf ./*
[oracle@ora12c arc]$ . oraenv
ORACLE_SID = [orcl12c] ? +ASM
The Oracle base has been changed from /home/oracle/app/oracle to /grid

[oracle@ora12c arc]$ asmcmd
ASMCMD> ls
DATA/
ORCL12/
ASMCMD> cd orcl12
ASMCMD> ls
ORCL12C/
spfileorcl12c.ora
ASMCMD> rm -rf ./*
ASMCMD> ls
ASMCMD> exit
[oracle@ora12c arc]$ . oraenv
ORACLE_SID = [+ASM] ? orcl12c
The Oracle base has been changed from /grid to /home/oracle/app/oracle
[oracle@ora12c arc]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 9 15:12:03 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> set dbid=727195943;

executing command: SET DBID

RMAN> startup pfile='/home/oracle/pfile' nomount;

Oracle instance started

Total System Global Area     830472192 bytes

Fixed Size                     2929840 bytes
Variable Size                595594064 bytes
Database Buffers             226492416 bytes
Redo Buffers                   5455872 bytes

RMAN> restore controlfile from '/home/oracle/bkp/14qod2ak_1_1';

Starting restore at 09-DEC-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=243 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+ORCL12/ORCL12C/CONTROLFILE/current.256.898010305
output file name=+ORCL12/ORCL12C/CONTROLFILE/current.258.898010305
Finished restore at 09-DEC-15

RMAN> exit

Recovery Manager complete.

редактирую пути до контрольников в pfile.

[oracle@ora12c ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 9 15:22:04 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> startup pfile='/home/oracle/pfile' mount;

Oracle instance started
database mounted

Total System Global Area     830472192 bytes

Fixed Size                     2929840 bytes
Variable Size                595594064 bytes
Database Buffers             226492416 bytes
Redo Buffers                   5455872 bytes

RMAN> list backup;    

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
25      Full    219.25M    DISK        00:01:07     09-DEC-15      
        BP Key: 25   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/0vqod22v_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      
  List of Datafiles in backup set 25
  Container ID: 3, PDB Name: PDBORCL01
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  8       Full 3808763    09-DEC-15 +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/system.260.897920231
  9       Full 3808763    09-DEC-15 +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/sysaux.259.897920231
  10      Full 3808763    09-DEC-15 +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/users.266.897920231
  11      Full 3808763    09-DEC-15 +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/example.261.897920231

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26      Full    411.43M    DISK        00:01:38     09-DEC-15      
        BP Key: 26   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/10qod25a_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      
  List of Datafiles in backup set 26
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 3811156    09-DEC-15 +ORCL12/ORCL12C/DATAFILE/system.264.897920295
  3       Full 3811156    09-DEC-15 +ORCL12/ORCL12C/DATAFILE/sysaux.265.897920295
  4       Full 3811156    09-DEC-15 +ORCL12/ORCL12C/DATAFILE/undotbs1.263.897920295
  6       Full 3811156    09-DEC-15 +ORCL12/ORCL12C/DATAFILE/users.268.897920295

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27      Full    157.55M    DISK        00:00:35     09-DEC-15      
        BP Key: 27   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/11qod28k_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      
  List of Datafiles in backup set 27
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 1822033    25-NOV-15 +ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/system.274.897920391
  7       Full 1822033    25-NOV-15 +ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/sysaux.267.897920391

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
28      13.88M     DISK        00:00:15     09-DEC-15      
        BP Key: 28   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/12qod2a3_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      

  List of Archived Logs in backup set 28
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    13      3807374    09-DEC-15 3807883    09-DEC-15
  1    14      3807883    09-DEC-15 3807908    09-DEC-15
  1    15      3807908    09-DEC-15 3809059    09-DEC-15
  1    16      3809059    09-DEC-15 3809256    09-DEC-15
  1    17      3809256    09-DEC-15 3809423    09-DEC-15
  1    18      3809423    09-DEC-15 3809553    09-DEC-15
  1    19      3809553    09-DEC-15 3809661    09-DEC-15
  1    20      3809661    09-DEC-15 3809832    09-DEC-15
  1    21      3809832    09-DEC-15 3809954    09-DEC-15
  1    22      3809954    09-DEC-15 3810084    09-DEC-15
  1    23      3810084    09-DEC-15 3810209    09-DEC-15
  1    24      3810209    09-DEC-15 3810331    09-DEC-15
  1    25      3810331    09-DEC-15 3810524    09-DEC-15
  1    26      3810524    09-DEC-15 3810670    09-DEC-15
  1    27      3810670    09-DEC-15 3810857    09-DEC-15
  1    28      3810857    09-DEC-15 3810994    09-DEC-15
  1    29      3810994    09-DEC-15 3811146    09-DEC-15
  1    30      3811146    09-DEC-15 3811767    09-DEC-15
  1    31      3811767    09-DEC-15 3811873    09-DEC-15
  1    32      3811873    09-DEC-15 3812108    09-DEC-15
  1    33      3812108    09-DEC-15 3812236    09-DEC-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29      Full    80.00K     DISK        00:00:00     09-DEC-15      
        BP Key: 29   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/13qod2aj_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      
  SPFILE Included: Modification time: 09-DEC-15
  SPFILE db_unique_name: ORCL12C

RMAN> list backup of archivelog all;


List of Backup Sets
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
28      13.88M     DISK        00:00:15     09-DEC-15      
        BP Key: 28   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/12qod2a3_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      

  List of Archived Logs in backup set 28
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    13      3807374    09-DEC-15 3807883    09-DEC-15
  1    14      3807883    09-DEC-15 3807908    09-DEC-15
  1    15      3807908    09-DEC-15 3809059    09-DEC-15
  1    16      3809059    09-DEC-15 3809256    09-DEC-15
  1    17      3809256    09-DEC-15 3809423    09-DEC-15
  1    18      3809423    09-DEC-15 3809553    09-DEC-15
  1    19      3809553    09-DEC-15 3809661    09-DEC-15
  1    20      3809661    09-DEC-15 3809832    09-DEC-15
  1    21      3809832    09-DEC-15 3809954    09-DEC-15
  1    22      3809954    09-DEC-15 3810084    09-DEC-15
  1    23      3810084    09-DEC-15 3810209    09-DEC-15
  1    24      3810209    09-DEC-15 3810331    09-DEC-15
  1    25      3810331    09-DEC-15 3810524    09-DEC-15
  1    26      3810524    09-DEC-15 3810670    09-DEC-15
  1    27      3810670    09-DEC-15 3810857    09-DEC-15
  1    28      3810857    09-DEC-15 3810994    09-DEC-15
  1    29      3810994    09-DEC-15 3811146    09-DEC-15
  1    30      3811146    09-DEC-15 3811767    09-DEC-15
  1    31      3811767    09-DEC-15 3811873    09-DEC-15
  1    32      3811873    09-DEC-15 3812108    09-DEC-15
  1    33      3812108    09-DEC-15 3812236    09-DEC-15

RMAN> run
2> {
3> set until scn 3812235;
4> restore database;
5> recover database;
6> }

executing command: SET until clause

Starting restore at 09-DEC-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=243 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00008 to +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/system.266.898010667
channel ORA_DISK_1: restoring datafile 00009 to +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/sysaux.259.898010669
channel ORA_DISK_1: restoring datafile 00010 to +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/users.260.898010669
channel ORA_DISK_1: restoring datafile 00011 to +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/example.262.898010667
channel ORA_DISK_1: reading from backup piece /home/oracle/bkp/0vqod22v_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bkp/0vqod22v_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +ORCL12/ORCL12C/DATAFILE/system.268.898010733
channel ORA_DISK_1: restoring datafile 00003 to +ORCL12/ORCL12C/DATAFILE/sysaux.261.898010733
channel ORA_DISK_1: restoring datafile 00004 to +ORCL12/ORCL12C/DATAFILE/undotbs1.263.898010733
channel ORA_DISK_1: restoring datafile 00006 to +ORCL12/ORCL12C/DATAFILE/users.264.898010733
channel ORA_DISK_1: reading from backup piece /home/oracle/bkp/10qod25a_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bkp/10qod25a_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00005 to +ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/system.274.898010839
channel ORA_DISK_1: restoring datafile 00007 to +ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/sysaux.265.898010839
channel ORA_DISK_1: reading from backup piece /home/oracle/bkp/11qod28k_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bkp/11qod28k_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 09-DEC-15

Starting recover at 09-DEC-15
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=15
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=16
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=17
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=18
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=19
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=20
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=21
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=22
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=23
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=24
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=25
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=26
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=27
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=28
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=29
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=30
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=31
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=32
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33
channel ORA_DISK_1: reading from backup piece /home/oracle/bkp/12qod2a3_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bkp/12qod2a3_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=/home/oracle/arc/1_15_897920529.dbf thread=1 sequence=15
archived log file name=/home/oracle/arc/1_16_897920529.dbf thread=1 sequence=16
archived log file name=/home/oracle/arc/1_17_897920529.dbf thread=1 sequence=17
archived log file name=/home/oracle/arc/1_18_897920529.dbf thread=1 sequence=18
archived log file name=/home/oracle/arc/1_19_897920529.dbf thread=1 sequence=19
archived log file name=/home/oracle/arc/1_20_897920529.dbf thread=1 sequence=20
archived log file name=/home/oracle/arc/1_21_897920529.dbf thread=1 sequence=21
archived log file name=/home/oracle/arc/1_22_897920529.dbf thread=1 sequence=22
archived log file name=/home/oracle/arc/1_23_897920529.dbf thread=1 sequence=23
archived log file name=/home/oracle/arc/1_24_897920529.dbf thread=1 sequence=24
archived log file name=/home/oracle/arc/1_25_897920529.dbf thread=1 sequence=25
archived log file name=/home/oracle/arc/1_26_897920529.dbf thread=1 sequence=26
archived log file name=/home/oracle/arc/1_27_897920529.dbf thread=1 sequence=27
archived log file name=/home/oracle/arc/1_28_897920529.dbf thread=1 sequence=28
archived log file name=/home/oracle/arc/1_29_897920529.dbf thread=1 sequence=29
archived log file name=/home/oracle/arc/1_30_897920529.dbf thread=1 sequence=30
archived log file name=/home/oracle/arc/1_31_897920529.dbf thread=1 sequence=31
archived log file name=/home/oracle/arc/1_32_897920529.dbf thread=1 sequence=32
archived log file name=/home/oracle/arc/1_33_897920529.dbf thread=1 sequence=33
media recovery complete, elapsed time: 00:00:05
Finished recover at 09-DEC-15

RMAN> alter database open resetlogs;

Statement processed

RMAN> alter pluggable database PDBORCL01 open;

Statement processed

RMAN> exit


Recovery Manager complete.
[oracle@ora12c ~]$
...
Рейтинг: 0 / 0
09.12.2015, 12:56
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39124085
Kamael
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Kamael
Участник
KamaelBadRobotHrundel,
но, оказывается, что рман таки не все логи кладет нужные, хотя при бэкапе это обещает.
Всё нормально. Может уже покажите полные логи
 
Код: plaintext
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.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
[oracle@ora12c ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 9 14:59:37 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL12C (DBID=727195943)

RMAN> backup as compressed backupset database format='/home/oracle/bkp/%U' tag='keep-backup' keep until time 'sysdate+5';

Starting backup at 09-DEC-15

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=377 device type=DISK
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=+ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/example.261.897920231
input datafile file number=00008 name=+ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/system.260.897920231
input datafile file number=00009 name=+ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/sysaux.259.897920231
input datafile file number=00010 name=+ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/users.266.897920231
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/0vqod22v_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+ORCL12/ORCL12C/DATAFILE/sysaux.265.897920295
input datafile file number=00001 name=+ORCL12/ORCL12C/DATAFILE/system.264.897920295
input datafile file number=00004 name=+ORCL12/ORCL12C/DATAFILE/undotbs1.263.897920295
input datafile file number=00006 name=+ORCL12/ORCL12C/DATAFILE/users.268.897920295
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/10qod25a_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=+ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/sysaux.267.897920391
input datafile file number=00005 name=+ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/system.274.897920391
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/11qod28k_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
current log archived

using channel ORA_DISK_1
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will be backed up
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=13 RECID=34 STAMP=898009029
input archived log thread=1 sequence=14 RECID=35 STAMP=898009069
input archived log thread=1 sequence=15 RECID=36 STAMP=898009186
input archived log thread=1 sequence=16 RECID=37 STAMP=898009189
input archived log thread=1 sequence=17 RECID=38 STAMP=898009192
input archived log thread=1 sequence=18 RECID=39 STAMP=898009193
input archived log thread=1 sequence=19 RECID=40 STAMP=898009195
input archived log thread=1 sequence=20 RECID=41 STAMP=898009224
input archived log thread=1 sequence=21 RECID=42 STAMP=898009225
input archived log thread=1 sequence=22 RECID=43 STAMP=898009229
input archived log thread=1 sequence=23 RECID=44 STAMP=898009231
input archived log thread=1 sequence=24 RECID=45 STAMP=898009234
input archived log thread=1 sequence=25 RECID=46 STAMP=898009246
input archived log thread=1 sequence=26 RECID=47 STAMP=898009250
input archived log thread=1 sequence=27 RECID=48 STAMP=898009252
input archived log thread=1 sequence=28 RECID=49 STAMP=898009255
input archived log thread=1 sequence=29 RECID=50 STAMP=898009258
input archived log thread=1 sequence=30 RECID=51 STAMP=898009281
input archived log thread=1 sequence=31 RECID=52 STAMP=898009282
input archived log thread=1 sequence=32 RECID=53 STAMP=898009285
input archived log thread=1 sequence=33 RECID=54 STAMP=898009288
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/12qod2a3_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15

using channel ORA_DISK_1
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will be backed up
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-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/13qod2aj_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

using channel ORA_DISK_1
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will be backed up
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-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/bkp/14qod2ak_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-15

RMAN> exit

Recovery Manager complete.

[oracle@ora12c ~]$ sqlplus / as sysdba
cd
SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 9 15:07:59 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> shutdown abort;
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
[oracle@ora12c ~]$ cd ./arc/
[oracle@ora12c arc]$ rm -rf ./*
[oracle@ora12c arc]$ . oraenv
ORACLE_SID = [orcl12c] ? +ASM
The Oracle base has been changed from /home/oracle/app/oracle to /grid

[oracle@ora12c arc]$ asmcmd
ASMCMD> ls
DATA/
ORCL12/
ASMCMD> cd orcl12
ASMCMD> ls
ORCL12C/
spfileorcl12c.ora
ASMCMD> rm -rf ./*
ASMCMD> ls
ASMCMD> exit
[oracle@ora12c arc]$ . oraenv
ORACLE_SID = [+ASM] ? orcl12c
The Oracle base has been changed from /grid to /home/oracle/app/oracle
[oracle@ora12c arc]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 9 15:12:03 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> set dbid=727195943;

executing command: SET DBID

RMAN> startup pfile='/home/oracle/pfile' nomount;

Oracle instance started

Total System Global Area     830472192 bytes

Fixed Size                     2929840 bytes
Variable Size                595594064 bytes
Database Buffers             226492416 bytes
Redo Buffers                   5455872 bytes

RMAN> restore controlfile from '/home/oracle/bkp/14qod2ak_1_1';

Starting restore at 09-DEC-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=243 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+ORCL12/ORCL12C/CONTROLFILE/current.256.898010305
output file name=+ORCL12/ORCL12C/CONTROLFILE/current.258.898010305
Finished restore at 09-DEC-15

RMAN> exit

Recovery Manager complete.

редактирую пути до контрольников в pfile.

[oracle@ora12c ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 9 15:22:04 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> startup pfile='/home/oracle/pfile' mount;

Oracle instance started
database mounted

Total System Global Area     830472192 bytes

Fixed Size                     2929840 bytes
Variable Size                595594064 bytes
Database Buffers             226492416 bytes
Redo Buffers                   5455872 bytes

RMAN> list backup;    

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
25      Full    219.25M    DISK        00:01:07     09-DEC-15      
        BP Key: 25   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/0vqod22v_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      
  List of Datafiles in backup set 25
  Container ID: 3, PDB Name: PDBORCL01
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  8       Full 3808763    09-DEC-15 +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/system.260.897920231
  9       Full 3808763    09-DEC-15 +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/sysaux.259.897920231
  10      Full 3808763    09-DEC-15 +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/users.266.897920231
  11      Full 3808763    09-DEC-15 +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/example.261.897920231

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26      Full    411.43M    DISK        00:01:38     09-DEC-15      
        BP Key: 26   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/10qod25a_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      
  List of Datafiles in backup set 26
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 3811156    09-DEC-15 +ORCL12/ORCL12C/DATAFILE/system.264.897920295
  3       Full 3811156    09-DEC-15 +ORCL12/ORCL12C/DATAFILE/sysaux.265.897920295
  4       Full 3811156    09-DEC-15 +ORCL12/ORCL12C/DATAFILE/undotbs1.263.897920295
  6       Full 3811156    09-DEC-15 +ORCL12/ORCL12C/DATAFILE/users.268.897920295

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27      Full    157.55M    DISK        00:00:35     09-DEC-15      
        BP Key: 27   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/11qod28k_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      
  List of Datafiles in backup set 27
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 1822033    25-NOV-15 +ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/system.274.897920391
  7       Full 1822033    25-NOV-15 +ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/sysaux.267.897920391

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
28      13.88M     DISK        00:00:15     09-DEC-15      
        BP Key: 28   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/12qod2a3_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      

  List of Archived Logs in backup set 28
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    13      3807374    09-DEC-15 3807883    09-DEC-15
  1    14      3807883    09-DEC-15 3807908    09-DEC-15
  1    15      3807908    09-DEC-15 3809059    09-DEC-15
  1    16      3809059    09-DEC-15 3809256    09-DEC-15
  1    17      3809256    09-DEC-15 3809423    09-DEC-15
  1    18      3809423    09-DEC-15 3809553    09-DEC-15
  1    19      3809553    09-DEC-15 3809661    09-DEC-15
  1    20      3809661    09-DEC-15 3809832    09-DEC-15
  1    21      3809832    09-DEC-15 3809954    09-DEC-15
  1    22      3809954    09-DEC-15 3810084    09-DEC-15
  1    23      3810084    09-DEC-15 3810209    09-DEC-15
  1    24      3810209    09-DEC-15 3810331    09-DEC-15
  1    25      3810331    09-DEC-15 3810524    09-DEC-15
  1    26      3810524    09-DEC-15 3810670    09-DEC-15
  1    27      3810670    09-DEC-15 3810857    09-DEC-15
  1    28      3810857    09-DEC-15 3810994    09-DEC-15
  1    29      3810994    09-DEC-15 3811146    09-DEC-15
  1    30      3811146    09-DEC-15 3811767    09-DEC-15
  1    31      3811767    09-DEC-15 3811873    09-DEC-15
  1    32      3811873    09-DEC-15 3812108    09-DEC-15
  1    33      3812108    09-DEC-15 3812236    09-DEC-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29      Full    80.00K     DISK        00:00:00     09-DEC-15      
        BP Key: 29   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/13qod2aj_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      
  SPFILE Included: Modification time: 09-DEC-15
  SPFILE db_unique_name: ORCL12C

RMAN> list backup of archivelog all;


List of Backup Sets
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
28      13.88M     DISK        00:00:15     09-DEC-15      
        BP Key: 28   Status: AVAILABLE  Compressed: YES  Tag: KEEP-BACKUP
        Piece Name: /home/oracle/bkp/12qod2a3_1_1
        Keep: BACKUP_LOGS        Until: 14-DEC-15      

  List of Archived Logs in backup set 28
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    13      3807374    09-DEC-15 3807883    09-DEC-15
  1    14      3807883    09-DEC-15 3807908    09-DEC-15
  1    15      3807908    09-DEC-15 3809059    09-DEC-15
  1    16      3809059    09-DEC-15 3809256    09-DEC-15
  1    17      3809256    09-DEC-15 3809423    09-DEC-15
  1    18      3809423    09-DEC-15 3809553    09-DEC-15
  1    19      3809553    09-DEC-15 3809661    09-DEC-15
  1    20      3809661    09-DEC-15 3809832    09-DEC-15
  1    21      3809832    09-DEC-15 3809954    09-DEC-15
  1    22      3809954    09-DEC-15 3810084    09-DEC-15
  1    23      3810084    09-DEC-15 3810209    09-DEC-15
  1    24      3810209    09-DEC-15 3810331    09-DEC-15
  1    25      3810331    09-DEC-15 3810524    09-DEC-15
  1    26      3810524    09-DEC-15 3810670    09-DEC-15
  1    27      3810670    09-DEC-15 3810857    09-DEC-15
  1    28      3810857    09-DEC-15 3810994    09-DEC-15
  1    29      3810994    09-DEC-15 3811146    09-DEC-15
  1    30      3811146    09-DEC-15 3811767    09-DEC-15
  1    31      3811767    09-DEC-15 3811873    09-DEC-15
  1    32      3811873    09-DEC-15 3812108    09-DEC-15
  1    33      3812108    09-DEC-15 3812236    09-DEC-15

RMAN> run
2> {
3> set until scn 3812235;
4> restore database;
5> recover database;
6> }

executing command: SET until clause

Starting restore at 09-DEC-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=243 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00008 to +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/system.266.898010667
channel ORA_DISK_1: restoring datafile 00009 to +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/sysaux.259.898010669
channel ORA_DISK_1: restoring datafile 00010 to +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/users.260.898010669
channel ORA_DISK_1: restoring datafile 00011 to +ORCL12/ORCL12C/255909AB091F7BC9E053AA4011AC690C/DATAFILE/example.262.898010667
channel ORA_DISK_1: reading from backup piece /home/oracle/bkp/0vqod22v_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bkp/0vqod22v_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +ORCL12/ORCL12C/DATAFILE/system.268.898010733
channel ORA_DISK_1: restoring datafile 00003 to +ORCL12/ORCL12C/DATAFILE/sysaux.261.898010733
channel ORA_DISK_1: restoring datafile 00004 to +ORCL12/ORCL12C/DATAFILE/undotbs1.263.898010733
channel ORA_DISK_1: restoring datafile 00006 to +ORCL12/ORCL12C/DATAFILE/users.264.898010733
channel ORA_DISK_1: reading from backup piece /home/oracle/bkp/10qod25a_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bkp/10qod25a_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00005 to +ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/system.274.898010839
channel ORA_DISK_1: restoring datafile 00007 to +ORCL12/ORCL12C/2558DA01C9237632E053AA4011ACA977/DATAFILE/sysaux.265.898010839
channel ORA_DISK_1: reading from backup piece /home/oracle/bkp/11qod28k_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bkp/11qod28k_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 09-DEC-15

Starting recover at 09-DEC-15
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=15
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=16
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=17
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=18
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=19
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=20
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=21
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=22
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=23
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=24
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=25
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=26
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=27
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=28
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=29
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=30
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=31
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=32
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33
channel ORA_DISK_1: reading from backup piece /home/oracle/bkp/12qod2a3_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bkp/12qod2a3_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=/home/oracle/arc/1_15_897920529.dbf thread=1 sequence=15
archived log file name=/home/oracle/arc/1_16_897920529.dbf thread=1 sequence=16
archived log file name=/home/oracle/arc/1_17_897920529.dbf thread=1 sequence=17
archived log file name=/home/oracle/arc/1_18_897920529.dbf thread=1 sequence=18
archived log file name=/home/oracle/arc/1_19_897920529.dbf thread=1 sequence=19
archived log file name=/home/oracle/arc/1_20_897920529.dbf thread=1 sequence=20
archived log file name=/home/oracle/arc/1_21_897920529.dbf thread=1 sequence=21
archived log file name=/home/oracle/arc/1_22_897920529.dbf thread=1 sequence=22
archived log file name=/home/oracle/arc/1_23_897920529.dbf thread=1 sequence=23
archived log file name=/home/oracle/arc/1_24_897920529.dbf thread=1 sequence=24
archived log file name=/home/oracle/arc/1_25_897920529.dbf thread=1 sequence=25
archived log file name=/home/oracle/arc/1_26_897920529.dbf thread=1 sequence=26
archived log file name=/home/oracle/arc/1_27_897920529.dbf thread=1 sequence=27
archived log file name=/home/oracle/arc/1_28_897920529.dbf thread=1 sequence=28
archived log file name=/home/oracle/arc/1_29_897920529.dbf thread=1 sequence=29
archived log file name=/home/oracle/arc/1_30_897920529.dbf thread=1 sequence=30
archived log file name=/home/oracle/arc/1_31_897920529.dbf thread=1 sequence=31
archived log file name=/home/oracle/arc/1_32_897920529.dbf thread=1 sequence=32
archived log file name=/home/oracle/arc/1_33_897920529.dbf thread=1 sequence=33
media recovery complete, elapsed time: 00:00:05
Finished recover at 09-DEC-15

RMAN> alter database open resetlogs;

Statement processed

RMAN> alter pluggable database PDBORCL01 open;

Statement processed

RMAN> exit


Recovery Manager complete.
[oracle@ora12c ~]$


и на 11.2.0.2 тоже всё норм.
...
Рейтинг: 0 / 0
09.12.2015, 13:38
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39124114
BadRobot
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
BadRobot
Гость
Kamael,

это всё хорошо, конечно,

вообще-то лог бэкапа выложен весь
вот основное в моем логе

при бэкапе
Код: plsql
1.
2.
3.
4.
5.
6.
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=27837 RECID=27789 STAMP=896730619
input archived log thread=1 sequence=27838 RECID=27790 STAMP=896730927
input archived log thread=1 sequence=27839 RECID=27791 STAMP=896731260
channel ORA_DISK_1: starting piece 1 at 25-NOV-15



а вот при восстановлении
Код: plsql
1.
2.
3.
4.
5.
6.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/05/2015 13:23:05
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 27836 and starting SCN of 565421795 found to restore



Я протестил несколько баз, у меня получается, что мелкие базы - то есть те, чей бэкап происходит быстро, восстанавливались нормально. База (с которой проблема) размером побольше (около 120 гигов) и её бэкап длится намного дольше. Возможно в это время другой рман по расписанию успевает что-то отбэкапить и переключить логи?
Когда база была маленькой то я пару раз сделал бэкап с использованием keep и всё восстановилось нормально - а вот тут раз и вылезло такое, восстанавливал 3 базы - 2 восстановились нормально, а третья вот с такой вот бякой
...
Рейтинг: 0 / 0
09.12.2015, 14:03
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39124131
Kamael
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Kamael
Участник
BadRobotKamael,

это всё хорошо, конечно,

вообще-то лог бэкапа выложен весь
вот основное в моем логе

при бэкапе
Код: plsql
1.
2.
3.
4.
5.
6.
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=27837 RECID=27789 STAMP=896730619
input archived log thread=1 sequence=27838 RECID=27790 STAMP=896730927
input archived log thread=1 sequence=27839 RECID=27791 STAMP=896731260
channel ORA_DISK_1: starting piece 1 at 25-NOV-15



а вот при восстановлении
Код: plsql
1.
2.
3.
4.
5.
6.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/05/2015 13:23:05
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 27836 and starting SCN of 565421795 found to restore



Я протестил несколько баз, у меня получается, что мелкие базы - то есть те, чей бэкап происходит быстро, восстанавливались нормально. База (с которой проблема) размером побольше (около 120 гигов) и её бэкап длится намного дольше. Возможно в это время другой рман по расписанию успевает что-то отбэкапить и переключить логи?
Когда база была маленькой то я пару раз сделал бэкап с использованием keep и всё восстановилось нормально - а вот тут раз и вылезло такое, восстанавливал 3 базы - 2 восстановились нормально, а третья вот с такой вот бякой

покажите recover database preview и list backup. и где сейчас 27836 арх.лог?
...
Рейтинг: 0 / 0
09.12.2015, 14:13
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39124139
BadRobot
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
BadRobot
Гость
Кстати, эту третью базу я пытался восстановить с двух бэкапов, сделанных в разные дни командой backup database keep. Сами бэкапы отработали без ошибок, но, что первый, что второй бэкап при восстановлении попросили для восстановления лог, идущий перед логами, которые есть в этом самом бэкапе!
...
Рейтинг: 0 / 0
09.12.2015, 14:18
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39124164
ctlv
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ctlv
Гость
Во время бэкапа генерировал архивные логи.
 
10.2.0.4Recovery Manager: Release 10.2.0.4.0 - Production on Wed Dec 9 14:13:00 2015

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORCL (DBID=3054505191)

RMAN> backup as compressed backupset database format='/home/oracle/backup/%U' tag='keep-backup' keep until time 'sysdate+5' LOGS;

Starting backup at 09-DEC-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=20 devtype=DISK
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will expire when this backup expires
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.267.897929859
input datafile fno=00001 name=+DATA/orcl/datafile/system.266.897929859
input datafile fno=00003 name=+DATA/orcl/datafile/sysaux.261.897929859
input datafile fno=00004 name=+DATA/orcl/datafile/users.259.897929861
input datafile fno=00005 name=+DATA/orcl/datafile/example.258.897929861
input datafile fno=00006 name=+DATA/orcl/datafile/test.257.897929861
input datafile fno=00007 name=+DATA/orcl/datafile/test.256.897929861
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/backup/0uqocvf7_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/backup/0vqocvgv_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-DEC-15

RMAN> list backup; -- нет бэкапов архивных логов.


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22 Full 217.30M DISK 00:00:52 09-DEC-15
BP Key: 22 Status: AVAILABLE Compressed: YES Tag: KEEP-BACKUP
Piece Name: /home/oracle/backup/0uqocvf7_1_1
Keep: LOGS Until: 14-DEC-15
List of Datafiles in backup set 22
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 11385349 09-DEC-15 +DATA/orcl/datafile/system.266.897929859
2 Full 11385349 09-DEC-15 +DATA/orcl/datafile/undotbs1.267.897929859
3 Full 11385349 09-DEC-15 +DATA/orcl/datafile/sysaux.261.897929859
4 Full 11385349 09-DEC-15 +DATA/orcl/datafile/users.259.897929861
5 Full 11385349 09-DEC-15 +DATA/orcl/datafile/example.258.897929861
6 Full 11385349 09-DEC-15 +DATA/orcl/datafile/test.257.897929861
7 Full 11385349 09-DEC-15 +DATA/orcl/datafile/test.256.897929861

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
23 Full 1.05M DISK 00:00:02 09-DEC-15
BP Key: 23 Status: AVAILABLE Compressed: YES Tag: KEEP-BACKUP
Piece Name: /home/oracle/backup/0vqocvgv_1_1
Keep: LOGS Until: 14-DEC-15
Control File Included: Ckp SCN: 11606633 Ckp time: 09-DEC-15
SPFILE Included: Modification time: 08-DEC-15

RMAN>


[oracle@or1 ~]$ ls backup
0uqocvf7_1_1 0vqocvgv_1_1
[oracle@or1 ~]$
scp....

[oracle@or2 ~]$ asmcmd
ASMCMD> rm -r data
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD>
or2:
RMAN> restore controlfile from '/home/oracle/backup/0vqocvgv_1_1';

Starting restore at 09-DEC-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:10
output filename=+DATA/orcl/controlfile/current.264.898007159
Finished restore at 09-DEC-15
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 09-DEC-15
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +DATA/orcl/datafile/system.266.897929859
restoring datafile 00002 to +DATA/orcl/datafile/undotbs1.267.897929859
restoring datafile 00003 to +DATA/orcl/datafile/sysaux.261.897929859
restoring datafile 00004 to +DATA/orcl/datafile/users.259.897929861
restoring datafile 00005 to +DATA/orcl/datafile/example.258.897929861
restoring datafile 00006 to +DATA/orcl/datafile/test.257.897929861
restoring datafile 00007 to +DATA/orcl/datafile/test.256.897929861
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/0uqocvf7_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup/0uqocvf7_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:05:36
Finished restore at 09-DEC-15

RMAN> recover database;

Starting recover at 09-DEC-15
using channel ORA_DISK_1

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 7 needs more recovery to be consistent
ORA-01110: data file 7: '+DATA/orcl/datafile/test.256.898007235'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/09/2015 14:33:00
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 4 lowscn 11489268 found to restore
RMAN-06025: no backup of log thread 1 seq 3 lowscn 11387926 found to restore
RMAN-06025: no backup of log thread 1 seq 2 lowscn 11348505 found to restore

RMAN>
...
Рейтинг: 0 / 0
09.12.2015, 14:41
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39124475
Kamael
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Kamael
Участник
ctlvВо время бэкапа генерировал архивные логи.
 
10.2.0.4Recovery Manager: Release 10.2.0.4.0 - Production on Wed Dec 9 14:13:00 2015

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORCL (DBID=3054505191)

RMAN> backup as compressed backupset database format='/home/oracle/backup/%U' tag='keep-backup' keep until time 'sysdate+5' LOGS;

Starting backup at 09-DEC-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=20 devtype=DISK
backup will be obsolete on date 14-DEC-15
archived logs required to recover from this backup will expire when this backup expires
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.267.897929859
input datafile fno=00001 name=+DATA/orcl/datafile/system.266.897929859
input datafile fno=00003 name=+DATA/orcl/datafile/sysaux.261.897929859
input datafile fno=00004 name=+DATA/orcl/datafile/users.259.897929861
input datafile fno=00005 name=+DATA/orcl/datafile/example.258.897929861
input datafile fno=00006 name=+DATA/orcl/datafile/test.257.897929861
input datafile fno=00007 name=+DATA/orcl/datafile/test.256.897929861
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/backup/0uqocvf7_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 09-DEC-15
channel ORA_DISK_1: finished piece 1 at 09-DEC-15
piece handle=/home/oracle/backup/0vqocvgv_1_1 tag=KEEP-BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-DEC-15

RMAN> list backup; -- нет бэкапов архивных логов.


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22 Full 217.30M DISK 00:00:52 09-DEC-15
BP Key: 22 Status: AVAILABLE Compressed: YES Tag: KEEP-BACKUP
Piece Name: /home/oracle/backup/0uqocvf7_1_1
Keep: LOGS Until: 14-DEC-15
List of Datafiles in backup set 22
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 11385349 09-DEC-15 +DATA/orcl/datafile/system.266.897929859
2 Full 11385349 09-DEC-15 +DATA/orcl/datafile/undotbs1.267.897929859
3 Full 11385349 09-DEC-15 +DATA/orcl/datafile/sysaux.261.897929859
4 Full 11385349 09-DEC-15 +DATA/orcl/datafile/users.259.897929861
5 Full 11385349 09-DEC-15 +DATA/orcl/datafile/example.258.897929861
6 Full 11385349 09-DEC-15 +DATA/orcl/datafile/test.257.897929861
7 Full 11385349 09-DEC-15 +DATA/orcl/datafile/test.256.897929861

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
23 Full 1.05M DISK 00:00:02 09-DEC-15
BP Key: 23 Status: AVAILABLE Compressed: YES Tag: KEEP-BACKUP
Piece Name: /home/oracle/backup/0vqocvgv_1_1
Keep: LOGS Until: 14-DEC-15
Control File Included: Ckp SCN: 11606633 Ckp time: 09-DEC-15
SPFILE Included: Modification time: 08-DEC-15

RMAN>


[oracle@or1 ~]$ ls backup
0uqocvf7_1_1 0vqocvgv_1_1
[oracle@or1 ~]$
scp....

[oracle@or2 ~]$ asmcmd
ASMCMD> rm -r data
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD>
or2:
RMAN> restore controlfile from '/home/oracle/backup/0vqocvgv_1_1';

Starting restore at 09-DEC-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:10
output filename=+DATA/orcl/controlfile/current.264.898007159
Finished restore at 09-DEC-15
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 09-DEC-15
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +DATA/orcl/datafile/system.266.897929859
restoring datafile 00002 to +DATA/orcl/datafile/undotbs1.267.897929859
restoring datafile 00003 to +DATA/orcl/datafile/sysaux.261.897929859
restoring datafile 00004 to +DATA/orcl/datafile/users.259.897929861
restoring datafile 00005 to +DATA/orcl/datafile/example.258.897929861
restoring datafile 00006 to +DATA/orcl/datafile/test.257.897929861
restoring datafile 00007 to +DATA/orcl/datafile/test.256.897929861
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/0uqocvf7_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup/0uqocvf7_1_1 tag=KEEP-BACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:05:36
Finished restore at 09-DEC-15

RMAN> recover database;

Starting recover at 09-DEC-15
using channel ORA_DISK_1

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 7 needs more recovery to be consistent
ORA-01110: data file 7: '+DATA/orcl/datafile/test.256.898007235'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/09/2015 14:33:00
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 4 lowscn 11489268 found to restore
RMAN-06025: no backup of log thread 1 seq 3 lowscn 11387926 found to restore
RMAN-06025: no backup of log thread 1 seq 2 lowscn 11348505 found to restore

RMAN>

archived logs required to recover from this backup will expire when this backup expires
тут как бы всё понятно, в бэкап арх логи не идут, но will expire when this backup expires. это характерно для 10g
в 11g и 12 уже archived logs required to recover from this backup will be backed up
как воспроизвести ситуацию ТС, не понятно.
...
Рейтинг: 0 / 0
09.12.2015, 21:52
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39124520
проходил мимо...
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
проходил мимо...
Участник
Kamaelкак воспроизвести ситуацию ТС, не понятно
Предположу, что параллельно мог работать ещё один бэкап, который и забрал отсутствующий лог. И бэкап оптимизация была включена. Завтра попробую.
...
Рейтинг: 0 / 0
09.12.2015, 23:55
| Ответить | Цитировать | Написать  
Период между сообщениями больше года.
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39645932
pemp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
pemp
Участник
Доборого всем заглянувшим, присоседюсь со своим вопросом, любопытно стало.

Дали полный горячий бэкап для опытов и столкнулся с непонятным мне поведением: в бэкапе все есть, но рман не мог сам найти в нем архивлоги
Бэкап делался с PLUS ARCHIVELOG DELETE INPUT, автобэкап контролфайла, оптимизация выключена, redundancy 1, Win 11.2
получил три файла: автобэкап, один с датафайлами и один с архивлогами.

Разворачиваю в пустую базу , восстанавливаю контролфайл из автобэкапа, ресторю, начинаю делать recover получаю успешно, но file needs more recovery.
Пробую recover database using backup controlfile until cancel он мне предлагает дать ему архивлог за номером 22511, который как мы можем видеть ниже, лежит в бэкапе.
restore archivelog all дало ошибку ORA-19693: backup piece O1_MF_ANNNN_TAG20180516T094237_FHQ6NXY8_.BKP already included
Сделал catalog backuppiece 'C:\....O1_MF_ANNNN_TAG20180516T094237_FHQ6NXY8_.BKP'; restore archivelog all force и после этого все отрекаверилось и стратануло даже не пискнув.

Собсвенно вопрос: чего рману нужно, чтобы он без дополнителных плясок с бубном взял для восстановления архивлоги из бэкапа, или чего я делаю не так, и что может делать не так дба который выдал мне этот бэкап?
Единственное что вижу аномального что 2 копии в одном файле.


Код: sql
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.
List of Backup Sets
===================

BS Key  Type LV Size
------- ---- -- ----------
567     Full    7.31G
  List of Datafiles in backup set 567
  File LV Type Ckp SCN    Ckp Time Name
  ---- -- ---- ---------- -------- ----
  1       Full 10492933334540 16.05.18 E:\APP\ORADATA\DBNAME\SYSTEM01.DBF
  2       Full 10492933334540 16.05.18 E:\APP\ORADATA\DBNAME\SYSAUX01.DBF
................
................

 Backup Set Copy #3 of backup set 567
 Device Type Elapsed Time Completion Time Compressed Tag
 ----------- ------------ --------------- ---------- ---
 DISK        00:27:58     16.05.18        YES        TAG20180516T091435

   List of Backup Pieces for backup set 567 Copy #3
   BP Key  Pc# Status      Piece Name
   ------- --- ----------- ----------
   572     1   AVAILABLE   C:\BACK\DBNAME\BACKUPSET\2018_05_16\O1_MF_NNNDF_TAG20180516T091435_FHQ50DGJ_.BKP

 Backup Set Copy #4 of backup set 567
 Device Type Elapsed Time Completion Time Compressed Tag
 ----------- ------------ --------------- ---------- ---
 DISK        00:27:58     16.05.18        YES        TAG20180516T091435

   List of Backup Pieces for backup set 567 Copy #4
   BP Key  Pc# Status      Piece Name
   ------- --- ----------- ----------
   574     1   AVAILABLE   C:\BACK\DBNAME\BACKUPSET\2018_05_16\O1_MF_NNNDF_TAG20180516T091435_FHQ50DGJ_.BKP


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
568     61.53M     DISK        00:00:11     16.05.18
        BP Key: 577   Status: AVAILABLE  Compressed: YES  Tag: TAG20180516T094237
        Piece Name: C:\BACK\DBNAME\BACKUPSET\2018_05_16\O1_MF_ANNNN_TAG20180516T094237_FHQ6NXY8_.BKP

  List of Archived Logs in backup set 568
  Thrd Seq     Low SCN    Low Time Next SCN   Next Time
  ---- ------- ---------- -------- ---------- ---------
  1    22511   10492933328518 16.05.18 10492933369634 16.05.18
  1    22512   10492933369634 16.05.18 10492933410198 16.05.18
  1    22513   10492933410198 16.05.18 10492933439345 16.05.18
  1    22514   10492933439345 16.05.18 10492933466530 16.05.18
  1    22515   10492933466530 16.05.18 10492933496297 16.05.18

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
569     Full    15.52M     DISK        00:00:12     17.05.18
        BP Key: 578   Status: AVAILABLE  Compressed: NO  Tag: TAG20180517T103744
        Piece Name: C:\BACK\DBNAME\AUTOBACKUP\2018_05_17\O1_MF_S_976358264_FHSTQXKJ_.BKP
  SPFILE Included: Modification time: 17.05.18
  SPFILE db_unique_name: DBNAME
  Control File Included: Ckp SCN: 10492934066486   Ckp time: 17.05.18
...
Рейтинг: 0 / 0
17.05.2018, 10:43
| Ответить | Цитировать | Написать  
rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
    #39649103
pemp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
pemp
Участник
И так чутка поигравшись в виртуалочке выяснил следующее.
получилось так, что я ненамеренно положил бэкапы в тот же путь куда их бэкапили на том сервере откуда они взялись, и rman посчитал что они лежат на своем месте. а я в свою очередь перед restore не глядя сделал catalog start with в ту же директорию в итоге rman посчитал что в каждом файле лежит по две копии бэкапсета, на одном левом сайте попалось упоминание что это известный баг рмана.
К слову попробовал удалить вторую копию бэкапсета и рман грохнул весь файл, оставив меня без бэкапа, как в анекдоте про нортонкомандер, слева диск с: и справа диск с: подумал зачем два одинаковых и один удалил. :)

в общем. если положить файлы в путь не совпадающий с путем бэкапа там где его делали или же положить по такому же пути, но не включать в каталог. восстановление нормально отрабатывает без чудес.
...
Рейтинг: 0 / 0
24.05.2018, 06:11
| Ответить | Цитировать | Написать  
24 сообщений из 24, страница 1 из 1
Форумы / Oracle [игнор отключен] [закрыт для гостей] / rman backup keep и ORA-01194: file 1 needs more recovery to be consistent
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение   Полит. конфиден.  
NoSQL.ru       Кролег: Проекты, Новости, Чат       РЕД ФОРУМ       Фотоальбом: Участники, Встречи
Закрыть
start [/forum/topic.php?fid=52&msg=39645932&tid=1883956]:
 0ms
get settings:
 9ms
get forum list:
 15ms
check forum access:
 3ms
check topic access:
 3ms
track hit:
 256ms
get topic data:
 11ms
get forum data:
 3ms
get page messages:
 68ms
get tp. blocked users:
 1ms
others: 221ms
total:  590ms
созд. / загр.: 590ms
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]