| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Maintaining Simulated Standby DB on 7.1.6.0
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: Ross.Collado_at_techpac.com
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: ListGuru_at_fatcity.com (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). Received on Wed Jun 05 2002 - 20:23:23 CDT
 |
 |