PROBLEMA SÉRIO RMAN!! – GPO (Grupo de Profissionais Oracle)

3 de maio de 2011 às 12:22 am #99055

vieri

Participante

então vamos as respostas:

Da sequência 351691 até 351745, verifique se foi gerado os archives.

foram gerados sim.. mas nos archives que eu restaurei estão os da sequencia
351771 até 351821, por isso não consegui fazer o recover ainda.
estou baixando mais 70Gb de arch da fita do dia 06 que é o dia do backup.

Outras dúvidas:

Esse banco de dados em algum momento esteve em NOARCHIVELOG?
não
O serviço de archive foi parado em algum momento?
não

Tente realizar o RECOVER do banco até a sequência 351690.

RMAN> recover database until sequence 351690;

RMAN> recover database until sequence 351690;

Starting recover at 02-MAY-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1086 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1084 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=1089 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=1085 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/02/2011 17:14:39
RMAN-06556: datafile 1 must be restored from backup older than scn 9832292980

Veja quantas incarnações estão no seu banco de dados.

[oracle@admbi1 archive]$ rman target /
Recovery Manager: Release 10.2.0.3.0 – Production on Mon May 2 17:15:19 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORA10G (DBID=3909485338, not open)
RMAN> list incarnation ;
using target database control file instead of recovery catalog
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

1 1 ORA10G 3909485338 CURRENT 1 16-MAY-06

Veja se existe tabelas em NOLOG ou READ-ONLY;
não
Existe alguma tablespace em READ_ONLY?
não

RMAN> run {

set dbid = 3909485338;
set until sequence 351690;
restore database preview;

} 2> 3> 4> 5> 6> 7>

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03032: this option of set command needs to be used outside of a run block

RMAN> set dbid = 3909485338;

executing command: SET DBID
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of CSET command at 05/02/2011 17:17:11
RMAN-06188: cannot use command when connected to a mounted target database

/u02/oracle/archive/1_351787_590613210.dbf
351787 1 16-MAY-06

/u02/oracle/archive/1_351788_590613210.dbf
351788 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351789_590613210.dbf
351789 1 16-MAY-06

/u02/oracle/archive/1_351790_590613210.dbf
351790 1 16-MAY-06

/u02/oracle/archive/1_351791_590613210.dbf
351791 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351792_590613210.dbf
351792 1 16-MAY-06

/u02/oracle/archive/1_351793_590613210.dbf
351793 1 16-MAY-06

/u02/oracle/archive/1_351794_590613210.dbf
351794 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351795_590613210.dbf
351795 1 16-MAY-06

/u02/oracle/archive/1_351796_590613210.dbf
351796 1 16-MAY-06

/u02/oracle/archive/1_351797_590613210.dbf
351797 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351798_590613210.dbf
351798 1 16-MAY-06

/u02/oracle/archive/1_351799_590613210.dbf
351799 1 16-MAY-06

/u02/oracle/archive/1_351800_590613210.dbf
351800 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351801_590613210.dbf
351801 1 16-MAY-06

/u02/oracle/archive/1_351802_590613210.dbf
351802 1 16-MAY-06

/u02/oracle/archive/1_351803_590613210.dbf
351803 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351804_590613210.dbf
351804 1 16-MAY-06

/u02/oracle/archive/1_351805_590613210.dbf
351805 1 16-MAY-06

/u02/oracle/archive/1_351806_590613210.dbf
351806 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351807_590613210.dbf
351807 1 16-MAY-06

/u02/oracle/archive/1_351808_590613210.dbf
351808 1 16-MAY-06

/u02/oracle/archive/1_351809_590613210.dbf
351809 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351810_590613210.dbf
351810 1 16-MAY-06

/u02/oracle/archive/1_351811_590613210.dbf
351811 1 16-MAY-06

/u02/oracle/archive/1_351812_590613210.dbf
351812 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351813_590613210.dbf
351813 1 16-MAY-06

/u02/oracle/archive/1_351814_590613210.dbf
351814 1 16-MAY-06

/u02/oracle/archive/1_351815_590613210.dbf
351815 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351816_590613210.dbf
351816 1 16-MAY-06

/u02/oracle/archive/1_351817_590613210.dbf
351817 1 16-MAY-06

/u02/oracle/archive/1_351818_590613210.dbf
351818 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351819_590613210.dbf
351819 1 16-MAY-06

/u02/oracle/archive/1_351820_590613210.dbf
351820 1 16-MAY-06

/u02/oracle/archive/1_351821_590613210.dbf
351821 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351822_590613210.dbf
351822 1 16-MAY-06

/u02/oracle/archive/1_351823_590613210.dbf
351823 1 16-MAY-06

/u02/oracle/archive/1_351824_590613210.dbf
351824 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351825_590613210.dbf
351825 1 16-MAY-06

/u02/oracle/archive/1_351826_590613210.dbf
351826 1 16-MAY-06

/u02/oracle/archive/1_351827_590613210.dbf
351827 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351828_590613210.dbf
351828 1 16-MAY-06

/u02/oracle/archive/1_351829_590613210.dbf
351829 1 16-MAY-06

/u02/oracle/archive/1_351830_590613210.dbf
351830 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351831_590613210.dbf
351831 1 16-MAY-06

/u02/oracle/archive/1_351832_590613210.dbf
351832 1 16-MAY-06

/u02/oracle/archive/1_351833_590613210.dbf
351833 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351834_590613210.dbf
351834 1 16-MAY-06

/u02/oracle/archive/1_351835_590613210.dbf
351835 1 16-MAY-06

/u02/oracle/archive/1_351836_590613210.dbf
351836 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351837_590613210.dbf
351837 1 16-MAY-06

/u02/oracle/archive/1_351838_590613210.dbf
351838 1 16-MAY-06

/u02/oracle/archive/1_351839_590613210.dbf
351839 1 16-MAY-06

NAME

SEQUENCE# RESETLOGS_CHANGE# RESETLOGS

/u02/oracle/archive/1_351840_590613210.dbf
351840 1 16-MAY-06

/u02/oracle/archive/1_351841_590613210.dbf
351841 1 16-MAY-06

🙄