Pular para o conteúdo

› Fóruns › Banco de dados Oracle › Recuperação de base dados Oracle com RMAN › Recuperação de base dados Oracle com RMAN

19 de novembro de 2013 às 3:51 pm #106133
mpungan
Participante

    Pessoal, executei conforme abaixo, mas não consigo recuperar o spfile para iniciar o recover da base de dados.

    RMAN> connect target /

    connected to target database (not started)

    RMAN> SET DBID=658221577;

    executing command: SET DBID

    RMAN> STARTUP NOMOUNT;

    Oracle instance started

    Total System Global Area 30264590336 bytes

    Fixed Size 2243112 bytes
    Variable Size 3087009240 bytes
    Database Buffers 27111981056 bytes
    Redo Buffers 63356928 bytes

    RMAN> RESTORE SPFILE FROM ‘/rman_bkp_oracle/c-658221577-20131117-02’;

    Starting restore at 19-NOV-13
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=254 device type=DISK

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 11/19/2013 09:47:31
    RMAN-06564: must use the TO clause when the instance is started with SPFILE