Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

rman restore incremental level 0 backup having ERROR.

Fayaz AhmedApr 3 2014 — edited Apr 3 2014

HI,

I take the backup using following rman incremental level 0 backup and backup was successfully done, but when we restore it following error received.

Backup:

========================================================================================

#!/bin/bash

OF=sales-$(date +%Y%m%d)

export ORACLE_HOME=/d01/oracle/app/product/10.2.0/dbhome_1

export ORACLE_SID=sales

export PATH=$PATH:$ORACLE_HOME/bin

rman target=/ log=/home/oracle/rmanlogs/RMAN-$OF.log <<EOF

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

RUN

  {allocate channel ch1 type disk;

  backup as compressed backupset

  format '/backup/$OF-df%p-%s.bk'

  INCREMENTAL LEVEL 0 DATABASE  include current controlfile ;

  SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT' ;

  }

EOF

exit

========================================================================================

ERROR:

========================================================================================

RMAN> catalog backuppiece '/d01/sales-20140403-df1-3125.bk';

Starting implicit crosscheck backup at 03-APR-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=318 devtype=DISK

Crosschecked 27 objects

Finished implicit crosscheck backup at 03-APR-14

Starting implicit crosscheck copy at 03-APR-14

using channel ORA_DISK_1

Crosschecked 2 objects

Finished implicit crosscheck copy at 03-APR-14

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_87_9bjs3khd_.arc

File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_84_9bjs0pp8_.arc

File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_83_9bjs078q_.arc

File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_82_9bjrzm0y_.arc

File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_85_9bjs1l8g_.arc

File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_86_9bjs2p9f_.arc

File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_81_9bjrym4b_.arc

cataloged backuppiece

backup piece handle=/d01/sales-20140403-df1-3125.bk recid=3112 stamp=843929241

RMAN>

RMAN> restore database;

Starting restore at 03-APR-14

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 04/03/2014 16:47:47

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

========================================================================================

please advise..

Regards,

Comments

vpulapa
When there is no data for selected prompts this will be message, you probably select a default value for the prompted columns which has data to be displayed.
915764
How to add default values for the prompted columns ? I mean do i need to add default values for each column prompts ? if yes how can i do it in 11.1.1.5
MuRam
Hi,

While creating prompts. you can see the properties as "Default" , here you can add specific values or variables.

Regards,
MuRam

NOTE: Please mention if this resolved your problem/still facing and close the thread to assist others with similar problems.
915764
Thanks for the reply ram, i have specified a value. Even then i am facing the same issue
Dhar
Hi,

I think this is due to the the prompt value with which the report run previously, is not available now.

Say, you run the child report with a value 'A' in the prompt.
Next time, when the parent report does not have value 'A' for whatever the reason may be, the child report shows up this message.

So, to take off this message, you use a value which is always available( not always the option though ;)) or use some dummy value.

Thank you,
Dhar
915764
Still the problem persists
17194
Our problem got fixed, by removing the filters and adding them back in.
1 person found this helpful
1012455
Hello,

This issue is caused by having saved prompt value in the analysis.
Check if there is a staticMemberGroup tag present in your analysis XML (edit the analysis and go to Advanced tab to see the XML). Within the staticMemberGroup element will be your saved value.

How to fix this:
Remove the column from the prompt section of the analysis. You can move it to excluded columns or remove it from the report completely. Purpose of this is to get the analysis refreshed so we get new XML without the saved value.
After the analysis is refreshed you can put the column back to the prompts section and save.
Check the XML again and make sure that staticMemberGroup element is not present.

The important thing here is not to choose any value in your prompt while you are in edit mode before you save the analysis. This is how a static value gets saved in the XML.

Regards,
N
2 people found this helpful
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 1 2014
Added on Apr 3 2014
#and, #audit, #connection, #dba, #em, #java, #manager, #memory, #oem, #patch, #performance-availability, #recovery-manager-rman, #report, #security, #select, #server, #sqlplus, #tuning, #user, #xe
5 comments
2,405 views