| Database is NOT coming up after Clone - Pls help !! [message #176800] |
Fri, 09 June 2006 12:58  |
humair77
Messages: 13
Registered: August 2005
|
Junior Member |
|
|
I am having issues with bring up the database after the clone. I shutdown the DB and copied all the files and then I tried to bring up Target DB and getting following mesg: I don't understand why I am getting mesg since it was a cold copy of DB
SQL> ALTER DATABASE OPEN RESETLOGS ;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/db01/oradata/hrtrcl/system01.dbf'
Used following script:
STARTUP NOMOUNT
CREATE CONTROLFILE set DATABASE "HRTCLE" RESETLOGS NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 256
MAXINSTANCES 1
MAXLOGHISTORY 21813
LOGFILE
GROUP 1 (
'/db01/oradata/hrtcle/redo01a.log',
'/db01/oradata/hrtcle/redo01b.log'
) SIZE 10M,
GROUP 2 (
'/db01/oradata/hrtcle/redo02a.log',
'/db01/oradata/hrtcle/redo02b.log'
) SIZE 10M,
GROUP 3 (
'/db01/oradata/hrtcle/redo03a.log',
'/db01/oradata/hrtcle/redo03b.log'
) SIZE 10M,
GROUP 4 (
'/db01/oradata/hrtcle/redo04a.log',
'/db01/oradata/hrtcle/redo04b.log'
) SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'/db01/oradata/hrtcle/system01.dbf',
'/db01/oradata/hrtcle/waapp.dbf',
'/db01/oradata/hrtcle/VDRINDEX.dbf',
'/db01/oradata/hrtcle/VDRDATA.dbf',
'/db01/oradata/hrtcle/sysaux01.dbf',
'/db01/oradata/hrtcle/undotbs1.dbf'
CHARACTER SET WE8ISO8859P1;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
