Pessoal,

Estou fazendo um teste de restore de um banco de produção, e no recover esta
pedindo essa sequencia que não tem na fita.

Em outros bancos eu faço somente o comando recover database e restaura tudo
da fita, mas com esse banco não.

 

Oracle Database 10g Enterprise (release 10.2.0.5)

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 02/18/2017 22:30:28

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06025: no backup of log thread 1 seq 334636 lowscn 7193460817456 found
to restore

RMAN-06025: no backup of log thread 1 seq 334635 lowscn 7193460458528 found
to restore

RMAN-06025: no backup of log thread 1 seq 334634 lowscn 7193460132470 found
to restore

RMAN-06025: no backup of log thread 1 seq 334633 lowscn 7193459799379 found
to restore

RMAN-06025: no backup of log thread 1 seq 334632 lowscn 7193459496737 found
to restore

RMAN-06025: no backup of log thread 1 seq 334631 lowscn 7193459232530 found
to restore

RMAN-06025: no backup of log thread 1 seq 334630 lowscn 7193458941288 found
to restore

RMAN-06025: no backup of log thread 1 seq 334629 lowscn 7193458610654 found
to restore

RMAN-06025: no backup of log thread 1 seq 334628 lowscn 7193458409182 found
to restore

RMAN-06025: no backup of log thread 1 seq 334627 lowscn 7193458017322 found
to restore

RMAN-06025: no backup of log thread 1 seq 334626 lowscn 7193457646797 found
to restore

 

Segue meu script de backup, logo após alocar os canais faço isso.

 

backup incremental level <incr_level>

filesperset 1

format 'c0090prd_Online_Mensal_DBF<c0090prd_%s:%t:%p>.dbf'

database;

sql 'alter system archive log current';

backup

filesperset 10

format 'c0090prd_Online_Mensal_ARC<c0090prd_%s:%t:%p>.dbf'

archivelog all

delete all input;

backup

format 'c0090prd_Online_Mensal_CTL<c0090prd_%s:%t:%p>.dbf'

current controlfile;

backup

format 'c0090prd_Online_Mensal_SPFILE<c0090prd_%s:%t:%p>.dbf'

spfile;

}

 

Grato

Ednilson

  • [oracle_br] Recover... 'Ednilson Silva' ednilson.si...@jbs.com.br [oracle_br]
    • [oracle_br] Re... jlchia...@yahoo.com.br [oracle_br]
      • RES: [orac... 'Ednilson Silva' ednilson.si...@jbs.com.br [oracle_br]
        • Re: [o... Rodrigo Mufalani rodr...@mufalani.com.br [oracle_br]
          • Re... jlchia...@yahoo.com.br [oracle_br]
            • ... 'Ednilson Silva' ednilson.si...@jbs.com.br [oracle_br]
              • ... Rodrigo Mufalani rodr...@mufalani.com.br [oracle_br]
              • ... jlchia...@yahoo.com.br [oracle_br]
                • ... 'Ednilson Silva' ednilson.si...@jbs.com.br [oracle_br]
                • ... jlchia...@yahoo.com.br [oracle_br]
                • ... 'Ednilson Silva' ednilson.si...@jbs.com.br [oracle_br]

Responder a