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

EdStevens

It should.  I've use the same method for a 'one hop' link.  But if the data is at all critical, your organization is very short sighted by trying to keep an unsupported database alive.

David Luis Moya Garrido

Hello, you have to take into account the client-server certification matrix , using dblink, both sides are considered as client and server...

Mos Note: Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)

One possible option could be to use Oracle Database Gateway for ODBC using a 10g client:

Mos Note: How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows Operating Systems to Connect to Non-Oracle Databases Post Install (Doc ID 1266572.1)

Regards

3223386

from 12c you can connect to max 10g not 8 version or 9i version.

unknown-7404 
We have a requriement where we have to integrate all data in our 8i database to new database in 12.1.0.1(12c)

The recommended method is what the docs tell you

https://docs.oracle.com/database/121/UPGRD/intro.htm#UPGRD60047

You may perform a direct upgrade to Oracle Database 12c if your current Oracle Database is release 10.2.0.5, 11.1.0.7, or release 11.2.0.2 or later. If your current Oracle Database is earlier than release 10.2.0.5, or is release 11.2.0.1, then directly upgrading to Oracle Database 12c is not supported. In this case, you are required to upgrade to an intermediate release before upgrading to the new Oracle Database 12c release, or you must choose an alternative upgrade method such as export/import.

The SIMPLEST path with the fewest issues is to:

1. contact Oracle support for a download link to download the 10.2.0.5 software

2. upgrade the 8i database to that 10.2.0.5

3. upgrade that new 10.2.0.5 directly to 12c

So i can think about putting a intermediate DB like 10g and create a DB link from 8i to 10g and then from 10g to 12c another DB link.




Pls advise if this would work and any specific inputs and any other methods to go about this.

No - that will NOT work. Links are used to access data - not to create the proper infrastructure to hold that data.

If you just need the data then export it from 8i and then import it to whereever you need it.

1 - 4
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,409 views