RMAN – Recover para Standby

[LoadingXpParticipante]

O ambiente é +ASM e está tudo preparado esse ambiente é standby manual, e eu recupero através do RMAN, com archives gerados de produção.

[size=2][oracle@spinsinajb1 ~]$ rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Thu Jul 23 08:54:14 2009

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

connected to target database: SPINTCP (DBID=1040278867, not open)

RMAN> restore database;

Starting restore at 23-JUL-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=529 devtype=DISK

skipping datafile 1; already restored to file +DATADG/spintcp/system
skipping datafile 2; already restored to file +DATADG/spintcp/undo1
skipping datafile 3; already restored to file +DATADG/spintcp/sysaux
skipping datafile 4; already restored to file +DATADG/spintcp/undo2
skipping datafile 5; already restored to file +DATADG/spintcp/mt4
skipping datafile 6; already restored to file +DATADG/spintcp/hist
skipping datafile 7; already restored to file +DATADG/spintcp/tools
skipping datafile 8; already restored to file +DATADG/spintcp/tsdar
skipping datafile 9; already restored to file +DATADG/spintcp/tsdbo
skipping datafile 10; already restored to file +DATADG/spintcp/tsdcc
skipping datafile 11; already restored to file +DATADG/spintcp/tsdcf
skipping datafile 12; already restored to file +DATADG/spintcp/tsdct
skipping datafile 13; already restored to file +DATADG/spintcp/tsdcv
skipping datafile 14; already restored to file +DATADG/spintcp/tsdhb
skipping datafile 15; already restored to file +DATADG/spintcp/tsdsc
skipping datafile 16; already restored to file +DATADG/spintcp/tsdsw
skipping datafile 17; already restored to file +DATADG/spintcp/tshac
skipping datafile 18; already restored to file +DATADG/spintcp/tsiar
skipping datafile 19; already restored to file +DATADG/spintcp/tsibo
skipping datafile 20; already restored to file +DATADG/spintcp/tsicc
skipping datafile 21; already restored to file +DATADG/spintcp/tsicf
skipping datafile 22; already restored to file +DATADG/spintcp/tsict
skipping datafile 23; already restored to file +DATADG/spintcp/tsicv
skipping datafile 24; already restored to file +DATADG/spintcp/tsisc
skipping datafile 25; already restored to file +DATADG/spintcp/tsisw
skipping datafile 26; already restored to file +DATADG/spintcp/users
skipping datafile 27; already restored to file +DATADG/spintcp/hstock
skipping datafile 28; already restored to file +DATADG/spintcp/tsdomf
skipping datafile 29; already restored to file +DATADG/spintcp/tshaci
skipping datafile 30; already restored to file +DATADG/spintcp/tsiomf
skipping datafile 31; already restored to file +DATADG/spintcp/minicom
skipping datafile 32; already restored to file +DATADG/spintcp/tscedro
skipping datafile 33; already restored to file +DATADG/spintcp/tsdhbha
skipping datafile 34; already restored to file +DATADG/spintcp/tsihbha
skipping datafile 35; already restored to file +DATADG/spintcp/user_data
skipping datafile 36; already restored to file +DATADG/spintcp/minicom_001
skipping datafile 37; already restored to file +DATADG/spintcp/sisfin
skipping datafile 49; already restored to file +DATADG/spintcp/tsims.db
skipping datafile 50; already restored to file +DATADG/spintcp/tsdms.db
skipping datafile 51; already restored to file +DATADG/spintcp/tsdsc2
skipping datafile 52; already restored to file +DATADG/spintcp/tsdbo2
skipping datafile 53; already restored to file +DATADG/spintcp/tsdcc2
skipping datafile 54; already restored to file +DATADG/spintcp/minicom_001_2
skipping datafile 56; already restored to file +DATADG/spintcp/tsdms.db_2
skipping datafile 57; already restored to file +DATADG/spintcp/tsibo_2
skipping datafile 58; already restored to file +DATADG/spintcp/sisfin_2
skipping datafile 60; already restored to file +DATADG/spintcp/tsdcf_2
skipping datafile 61; already restored to file +DATADG/spintcp/tsiar_2
skipping datafile 62; already restored to file +DATADG/spintcp/tsicc_2
skipping datafile 63; already restored to file +DATADG/spintcp/tsaudits
restore not done; all files readonly, offline, or already restored
Finished restore at 23-JUL-09
[/size]

[size=9]
RMAN> recover database;

Starting recover at 23-JUL-09
using channel ORA_DISK_1

starting media recovery

unable to find archive log
archive log thread=1 sequence=182057
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/23/2009 09:03:32
RMAN-06054: media recovery requesting unknown log: thread 1 seq 182057 lowscn 10 245436450191

RMAN>[/size]