-
We are running on Oracle 8i on HP. The source database has 4 datafiles that have the same names after someone had made changes to it. Then I am trying to clone this database to a new one by making sure these files are in separate directories. I then used a script to clone the new database as follows:
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "PSDEV8" RESETLOGS NOARCHIVELOG
MAXLOGFILES 8
MAXLOGMEMBERS 4
MAXDATAFILES 1021
MAXINSTANCES 1
MAXLOGHISTORY 680
LOGFILE
GROUP 1 (
'/u06/oradata/PSDEV8/log01.dbf',
'/u06/oradata/PSDEV8/log01_b.dbf'
) SIZE 70M,
GROUP 2 '/u06/oradata/PSDEV8/log02.dbf' SIZE 70M,
GROUP 3 '/u06/oradata/PSDEV8/log03.dbf' SIZE 70M
DATAFILE
'/u06/oradata/PSDEV8/amapp.dbf',
'/u06/oradata/PSDEV8/bdapp.dbf',
'/u06/oradata/PSDEV8/bnapp.dbf',
..
..
CHARACTER SET WE8ISO8859P15
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
#RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN RESETLOGS;
# No tempfile entries found to add.
--------------------------------------------------------------
I got the following error messages after alter database open resetlogs;
ORACLE instance started.
Total System Global Area 209243156 bytes
Fixed Size 76820 bytes
Variable Size 126189568 bytes
Database Buffers 81920000 bytes
Redo Buffers 1056768 bytes
Statement processed.
ALTER DATABASE OPEN RESETLOGS
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u06/oradata/PSDEV8/system01.dbf'
SVRMGR> select name from v$datafile;
NAME
---------------------------------------------------------------------------
I looked like Oracle got confused because of duplicated filenames or last shutdown wasn't clean?? Is there a quick way of fixing this?
-
You're getting this error because you don't have a consistent set of datafiles. I am guessing that the database was not shutdown in NORMAL or IMMEDIATE mode.
-
i feel that the last shutdown may not be a clean shutdown. What you can do is
1. Issue Revover database command first and then Alter database open resetlogs.
...thomas
