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
|
|
|
|
|
|