OraFAQ Forum: Linux » Recovery manager failed

Home » Infrastructure » Linux » Recovery manager failed (Oracle 12.2.0.1, Linux 7.5)

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

Recovery manager failed [message #684320]

Mon, 10 May 2021 05:13

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Hi,

While creating database using dbca, I got message "Recovery manager failed to restore datafiles. Refer logs for details".
I have attached the log file and complete message in this thread. Kindly check and suggest.

Regards,
Balaji

[Updated on: Mon, 10 May 2021 07:27]

Report message to a moderator

Re: Recovery manager failed [message #684324 is a reply to message #684320]

Mon, 10 May 2021 08:27

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Quote:

I have attached the log file

Where?

Report message to a moderator

Re: Recovery manager failed [message #684328 is a reply to message #684324]

Mon, 10 May 2021 23:52

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Quote:

Where?

I am sorry forgot to attached it.

Attachment: trace.log_2021-05-10_04-44-42-AM.txt
(Size: 737.21KB, Downloaded 3551 times)

Report message to a moderator

Re: Recovery manager failed [message #684329 is a reply to message #684328]

Tue, 11 May 2021 00:35

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you ever read the file?
The error is exactly and clearly specified.
There is NOTHING we can add to it.

[Updated on: Tue, 11 May 2021 01:24]

Report message to a moderator

Re: Recovery manager failed [message #684332 is a reply to message #684329]

Tue, 11 May 2021 05:55

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

I finally read the whole file and found below errors.

[Thread-83] [ 2021-05-10 04:51:20.033 EDT ] [StepErrorHandler.setFatalErrors:339]  setting Fatal Error: ORA-01092
[Thread-83] 
[ 2021-05-10 04:51:20.033 EDT ] [StepErrorHandler.setFatalErrors:339]  setting Fatal Error: ORA-01034

[Thread-83] [ 2021-05-10 04:51:20.033 EDT ] [StepErrorHandler.setFatalErrors:339]  setting Fatal Error: ORA-03114

[Thread-83] [ 2021-05-10 04:51:20.034 EDT ] [StepErrorHandler.setFatalErrors:339]  setting Fatal Error: ORA-12560

ORA_DISK_1: ORA-19870: error while restoring backup piece /home/app/oracle/product/12.1.0/db1/assistants/dbca/templates/Seed_Database.dfb

RMAN Output=ORA-19504: failed to create file "/usr/system01.dbf"
RMAN Output=ORA-27040: file create error, unable to create file

RMAN Output=ORA-01180: can not create datafile 1
RMAN Output=ORA-01110: data file 1: '/usr/system01.dbf'

ORA-19870: error while restoring backup piece /home/app/oracle/product/12.1.0/db1/assistants/dbca/templates/Seed_Database.dfb

Cannot run program "null/rdbms/bin/kfod": error=2, No such file or directory
Cannot run program "null/rdbms/bin/kfod": error=2, No such file or directory

There are so many ORA errors in the file.I am fed up of TROUBLESHOOTING these errors.

Regards,
Balaji

Report message to a moderator

Re: Recovery manager failed [message #684335 is a reply to message #684332]

Wed, 12 May 2021 01:16

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Quote:

I am fed up of TROUBLESHOOTING these errors.

So maybe you should take a less demanding job. Elevator operator, perhaps.

I would start with this,

RMAN Output=ORA-01180: can not create datafile 1
RMAN Output=ORA-01110: data file 1: '/usr/system01.dbf'

Why are trying to create a file in /usr? If you have some sensible reason to do so, why would Unix allow you to?

Report message to a moderator

Re: Recovery manager failed [message #684336 is a reply to message #684335]

Wed, 12 May 2021 01:43

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Quote:

So maybe you should take a less demanding job. Elevator operator, perhaps.

Awesome suggestions!

Quote:

Why are trying to create a file in /usr? If you have some sensible reason to do so, why would Unix allow you to?

If I should not create a file in /usr, then where should I create it.Kindly suggest.

Regards,
Balaji

Report message to a moderator

Re: Recovery manager failed [message #684337 is a reply to message #684336]

Wed, 12 May 2021 01:52

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

If you speak to your sys admin, he will inform you that /usr is for Unix System Resources. If you ask him for permission to create a database there, his reply may not be in the affirmative. He should come up with a better suggestion for you.

Report message to a moderator

Re: Recovery manager failed [message #684338 is a reply to message #684337]

Wed, 12 May 2021 04:07

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

I am creating a database in my personal laptop.Could you now please suggest me whom should I ask?

Regards,
Balaji

Report message to a moderator

Re: Recovery manager failed [message #684339 is a reply to message #684338]

Wed, 12 May 2021 04:17

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Well, now. You could ask yourself. However, when you ran the DBCA, one window (if I remember correctly, it is step 5 or 6 and called something like "storage options") prompts you to choose a location. Select "Use Oracle managed Files" and leave everything else on default. You can trust Uncle Oracle to look after you. Better not to fiddle with things unless you know what you are doing.

Report message to a moderator

Re: Recovery manager failed [message #684340 is a reply to message #684339]

Wed, 12 May 2021 04:27

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Quote:

You can trust Uncle Oracle to look after you. Better not to fiddle with things unless you know what you are doing.

You are my uncle for Oracle.

Regards,
Balaji

Report message to a moderator

Previous Topic:	database configuration assistant failed to detect options for this oracle installation ora-12547: tn
Next Topic:	Linux OS Kernel Panic Error on Hyper-V

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 02:07:23 CST 2024