OraFAQ Forum: Backup & Recovery » error while restoring database using rman

Home » RDBMS Server » Backup & Recovery » error while restoring database using rman (oracle 10g)

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

error while restoring database using rman [message #501791]

Thu, 31 March 2011 09:26

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

hi,
i am trying to restore database using rman backup on same machine using command
RMAN> run {
2> set until sequence 23;
3> restore database;
4> recover database;
5> }
but it will give me error.

RMAN-00571: =======================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===========
RMAN-00571: =======================================================
RMAN-03002: failure of restore command at 03/31/2011 19:18:11
RMAN-06026: some targets not found - aborting 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

Rman configuration
*******************
show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\Oracle\orada
ta\rmanbackup\primary_cntrl_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'D:\Oracle\oradata\rmanbackup\full
%d%s%p.bkp';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT 'D:\Oracle\oradata\rmanbackup\full
%d%s%p.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\ORCLI\DATABASE\SNCFPRIMARY.ORA
'; # default

Report message to a moderator

Re: error while restoring database using rman [message #501792 is a reply to message #501791]

Thu, 31 March 2011 09:37

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

Cause
Some of the files specified for restore could not be found. Message 6023, 6024, or 6025 is also issued to indicate which files could not be found. Some common reasons why a file can not be restored are that there is no backup or copy of the file that is known to recovery manager, or there are no backups or copies that fall within the criteria specified on the RESTORE command, or some datafile copies have been made but not cataloged.

Action
The Recovery Manager LIST command can be used to display the backups and copies that Recovery Manager knows about. Select the files to be restored from that list.

Report message to a moderator

Re: error while restoring database using rman [message #501794 is a reply to message #501791]

Thu, 31 March 2011 09:42

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> set until sequence 23;
How did you decided on using this sequence number?
How exactly did you backup?

[Updated on: Thu, 31 March 2011 09:43]

Report message to a moderator

Re: error while restoring database using rman [message #501916 is a reply to message #501791]

Fri, 01 April 2011 07:19

shailjobgmailcom
Messages: 8
Registered: April 2011
Location: Bangalore, India

Junior Member

Can you share your Backup script , so will get some IDEA to recover your backup. From where you got sequence no.

Report message to a moderator

Previous Topic:	rman error
Next Topic:	TSPITR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 09:27:42 CDT 2024