|
-
K, here's what I did,
I copied the users01.dbf back.
shutdown the database
startup mount
connect internal
alter database datafile '/u03/oradata/gold/users01.dbf' online;
recover datafile '/u03/oradata/gold/users01.dbf' ;
SQL> recover database until time '2001-02-27:14:00:00';
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oradata/gold/oradata/gold/system01.dbf' <is this normal to call for this file?
so, what I did, was copied this system01.dbf file over and run through the same commands, and I got this.
SQL> recover database until time '2001-02-27:14:00:00';
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u02/oradata/gold/oradata/gold/system01.dbf'
please tell me what I did wrong?
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|