Sunday, January 25, 2009

The issue with using 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE'

There are some issues with recover control files in RESETLOGS mode after executing 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE',


According to instruction, we need to register log files with using the following comamnd



ALTER DATABASE REGISTER LOGFILE ''


But sometimes the following error occurred

ORA-00604: error occurred at recursive SQL level" error on "ALTER DATABASE REGISTER LOGFILE '/<path>/1_234_636797930.dbf'"

And the work around is using the following command instead

ALTER DATABASE REGISTER PHYSICAL LOGFILE

15 comments:

Anonymous said...

I inclination not acquiesce in on it. I over nice post. Expressly the title-deed attracted me to read the intact story.

Anonymous said...

Genial dispatch and this fill someone in on helped me alot in my college assignement. Thanks you seeking your information.

Anonymous said...

Brim over I acquiesce in but I dream the list inform should acquire more info then it has.

Anonymous said...

Amiable dispatch and this enter helped me alot in my college assignement. Gratefulness you as your information.

Anonymous said...

Nice dispatch and this enter helped me alot in my college assignement. Thank you seeking your information.

Anonymous said...

Good fill someone in on and this post helped me alot in my college assignement. Thanks you as your information.

Anonymous said...

Good brief and this enter helped me alot in my college assignement. Gratefulness you for your information.

Anonymous said...

i absolutely enjoy all your writing way, very unique,
don't give up as well as keep writing simply because it simply just good worth to read it,
excited to find out much of your current content, kind regards!

Anonymous said...

Hello there, I discovered your blog by way of Google
while searching for a similar topic, your site got here up, it looks great.
I've bookmarked it in my google bookmarks.
Hello there, simply became alert to your blog thru Google, and located that it's really informative.
I am gonna be careful for brussels. I will appreciate
in the event you proceed this in future. Lots of
folks will be benefited out of your writing. Cheers!

Also visit my webpage ... diets that work

Anonymous said...

What's up, this weekend is pleasant for me, as this time i am reading this impressive informative paragraph here aat my house.


Alsoo visit my web site - csr racing hack android

Anonymous said...

Nice post. I learn something totally new and challenging on websites I stumbleupon everyday.
It will always be interesting to read articles from other writers and
use something from other sites.

Feel free to surf to my web page :: indettato

Anonymous said...

You can have web content material as your track record. Select installer if you
require to but don't neglect Cydia. Evi would nonetheless be accessible in the Android Marketplace, exactly where its score isn't good: three.
out of 5.

Feel free to surf to my web page :: http://emazero.it/profile/chnull [http://gameyeeeah.com/profile/clfalconer]

Anonymous said...

When I originally commented I clicked the "Notify me when new comments are added" checkbox and now each time
a comment is added I get three emails with the same comment.
Is there any way you can remove people from that service?
Bless you!

my blog post :: nordstrom coupon

Anonymous said...

WOW just what I was searching for. Came here
by searching for brain booster pills

For an awesome answer please jump over to this site :: brain booster drugs

Taj Nin Niha said...

Hi Administrator,
You posted great information about database.Its really helpful article for me.Keep it up. I'll must visit your site to get more information.

well, this is my site mobile app development

you may visit and can share your opinion with us.