Bring over more archive log files

Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x26265660.[Email address protected]
Sent: Thursday, July 05, 2007 10:26 AM
To: LazyDBA Discussion
Subject: problem opening database

I did the following
startup nomount;
rman restore controlfile from autobackup;
rman alter database mount;
rman restore database;
rman recover database;

When I try to open the database I get an error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/05/2007 10:07:11
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oradata/TEMS/sys_TEMS01.dbf'
How do I fix this?


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page