-
Db Error
Guys,
I was running a query and got the following error
end of communication channel !!
I did the following to recover my DB:(linux)
1/renamed all my instance folders and re installed and removed the new ctl and dbf files from the new folders and copied the old ones to the new folder.In the past i did this it worked fine
I got the follwing messages this time after i started the DB
SVRMGR> alter database recover until cancel;
alter database recover until cancel
*
ORA-00279: change 1722310635758 generated at 11/16/02 14:20:29 needed for thread
1
ORA-00289: suggestion : /u01/app/oracle/product/8.0.5/dbs/arch1_65536.dbf
ORA-00280: change 1722310635758 for thread 1 is in sequence #65536
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01153: an incompatible media recovery is active
SVRMGR> quit
Server Manager complete.
any advise!!Any little help also much appreciated!!!
Thank you
-
I don't understand the connection between the "end-of-file on communication chanel" error, and the reason for needing a db recovery. Why were you doing the recovery?
-
DBERROR -urgen
I am sorry to confuse you all
Pls suggest what do i need to do when i get the following error or suggest me what it means
SVRMGR> alter database recover until cancel;
alter database recover until cancel
*
ORA-00279: change 1722310635758 generated at 11/16/02 14:20:29 needed for thread
1
ORA-00289: suggestion : /u01/app/oracle/product/8.0.5/dbs/arch1_65536.dbf
ORA-00280: change 1722310635758 for thread 1 is in sequence #65536
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01153: an incompatible media recovery is active
SVRMGR> quit
Server Manager complete.
-
3 years down the lane and I am getting the same error while recovering a database.. While searching user forums found this thread and it was unanswered. How to get around this?
-
version os and full errors that you are getting. Plus what you did to get the error
-
I was attempting to practice cloning a database. Found the problem, bad syntax
One that did not work (due to missing archivelog)-
recover database using backup controlfile until cancel;
One that did work (prmpted for cancel)-
recover database until cancel using backup controlfile;
All is well now. 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
|