Home » RDBMS Server » Backup & Recovery » RMAN-recovery wants more archive logs (Oracle10g, 10.2.0.2, Windows 2003 R2)
RMAN-recovery wants more archive logs [message #278698] Mon, 05 November 2007 07:24 Go to next message
jarif
Messages: 5
Registered: September 2007
Junior Member
I'm trying a full recovery to a clean fresh machine, from an RMAN backup.

RMAN backup has it's AUTOBACKUP feature on.

I created windows services with ORADIM and connected RMAN to that.

RESTORE PFILE FROM AUTOBACKUP went fine.
RESTORE CONTROLFILE FROM AUTOBACKUP went fine.
RESTORE DATABASE went fine.

RECOVER DATABASE goes fine, until ends to a message

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: komento recover ep§onnistui kohteessa 11/05/2007 13:49:50
RMAN-11003: SQL-lauseen j§sennys/suoritus ep§onnistui: alter database recover lo
gfile 'D:\BACKUP\YTKA\ARCHIVE\ARC03347_0597505732.001'
ORA-00310: arkistoidussa lokissa on sarja 3347; tarvitaan sarja 3348
ORA-00334: arkistoitu loki: 'D:\BACKUP\YTKA\ARCHIVE\ARC03347_0597505732.001'

It proceeds to the last archived log, and then asks a nonexistent one.

Is this normal for a recovery?

ALTER DATABASE OPEN RESETLOGS goes fine after this, but I wonder that ORA-00334.

Is it normal?
Re: RMAN-recovery wants more archive logs [message #278859 is a reply to message #278698] Tue, 06 November 2007 00:39 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Do a incomplete recovery.. until cancel.
Re: RMAN-recovery wants more archive logs [message #279036 is a reply to message #278698] Tue, 06 November 2007 12:33 Go to previous messageGo to next message
jarif
Messages: 5
Registered: September 2007
Junior Member

I want to automate this process. I want that there is no operator writing "cancel" when it ends. And RMAN does not have this "until cancel" option, I think.

If this message is only cosmetic, I can live with it.

Basically I need RMAN's recover option to script a "poor man's DataGuard". The customer is not willing/able to pay for Enterprise Edition.

My DataGuard solution was already ready to implement into production, when then they heard the price tag for 4 licenses of EE (two machines, many processors).


Re: RMAN-recovery wants more archive logs [message #279099 is a reply to message #278698] Tue, 06 November 2007 22:23 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Media recovery is not automatic process.
Re: RMAN-recovery wants more archive logs [message #279104 is a reply to message #278698] Tue, 06 November 2007 23:03 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
sqlplus << EOF
/ as sysdba
set echo on term on pause off lines 131
spool /tmp/apply.log
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
RECOVER STANDBY DATABASE;
AUTO
SHUTDOWN IMMEDIATE;
SPOOL OFF
exit
EOF

Applies all available redo logfiles & then shutdown DB & exits
Previous Topic: rman error with backupexec 11d
Next Topic: faq
Goto Forum:
  


Current Time: Sun Dec 04 02:13:10 CST 2016

Total time taken to generate the page: 0.15436 seconds