Home » RDBMS Server » Backup & Recovery » Restore of Fresh Backup giving 06026 RMAN error (Oracle 11gR2 Standard Edition, Windows 2008 Server R2)
Restore of Fresh Backup giving 06026 RMAN error [message #636071] Wed, 15 April 2015 23:16 Go to next message
aymanzone
Messages: 9
Registered: December 2006
Junior Member
Hi,
I am restoring to same database after a fresh full backup (10-minutes old). I decided to test if backups are okay before continuing but was astounded to get the error below

RMAN> RESTORE DATABASE TO TAG T1 PREVIEW;


RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 32 found to restore
....
....
....
RMAN-06023: no backup or copy of datafile 32 found to restore



older (last week's) Backups have been created in a parent folder. The other backups (in parent folder) which are a few days old work just fine. It was not me who created the backups in the parent folder but I have a script and it is similar in all but location. I chose a subfolder as to not get confused.


I feel I'm missing something newbish.

I'm trying to restore to the same database. I am using recovery catalog.

List Backup Tag T1; works
List BackupSet Tag T1; works

so how come RESTORE DATABASE TO TAG T1; does not work.

I am using Oracle 11gR2 Standard Edition, Windows 2008 Server R2


Has anyone had this problem before?

Thank you.

[Updated on: Wed, 15 April 2015 23:16]

Report message to a moderator

Re: Restore of Fresh Backup giving 06026 RMAN error [message #636075 is a reply to message #636071] Thu, 16 April 2015 01:26 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Your command is syntactically incorrect:
RMAN>

RMAN> restore database to tag t1 preview;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "to": expecting one of: "allforeign, archivelog, backup
file, device, dump, force, foreign, from, from service, high, pluggable, preview, prima
pace, to restore point, until restore point, until, using, validate, double-quoted-stri
RMAN-01007: at line 1 column 18 file: standard input

RMAN>
What did you actually do? Please show what you did, using copy/paste, and enclosing it within [code] tags as described here, How to use [code] tags and make your code easier to read
Re: Restore of Fresh Backup giving 06026 RMAN error [message #636092 is a reply to message #636075] Thu, 16 April 2015 13:09 Go to previous messageGo to next message
aymanzone
Messages: 9
Registered: December 2006
Junior Member
Hi, You are right, it's a typo.

My Backup script

run {
  configure BACKUP OPTIMIZATION OFF
  allocate channel r1 type disk format 'D:\RMAN\RIVP\RIVPFUJ3\bkupriv_%d_%U';
  SQL "CREATE PFILE=''D:\RMAN\RIVP\RIVPFUJ3\INIT0001\INITRIVPBP.ORA'' FROM SPFILE";
  sql 'alter system archive log current'; 
  crosscheck archivelog all;    
  backup AS COMPRESSED BACKUPSET incremental level 0 filesperset 1 database include current controlfile format 'D:\RMAN\RIVP\RIVPFUJ3\bkupriv_%d_%U' ARCHIVELOG ALL TAG T1;
  sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE'; 
  sql "ALTER DATABASE BACKUP CONTROLFILE TO ''D:\RMAN\RIVP\RIVPFUJ3\CNTF0001\contf1.bkp''";  
  crosscheck backup of database;                                                           
  crosscheck backup of controlfile;
  release channel r1;
  conifgure BACKUP OPTIMIZATION ON
}     



My restore script
RMAN> RESTORE DATABASE FROM TAG T1 PREVIEW;


Starting restore at 16-APR-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/16/2015 11:03:00
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 34 found to restore
RMAN-06023: no backup or copy of datafile 33 found to restore
RMAN-06023: no backup or copy of datafile 32 found to restore
RMAN-06023: no backup or copy of datafile 31 found to restore
RMAN-06023: no backup or copy of datafile 30 found to restore
RMAN-06023: no backup or copy of datafile 29 found to restore
RMAN-06023: no backup or copy of datafile 28 found to restore
RMAN-06023: no backup or copy of datafile 27 found to restore
RMAN-06023: no backup or copy of datafile 26 found to restore
RMAN-06023: no backup or copy of datafile 25 found to restore
RMAN-06023: no backup or copy of datafile 24 found to restore
RMAN-06023: no backup or copy of datafile 21 found to restore
RMAN-06023: no backup or copy of datafile 20 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to 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: Restore of Fresh Backup giving 06026 RMAN error [message #636591 is a reply to message #636092] Tue, 28 April 2015 12:06 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Try restore without "TAG T1" and see what you get:
RESTORE DATABASE PREVIEW;

[Updated on: Tue, 28 April 2015 12:07]

Report message to a moderator

Re: Restore of Fresh Backup giving 06026 RMAN error [message #636606 is a reply to message #636092] Wed, 29 April 2015 01:18 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I just had another look at this. What are the commands that you are actually running? I know that you did not run the backup script you quoted, beause the first and last lines have errors. If you would show the commands that you are really running, and the output, then perhaps someone can help.
Re: Restore of Fresh Backup giving 06026 RMAN error [message #636624 is a reply to message #636606] Wed, 29 April 2015 07:41 Go to previous message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
John Watson wrote on Wed, 29 April 2015 07:18
I just had another look at this. What are the commands that you are actually running? I know that you did not run the backup script you quoted, beause the first and last lines have errors. If you would show the commands that you are really running, and the output, then perhaps someone can help.


Maybe he did and that's why rman can't find the files Wink
Previous Topic: Archivelog Backup
Next Topic: ORA-16038: log 2 sequence# 284 cannot be archived
Goto Forum:
  


Current Time: Thu Mar 28 15:36:07 CDT 2024