Home » RDBMS Server » Backup & Recovery » ora-27040,ora-19504 no backup found (11.2.0.3.0, linux)
ora-27040,ora-19504 no backup found [message #603222] Thu, 12 December 2013 05:42 Go to next message
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
Re: ora-27040,ora-19504 no backup found [message #603226 is a reply to message #603222] Thu, 12 December 2013 06:16 Go to previous messageGo to next message
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.
Re: ora-27040,ora-19504 no backup found [message #603228 is a reply to message #603222] Thu, 12 December 2013 07:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: ora-27040,ora-19504 no backup found [message #603236 is a reply to message #603222] Thu, 12 December 2013 08:01 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

Re: ora-27040,ora-19504 no backup found [message #603260 is a reply to message #603258] Thu, 12 December 2013 12:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: ora-27040,ora-19504 no backup found [message #603269 is a reply to message #603258] Thu, 12 December 2013 16:36 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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


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 Go to previous message
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:
  


Current Time: Thu Mar 28 05:21:12 CDT 2024