Allright listers, I have been experimenting with creating a standby database for our production server. After moving all the required files files, configuring the init files, and initiating recovery on the standby instance, I saw the following error. 01547:warning RECOVER succeeded but OPEN RESETLOGS would get error below. 01152:file 1 was not restored from a sufficiently old backup
So apparently I mucked up my SYSTEM tablespace somehow in the interim. Here are the steps I followed. I am curious where I went wrong. I twice started to bring up the standby database. both times I was able to issue 'startup nomount'. The first time I attempted to mount the standby database I was greeted with a message that the control file I was pointing to was not a standby control file. I had used the control file from my hot backup, instead of following my instructions. So shutdown the DB 'shutdown normal', and created a standby control file, copied it to the three control file locations on my standby box, and started again. 'startup nomount' went as expected, then I mounted the DB in stanby mode, and then issued the recover command. Upon this completing, I was greeted with the warning I quoted above. In writing this I am pretty sure that I screwed myself up by issuing a 'shutdown normal' after my first mount attempt failed, but I figured I would go ahead and send this off to the list anyway. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
