Hi, I've got an old (test db) Oracle 7.1.6.0 db on HP-Ux. I've created a "simulated" standby db on another server of same spec. I say simulated because there is no real standby mechanism in this old version. Anyway, the standby database is mounted and on regular intervals (via cron), is doing recover database using backup controlfile until cancel. So far this arrangement is working perfectly. Now this is where it starts to become hairy. The tablespace USERS has 2 datafiles. USERS needs to be resized and the datafiles relocated.
What I've done so far are the ff: 1. exported everything in USERS 2. dropped USERS t/space on primary then recreate with new datafile size and location. 3. recreated all tables in it. 4. imported all data back. While this is happening, the primary is happily generating all these archive logs which in turn are also being applied to the standby. The standby's alert.log indicates it has applied all logs and reports no errors. I then tried to open the standby db using alter databse open resetlogs. I didn't expect this to work and sure enough I got the error: SQLDBA> alter database open resetlogs; ORA-01177: data file does not match dictionary - probably old incarnation ORA-01110: data file 5: '/u9/db/DEV/users01.dbf' users01.dbf is the old filename. My questions are: 1. Why is there no error reported? I was expecting it to complain about an unknown datafile. 2. If the standby is applying the logs where is it applying the transactions to? 3. Since there is no '... offline drop' in this version, is there any other way to get around this apart from completely recreating the standby? Any input much appreciated. Rgds, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado 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).
