OraFAQ Forum: Backup & Recovery » Problem after moving server

Home » RDBMS Server » Backup & Recovery » Problem after moving server (oracle 9i on solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem after moving server [message #282812]

Fri, 23 November 2007 13:37

thorin666
Messages: 144
Registered: March 2007

Senior Member

Hi i was movin from the production to development db coping datafiles and when i was opening usin resetlogs i get

ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/DESA/INTER/d01/system01.dbf'

i remember that there was a pfile parameter with the "_" before to allow to open the database anyway
My questions are 2...
first if anyone remember what´s that paramenter
second if anyone know howto fix in a noarchivelog database (i know using recover database until escape but i think that will don´t work cause noarchivelog

thnx Very Happy

Report message to a moderator

Re: Problem after moving server [message #282819 is a reply to message #282812]

Fri, 23 November 2007 18:03

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You need to do a clean shutdown before copying the files.
Seems you forgot to do that.
Starting over is much easier, instead fixing this issue.
Please be advised that those "_" parameters are supposed to be used only by the advise of Oracle Support and not a from public forum.

Report message to a moderator

Previous Topic:	rman backups
Next Topic:	NORESETLOGS when restoring from cold backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 13:09:27 CST 2024