| Restore of Fresh Backup giving 06026 RMAN error [message #636071] |
Wed, 15 April 2015 23:16  |
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  |
John Watson
Messages: 8808
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> |
|
|
|
| Re: Restore of Fresh Backup giving 06026 RMAN error [message #636092 is a reply to message #636075] |
Thu, 16 April 2015 13:09 |
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 #636606 is a reply to message #636092] |
Wed, 29 April 2015 01:18 |
John Watson
Messages: 8808
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 |
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
|
Senior Member |
|
|
John Watson wrote on Wed, 29 April 2015 07:18I 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 
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
