-
automatic recovery
I have a standby database that i want to open and recover every week.
I cannot use dataguard, since my client does not want to buy another oracle license.
So we down the primary server once a week. And we startup the standby database to recover it.
We transfer the archive log in real time using a software.
Question:
I want the recovery process to be done automaticaly.
Here is what we do presently:
startup nomount;
alter database mount standby database;
recover standby database;
ORA-00279: change 18491383 generated at 01/02/2007 16:08:47 needed for thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_01_15\O1_MF_1_
4224_%U_.ARC
ORA-00280: change 18491383 for thread 1 is in sequence #4224
Specify log: {=suggested | filename | AUTO | CANCEL}
But oracle always ask us to enter the filename or put auto manualy. Is there a way to do this automaticaly?
-
Did you try "recover standby database automatic;" or if necessary "recover standby database automatic from location 'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_01_15\';"
-
It worked with the following:
recover automatic standby database until cancel;
Thanks
-
and you still need a license for your other server, you have an oracle instance running - you need to license it
-
They don't. They recover it while the primary is down :-D
However I belive you need a licence even if the software is installed, although not running
-
doesnt matter if the primary is down, you license the server, if it is running - you need a license (if up for more than 5 days per year in total)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|