| RMAN-recovery wants more archive logs [message #278698] |
Mon, 05 November 2007 07:24  |
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 #279036 is a reply to message #278698] |
Tue, 06 November 2007 12:33  |
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 #279104 is a reply to message #278698] |
Tue, 06 November 2007 23:03 |
 |
BlackSwan
Messages: 26766
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
