Índice do fórum Treinamentos Avançados Treinamento Oracle Backup & Recovery Restore Redo current

Restore Redo current

Dúvidas, dicas e atualizações sobre o Treinamento Oracle Backup & Recovery.

Mensagem Sex Fev 22, 2019 5:20 pm

Mensagens: 0
Olá Portilho,

Criei um novo banco de dados para praticar os labs do treinamento.

Bom, instalei o Linux, o Oracle, criei uma instância com 1 PDB, habilitei o Archive Log e fiz um backup completo.

Resolvi começar pelo Lab 28.4: Restore Redo Logs.

Pois bem, peguei a sequence e o caminho do redo log current e o deletei pelo S.O. Baixei a instância com shutdown immediate e subi para mount.

Entrei no rman e executei o bloco run com o incomplete recovery, que foi:

RUN {
SET UNTIL SEQUENCE 5;
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
}

O que resultou no seguinte erro:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/19/2019 18:33:06
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

Dei um list backup e os backups estavam lá.

O que eu entendi é que parecia que a incarnation atual não tinha backup. Então, listei as incarnation e vi que tinham duas.

Resetei a database para a anterior e rodei novamente o bloco run, mas sem a parte de restore, só com o recover. Deu um erro dizendo que a system pertencia a uma incarnation orfã, mas me deixou abrir a base com open resetlogs.

Eu queria entender o porque aconteceu isso, porque fiz um outro teste que me deixou mais na dúvida ainda, que foi o seguinte:

Nessa mesma máquina que usei para o lab eu tirei um snapshot logo depois do backup que fiz. Então voltei ao estado inicial e antes de deletar o current fiz uma série de switch log file (depois vi que era a recomendação no pdf do curso).

Fazendo assim o bloco run funcionou perfeitamente, realizando o restore, recover(da sequence anterior ao current) e open resetlogs.

As dúvidas são:

Porque com o switch logfile deu certo?
Porque não deu certo quando não fiz um switch antes de deletar o current?
O procedimento de mudar de incarnation foi correto?

Anexei um txt com todos os procedimentos que fiz e os resultados (do cenário que não funcionou como no pdf).

Abraços, Portilho.
Anexos
lab1.zip
(3.39 KiB) Baixado 52 vezes

Mensagem Qua Jul 17, 2019 10:42 pm
portilho Site Admin

Mensagens: 482
Oi !
Demorei pra responder porque eu não lembrava do porquê que eu coloco o "Execute várias vezes ALTER SYSTEM SWITCH LOGFILE." no Lab 28.4.
Lembrei depois de refazer em sequência, são por duas razões:
- Como o Lab 28.3 inclui um RESETLOGS, a SEQUENCE do CURRENT deve ser a 1, e eu quero evitar que os alunos tentem fazer UNTIL SEQUENCE 1, sendo que eles devem ter apagado a própria SEQUENCE 1.
- Para que seja mais parecido com uma situação real. Em uma situação real, é mais provável que o CURRENT fosse apagado, e só depois de vários SWITCHs naturais que a instância travasse, pois a ela tentaria voltar a tentar usar o CURRENT, além de tentar criar um ARCHIVE dele.

A incarnação atual tinha backup sim. Veja o "Reset SCN" do LIST INCARNATION, ele é anterior ao "Ckp SCN" dos Backups. Ou seja, tem backup desta INCARNATION. Também não entendi porque o RMAN considerou que não tinha.

Por via das dúvidas, refiz o Lab sem os SWITCHs, e funcionou:

[oracle@Baltazar ~]$ rlwrap rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Jul 17 17:37:47 2019
Version 19.3.0.0.0

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

connected to target database: ORCL (DBID=1537518502)

RMAN> BACKUP DATABASE;

Starting backup at 17-JUL-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=782 device type=DISK
skipping datafile 2; already backed up 2 time(s)
skipping datafile 4; already backed up 2 time(s)
skipping datafile 6; already backed up 2 time(s)
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00015 name=/u01/app/oracle/oradata/ORCL/DEV/soe01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/ORCL/DEV/system01.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/ORCL/DEV/shsb01.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/ORCL/DEV/undotbs01.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/ORCL/DEV/sysaux01.dbf
channel ORA_DISK_1: starting piece 1 at 17-JUL-19
channel ORA_DISK_1: finished piece 1 at 17-JUL-19
piece handle=/u01/Backup/Database-ORCL___DBID-1537518502___Date-20190717___Set-17___Piece-1.BKP tag=TAG20190717T173755 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03: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=/u01/app/oracle/oradata/ORCL/sysaux01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/users01.dbf
channel ORA_DISK_1: starting piece 1 at 17-JUL-19
channel ORA_DISK_1: finished piece 1 at 17-JUL-19
piece handle=/u01/Backup/Database-ORCL___DBID-1537518502___Date-20190717___Set-18___Piece-1.BKP tag=TAG20190717T173755 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/ORCL/CATALOGO/undotbs01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/ORCL/CATALOGO/sysaux01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/ORCL/CATALOGO/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ORCL/CATALOGO/users01.dbf
channel ORA_DISK_1: starting piece 1 at 17-JUL-19
channel ORA_DISK_1: finished piece 1 at 17-JUL-19
piece handle=/u01/Backup/Database-ORCL___DBID-1537518502___Date-20190717___Set-19___Piece-1.BKP tag=TAG20190717T173755 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 17-JUL-19

Starting Control File and SPFILE Autobackup at 17-JUL-19
piece handle=/u01/Backup/ControlfileAutoBackup-c-1537518502-20190717-00.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 17-JUL-19

RMAN> BACKUP ARCHIVELOG ALL DELETE ALL INPUT;

Starting backup at 17-JUL-19
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=877 RECID=1 STAMP=1010851245
input archived log thread=1 sequence=878 RECID=2 STAMP=1010949348
input archived log thread=1 sequence=879 RECID=3 STAMP=1011027621
input archived log thread=1 sequence=880 RECID=4 STAMP=1011110902
input archived log thread=1 sequence=881 RECID=5 STAMP=1011214842
input archived log thread=1 sequence=882 RECID=6 STAMP=1011330064
input archived log thread=1 sequence=883 RECID=7 STAMP=1011445241
input archived log thread=1 sequence=884 RECID=8 STAMP=1011542439
input archived log thread=1 sequence=885 RECID=9 STAMP=1011628816
input archived log thread=1 sequence=886 RECID=10 STAMP=1011683865
input archived log thread=1 sequence=887 RECID=11 STAMP=1011683881
input archived log thread=1 sequence=888 RECID=12 STAMP=1011683900
input archived log thread=1 sequence=889 RECID=13 STAMP=1011683915
input archived log thread=1 sequence=890 RECID=14 STAMP=1011683936
input archived log thread=1 sequence=891 RECID=15 STAMP=1011683952
input archived log thread=1 sequence=892 RECID=16 STAMP=1011683964
input archived log thread=1 sequence=893 RECID=17 STAMP=1011684070
input archived log thread=1 sequence=894 RECID=18 STAMP=1012201602
input archived log thread=1 sequence=895 RECID=19 STAMP=1012604434
input archived log thread=1 sequence=896 RECID=20 STAMP=1013073142
input archived log thread=1 sequence=897 RECID=21 STAMP=1013572966
input archived log thread=1 sequence=898 RECID=22 STAMP=1013658218
input archived log thread=1 sequence=899 RECID=23 STAMP=1013752809
input archived log thread=1 sequence=900 RECID=24 STAMP=1013839400
input archived log thread=1 sequence=901 RECID=25 STAMP=1013882128
channel ORA_DISK_1: starting piece 1 at 17-JUL-19
channel ORA_DISK_1: finished piece 1 at 17-JUL-19
piece handle=/u01/Backup/Database-ORCL___DBID-1537518502___Date-20190717___Set-21___Piece-1.BKP tag=TAG20190717T175529 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:05:35
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u01/ArchivedRedoLogs/1_877_1009737766.dbf RECID=1 STAMP=1010851245
archived log file name=/u01/ArchivedRedoLogs/1_878_1009737766.dbf RECID=2 STAMP=1010949348
archived log file name=/u01/ArchivedRedoLogs/1_879_1009737766.dbf RECID=3 STAMP=1011027621
archived log file name=/u01/ArchivedRedoLogs/1_880_1009737766.dbf RECID=4 STAMP=1011110902
archived log file name=/u01/ArchivedRedoLogs/1_881_1009737766.dbf RECID=5 STAMP=1011214842
archived log file name=/u01/ArchivedRedoLogs/1_882_1009737766.dbf RECID=6 STAMP=1011330064
archived log file name=/u01/ArchivedRedoLogs/1_883_1009737766.dbf RECID=7 STAMP=1011445241
archived log file name=/u01/ArchivedRedoLogs/1_884_1009737766.dbf RECID=8 STAMP=1011542439
archived log file name=/u01/ArchivedRedoLogs/1_885_1009737766.dbf RECID=9 STAMP=1011628816
archived log file name=/u01/ArchivedRedoLogs/1_886_1009737766.dbf RECID=10 STAMP=1011683865
archived log file name=/u01/ArchivedRedoLogs/1_887_1009737766.dbf RECID=11 STAMP=1011683881
archived log file name=/u01/ArchivedRedoLogs/1_888_1009737766.dbf RECID=12 STAMP=1011683900
archived log file name=/u01/ArchivedRedoLogs/1_889_1009737766.dbf RECID=13 STAMP=1011683915
archived log file name=/u01/ArchivedRedoLogs/1_890_1009737766.dbf RECID=14 STAMP=1011683936
archived log file name=/u01/ArchivedRedoLogs/1_891_1009737766.dbf RECID=15 STAMP=1011683952
archived log file name=/u01/ArchivedRedoLogs/1_892_1009737766.dbf RECID=16 STAMP=1011683964
archived log file name=/u01/ArchivedRedoLogs/1_893_1009737766.dbf RECID=17 STAMP=1011684070
archived log file name=/u01/ArchivedRedoLogs/1_894_1009737766.dbf RECID=18 STAMP=1012201602
archived log file name=/u01/ArchivedRedoLogs/1_895_1009737766.dbf RECID=19 STAMP=1012604434
archived log file name=/u01/ArchivedRedoLogs/1_896_1009737766.dbf RECID=20 STAMP=1013073142
archived log file name=/u01/ArchivedRedoLogs/1_897_1009737766.dbf RECID=21 STAMP=1013572966
archived log file name=/u01/ArchivedRedoLogs/1_898_1009737766.dbf RECID=22 STAMP=1013658218
archived log file name=/u01/ArchivedRedoLogs/1_899_1009737766.dbf RECID=23 STAMP=1013752809
archived log file name=/u01/ArchivedRedoLogs/1_900_1009737766.dbf RECID=24 STAMP=1013839400
archived log file name=/u01/ArchivedRedoLogs/1_901_1009737766.dbf RECID=25 STAMP=1013882128
Finished backup at 17-JUL-19

Starting Control File and SPFILE Autobackup at 17-JUL-19
piece handle=/u01/Backup/ControlfileAutoBackup-c-1537518502-20190717-01.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 17-JUL-19

RMAN> EXIT;


Recovery Manager complete.
[oracle@Baltazar ~]$




[oracle@Baltazar ~]$ rlwrap sqlplus / AS SYSDBA
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 17 18:03:05 2019
Version 19.3.0.0.0

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


Ligado a:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

18:03:06 SYS@ORCL> SELECT * FROM V$LOG;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME      CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------- ------------ ---------- ----------
         1          1        884  209715200        512          1 YES INACTIVE               8929170 2019-06-20      9024795 2019-06-21          0
         2          1        885  209715200        512          1 YES INACTIVE               9024795 2019-06-21      9119917 2019-06-22          0
         3          1        886  209715200        512          1 YES INACTIVE               9119917 2019-06-22      9190473 2019-06-23          0
         4          1        887  209715200        512          1 YES INACTIVE               9190473 2019-06-23      9190868 2019-06-23          0
         5          1        888  209715200        512          1 YES INACTIVE               9190868 2019-06-23      9191262 2019-06-23          0
         6          1        889  209715200        512          1 YES INACTIVE               9191262 2019-06-23      9191670 2019-06-23          0
         7          1        890  209715200        512          1 YES INACTIVE               9191670 2019-06-23      9192080 2019-06-23          0
         8          1        891  209715200        512          1 YES INACTIVE               9192080 2019-06-23      9192487 2019-06-23          0
         9          1        892  209715200        512          1 YES INACTIVE               9192487 2019-06-23      9192756 2019-06-23          0
        10          1        893  209715200        512          1 YES INACTIVE               9192756 2019-06-23      9194378 2019-06-23          0
        11          1        898  209715200        512          1 YES INACTIVE              11072523 2019-07-14     11166670 2019-07-15          0
        12          1        899  209715200        512          1 YES INACTIVE              11166670 2019-07-15     11261147 2019-07-16          0
        13          1        900  209715200        512          1 YES INACTIVE              11261147 2019-07-16     11349702 2019-07-17          0
        14          1        901  209715200        512          1 YES INACTIVE              11349702 2019-07-17     11383427 2019-07-17          0
        15          1        902  209715200        512          1 NO  CURRENT               11383427 2019-07-17   1.8447E+19                     0
        16          1        883  209715200        512          1 YES INACTIVE               8819646 2019-06-19      8929170 2019-06-20          0
        17          1        894 1073741824        512          1 YES INACTIVE               9194378 2019-06-23      9722661 2019-06-29          0
        18          1        895 1073741824        512          1 YES INACTIVE               9722661 2019-06-29     10062178 2019-07-02          0
        19          1        896 1073741824        512          1 YES INACTIVE              10062178 2019-07-02     10552159 2019-07-08          0
        20          1        897 1073741824        512          1 YES INACTIVE              10552159 2019-07-08     11072523 2019-07-14          0

20 linhas selecionadas.

Decorreram: 00:00:00.06
18:04:18 SYS@ORCL> SELECT MEMBER FROM V$LOGFILE WHERE GROUP# = 15;

MEMBER
------------------------------------------------------------
/u01/app/oracle/oradata/ORCL/redo15.log

Decorreram: 00:00:00.01
18:04:34 SYS@ORCL> !rm /u01/app/oracle/oradata/ORCL/redo15.log

18:05:53 SYS@ORCL> SHUTDOWN IMMEDIATE;
Base de dados fechada.
Instancia ORACLE encerrada.
18:07:31 SYS@ORCL> STARTUP MOUNT
Base de dados montada.
18:26:34 SYS@ORCL> EXIT
Desligado de Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@Baltazar ~]$




[oracle@Baltazar ~]$ rlwrap rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Jul 17 18:27:19 2019
Version 19.3.0.0.0

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

connected to target database: ORCL (DBID=1537518502, not open)

RMAN> RUN {
2> SET UNTIL SEQUENCE 901;
3> RESTORE DATABASE;
4> RECOVER DATABASE;
5> ALTER DATABASE OPEN RESETLOGS;
6> }

executing command: SET until clause

Starting restore at 17-JUL-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=393 device type=DISK

skipping datafile 2; already restored to file /u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf
skipping datafile 4; already restored to file /u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf
skipping datafile 6; already restored to file /u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf
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 00007 to /u01/app/oracle/oradata/ORCL/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/Backup/Database-ORCL___DBID-1537518502___Date-20190627___Set-11___Piece-1.BKP
channel ORA_DISK_1: piece handle=/u01/Backup/Database-ORCL___DBID-1537518502___Date-20190627___Set-11___Piece-1.BKP tag=TAG20190627T162522
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00012 to /u01/app/oracle/oradata/ORCL/DEV/system01.dbf
channel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/ORCL/DEV/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00014 to /u01/app/oracle/oradata/ORCL/DEV/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00015 to /u01/app/oracle/oradata/ORCL/DEV/soe01.dbf
channel ORA_DISK_1: restoring datafile 00016 to /u01/app/oracle/oradata/ORCL/DEV/shsb01.dbf
channel ORA_DISK_1: reading from backup piece /u01/Backup/Database-ORCL___DBID-1537518502___Date-20190627___Set-13___Piece-1.BKP
channel ORA_DISK_1: piece handle=/u01/Backup/Database-ORCL___DBID-1537518502___Date-20190627___Set-13___Piece-1.BKP tag=TAG20190627T162546
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:21
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 /u01/app/oracle/oradata/ORCL/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORCL/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/ORCL/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /u01/Backup/Database-ORCL___DBID-1537518502___Date-20190627___Set-14___Piece-1.BKP
channel ORA_DISK_1: piece handle=/u01/Backup/Database-ORCL___DBID-1537518502___Date-20190627___Set-14___Piece-1.BKP tag=TAG20190627T162546
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:06
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 /u01/app/oracle/oradata/ORCL/CATALOGO/system01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/ORCL/CATALOGO/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/ORCL/CATALOGO/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/ORCL/CATALOGO/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/Backup/Database-ORCL___DBID-1537518502___Date-20190627___Set-15___Piece-1.BKP
channel ORA_DISK_1: piece handle=/u01/Backup/Database-ORCL___DBID-1537518502___Date-20190627___Set-15___Piece-1.BKP tag=TAG20190627T162546
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 17-JUL-19

Starting recover at 17-JUL-19
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=894
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=895
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=896
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=897
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=898
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=899
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=900
channel ORA_DISK_1: reading from backup piece /u01/Backup/Database-ORCL___DBID-1537518502___Date-20190717___Set-21___Piece-1.BKP
channel ORA_DISK_1: piece handle=/u01/Backup/Database-ORCL___DBID-1537518502___Date-20190717___Set-21___Piece-1.BKP tag=TAG20190717T175529
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:46
archived log file name=/u01/ArchivedRedoLogs/1_894_1009737766.dbf thread=1 sequence=894
archived log file name=/u01/ArchivedRedoLogs/1_895_1009737766.dbf thread=1 sequence=895
archived log file name=/u01/ArchivedRedoLogs/1_896_1009737766.dbf thread=1 sequence=896
archived log file name=/u01/ArchivedRedoLogs/1_897_1009737766.dbf thread=1 sequence=897
archived log file name=/u01/ArchivedRedoLogs/1_898_1009737766.dbf thread=1 sequence=898
archived log file name=/u01/ArchivedRedoLogs/1_899_1009737766.dbf thread=1 sequence=899
archived log file name=/u01/ArchivedRedoLogs/1_900_1009737766.dbf thread=1 sequence=900
media recovery complete, elapsed time: 00:11:48
Finished recover at 17-JUL-19

Statement processed

RMAN>


Voltar para Treinamento Oracle Backup & Recovery

cron