Home » Infrastructure » Linux » Recovery manager failed (Oracle 12.2.0.1, Linux 7.5)
Recovery manager failed [message #684320] Mon, 10 May 2021 05:13 Go to next message
BalajiDBA
Messages: 100
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 Go to previous messageGo to next message
EdStevens
Messages: 1332
Registered: September 2013
Senior Member
Quote:
I have attached the log file
Where?
Re: Recovery manager failed [message #684328 is a reply to message #684324] Mon, 10 May 2021 23:52 Go to previous messageGo to next message
BalajiDBA
Messages: 100
Registered: October 2018
Location: India
Senior Member
Quote:
Where?
I am sorry forgot to attached it.
Re: Recovery manager failed [message #684329 is a reply to message #684328] Tue, 11 May 2021 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 67920
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
BalajiDBA
Messages: 100
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
Re: Recovery manager failed [message #684335 is a reply to message #684332] Wed, 12 May 2021 01:16 Go to previous messageGo to next message
John Watson
Messages: 8580
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?

Re: Recovery manager failed [message #684336 is a reply to message #684335] Wed, 12 May 2021 01:43 Go to previous messageGo to next message
BalajiDBA
Messages: 100
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
Re: Recovery manager failed [message #684337 is a reply to message #684336] Wed, 12 May 2021 01:52 Go to previous messageGo to next message
John Watson
Messages: 8580
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.
Re: Recovery manager failed [message #684338 is a reply to message #684337] Wed, 12 May 2021 04:07 Go to previous messageGo to next message
BalajiDBA
Messages: 100
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
Re: Recovery manager failed [message #684339 is a reply to message #684338] Wed, 12 May 2021 04:17 Go to previous messageGo to next message
John Watson
Messages: 8580
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.
Re: Recovery manager failed [message #684340 is a reply to message #684339] Wed, 12 May 2021 04:27 Go to previous message
BalajiDBA
Messages: 100
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
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:
  


Current Time: Wed Jul 28 01:21:55 CDT 2021