Home » RDBMS Server » Backup & Recovery » RMAN Error
RMAN Error [message #232026] Thu, 19 April 2007 02:19 Go to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/19/2007 12:11:45
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/product/clonedata/rsystem01.dbf'

Re: RMAN Error [message #232045 is a reply to message #232026] Thu, 19 April 2007 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recover more file 1.

Regards
Michel
Re: RMAN Error [message #236250 is a reply to message #232026] Wed, 09 May 2007 07:23 Go to previous messageGo to next message
kishore_dba
Messages: 21
Registered: March 2007
Location: HYDERABAD
Junior Member
RMAN>sql 'alter database open resetlogs';
Re: RMAN Error [message #236254 is a reply to message #236250] Wed, 09 May 2007 07:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is this answer?

He tried "open reset logs", Oracle said I can't and now you say try "open reset logs". Question

Regards
Michel
Re: RMAN Error [message #236338 is a reply to message #232026] Wed, 09 May 2007 12:08 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
What you did exactly.

which type of backup you have
your database running in archive log or no archive log ?

there are couple of question please provide more details
and search on board you will get lots of related thread and also search in documentation.


regards
Taj
Previous Topic: faqs
Next Topic: Flash Recovery Area
Goto Forum:
  


Current Time: Sat Dec 10 16:22:44 CST 2016

Total time taken to generate the page: 0.13688 seconds