OraFAQ Forum: Backup & Recovery » ora-27040,ora-19504 no backup found

Home » RDBMS Server » Backup & Recovery » ora-27040,ora-19504 no backup found (11.2.0.3.0, linux)

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

ora-27040,ora-19504 no backup found [message #603222]

Thu, 12 December 2013 05:42

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

hi,

I am doing incomplete recover using RMAN, but it fail to perform showing error ora-27040,ora-19504 no backup found .
[code]
"set until time <DATE>"
[code]

When i remove the above statement from rman script it successfully restore backup. Only found error in when perform incomplete recovery.

I have disable flash recovery area but still there no success to perform incomplete recovery.

Thanks

Zeeshan

Report message to a moderator

Re: ora-27040,ora-19504 no backup found [message #603226 is a reply to message #603222]

Thu, 12 December 2013 06:16

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

Well that is curious:

SQL> !oerr ora 27040
27040, 00000, "file create error, unable to create file"
// *Cause:  create system call returned an error, unable to create file
// *Action: verify filename, and permissions

SQL> !oerr ora 19504
19504, 00000, "failed to create file \"%s\""
// *Cause:  call to create file returned an error
// *Action: check additional messages, check access permissions

SQL>

Can you show us exactly what you do (copy & paste) from your terminal.

Report message to a moderator

Re: ora-27040,ora-19504 no backup found [message #603228 is a reply to message #603222]

Thu, 12 December 2013 07:23

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

Senior Member
Account Moderator

For such question you have to ALWAYS copy and paste the whole sessions, the one that works and the one that does not, including ALL executed statements.

Report message to a moderator

Re: ora-27040,ora-19504 no backup found [message #603236 is a reply to message #603222]

Thu, 12 December 2013 08:01

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

https://forums.oracle.com/thread/2612508

[Edit MC: remove useless complete copy of OP's post]

[Updated on: Thu, 12 December 2013 08:24] by Moderator

Report message to a moderator

Re: ora-27040,ora-19504 no backup found [message #603258 is a reply to message #603236]

Thu, 12 December 2013 11:16

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

RMAN> run{
set until scn 3410160;
set newname for datafile 1 to '/u01/app/oracle/oradata/oranet/system01.dbf';
set newname for datafile 2 to '/u01/app/oracle/oradata/oranet/sysaux01.dbf';
set newname for datafile 3 to '/u01/app/oracle/oradata/oranet/undotbs01.dbf';
set newname for datafile 4 to '/u01/app/oracle/oradata/oranet/users01.dbf';
set newname for datafile 5 to '/u01/app/oracle/oradata/oranet/example01.dbf';
set newname for datafile 6 to '/u01/app/oracle/oradata/oranet/system02.dbf';
set newname for datafile 7 to '/u01/app/oracle/oradata/oranet/tabdbf.dbf';
restore database;
switch datafile all;
recover database ;
}

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 12-DEC-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK

datafile 7 not processed because file is offline
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/12/2013 21:31:49
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

Report message to a moderator

Re: ora-27040,ora-19504 no backup found [message #603260 is a reply to message #603258]

Thu, 12 December 2013 12:00

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

Senior Member
Account Moderator

And "scn 3410160" is what time?
Anyway, it seems you have no backup for this date (as RMAN know it).

Report message to a moderator

Re: ora-27040,ora-19504 no backup found [message #603269 is a reply to message #603258]

Thu, 12 December 2013 16:36

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

I guess you don't have the proper backupfiles (anymore) in place.

What I do not get (but maybe I have read uncarefully) is the correlation between the topic title and the errors you show us.

The topic title is "ora-27040,ora-19504 no backup found"
The errors you show are RMAN-00571 RMAN-03002 RMAN-06026 RMAN-06023

Am I missing something?

Report message to a moderator

RMAN-06023: no backup or copy of datafile 5 found to restore [message #603286 is a reply to message #603269]

Fri, 13 December 2013 00:15

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

Hi,

Thanks for your reply , actually i have manually drop a table and note the scn number before table drop from v$database view. After that i have copy rman backup to test machine and restore there, problem i am facing is that when i restore the backup without set until clause i will restore successfully but when i use set until scn or set until time it shows errors no backup found, i actually want to do incomplete recovery.

I have also disable flash recovery area to avoid increnaiton but no luck.

Thanks
Zeeshan

Report message to a moderator

Re: RMAN-06023: no backup or copy of datafile 5 found to restore [message #603290 is a reply to message #603286]

Fri, 13 December 2013 00:32

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

Senior Member
Account Moderator

Quote:

Anyway, it seems you have no backup for this date (as RMAN know it).

Report message to a moderator

Re: RMAN-06023: no backup or copy of datafile 5 found to restore [message #603334 is a reply to message #603286]

Fri, 13 December 2013 07:59

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Are the answers here any different than your same thread on OTN?

No, not really. In fact, most of the responders here are the same ones responding to your thread in OTN, just -- sometimes -- with different screen names.

[Edit MC: remove complete quote of OP's message]

[Updated on: Fri, 13 December 2013 10:13] by Moderator

Report message to a moderator

Previous Topic:	RMAN Backup
Next Topic:	Need help: reuse option in datafile!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 00:09:20 CST 2025