---
title: RMAN Recovery without a Catalog
description: Recover Oracle databases without a catalogue using RMAN. Learn how to duplicate databases to a previous date/time and resolve errors for successful recovery.
image: https://claremont.co.uk/hubfs/Photo%20editors%20using%20laptop%20in%20meeting%20room%20at%20office.jpeg
---

[Skip to content](https://claremont.co.uk/blog/rman-recovery-without-a-catalog#main-content)

[Release 12.2.14 is out now! Contact us to upgrade your Oracle EBS...](https://claremont.co.uk/oracle-ebs-upgrade)

[![Claremont | Oracle E-Business Suite Services](https://claremont.co.uk/hs-fs/hubfs/Claremont%20Logos/Claremont_Logo_Blue.png?width=250&height=52&name=Claremont_Logo_Blue.png "Claremont | Oracle E-Business Suite Services")](https://www.claremont.co.uk)

[![Claremont | Oracle E-Business Suite Services](https://claremont.co.uk/hubfs/Claremont%20Logos/Claremont_logo_white.svg "Claremont | Oracle E-Business Suite Services")](https://www.claremont.co.uk)

- [About](https://claremont.co.uk/about-us)
  
  
  
  #### Claremont now part of DSP
  
  ![DSP-Logo-Blue](https://claremont.co.uk/hs-fs/hubfs/DSP%20Branding/DSP-Logo-Blue.png?width=200&height=205&name=DSP-Logo-Blue.png)In May 2022, DSP, the UK's Leading Oracle Partner acquired Claremont to further expand their Oracle expertise. The acquisition builds on DSP’s “Oracle Anywhere” strategy enabling it to deliver a 360° Oracle services portfolio and form one of the most comprehensive Oracle Partner service offerings in Europe.
  
  [Read More](https://content.dsp.co.uk/press-coverage/dsp-acquires-claremont)
  
   
  
  
  
  
  
  
  
  #### Getting to know us
  
    - [About Us](https://claremont.co.uk/about-us)
    - [Leadership](https://www.dsp.co.uk/leadership)
    - [Case Studies](https://www.dsp.co.uk/case-studies)
    - [Blogs](https://claremont.co.uk/blog)
    - [Webinars](https://www.dsp.co.uk/webinars)
    - [Events](https://www.dsp.co.uk/events)
- [Managed Services](https://claremont.co.uk/oracle-e-business-suite-managed-services)
  
  
  
  #### The Home of Oracle EBS Managed Services
  
    - [Oracle EBS Managed Service](https://claremont.co.uk/oracle-e-business-suite-managed-services)
    - [EBS DBA Support](https://claremont.co.uk/oracle-ebs-dba-support)
    - [Functional Support](https://claremont.co.uk/oracle-ebs-functional-support)
    - [Technical Support](https://claremont.co.uk/oracle-ebs-technical-support)
    - [Archive Managed Service](https://claremont.co.uk/oracle-e-business-suite-ebs-archive-managed-service)
    - [Extended Managed Service](https://claremont.co.uk/oracle-ebs-extended-managed-service)
    - [EBS Module Support](https://claremont.co.uk/oracle-ebs-module-support)
  
  
  
  
  
  
  
  
  #### National Trust Case Study
  
  ![National Trust - transparent thumbnail](https://claremont.co.uk/hs-fs/hubfs/Customer%20Logos/National%20Trust%20-%20transparent%20thumbnail.png?width=250&height=250&name=National%20Trust%20-%20transparent%20thumbnail.png)The NT uses Oracle E-Business Suite as its CRM System to manage member transactions. Our Managed Services team reduced the support backlog of incidents, problems, and changes in the NT’s CRM system.
  
  [Read More](https://www.dsp.co.uk/national-trust-oracle-ebs-managed-service-and-migration-to-claremont-case-study-cloud)
  
   
- [Consulting Services](https://claremont.co.uk/oracle-ebs-consulting)
  
  
  
  #### The UK's Leading Oracle EBS Partner
  
    - [Oracle EBS Upgrade](https://claremont.co.uk/oracle-ebs-upgrade)
    - [Oracle EBS Updates](https://claremont.co.uk/oracle-ebs-updates)
    - [Oracle EBS Licensing](https://www.dsp.co.uk/oracle-e-business-suite-licensing)
    - [Oracle EBS Extensions](https://www.dsp.co.uk/oracle-e-business-suite-extensions)
    - [Oracle EBS Mobile Apps](https://claremont.co.uk/oracle-ebs-mobile-apps)
    - [Oracle EBS Health Checks](https://claremont.co.uk/oracle-ebs-health-check)
    - [Oracle EBS Implementations](https://claremont.co.uk/oracle-ebs-implementations)
    - [Oracle ECC Deployments](https://claremont.co.uk/ecc-deployments)
  
  
  
  
  
  
  
  
  #### Unite Students Case Study
  
  ![Unite Students - transparent thumbnail](https://claremont.co.uk/hs-fs/hubfs/Customer%20Logos/Unite%20Students%20-%20transparent%20thumbnail.png?width=250&height=250&name=Unite%20Students%20-%20transparent%20thumbnail.png)Claremont has provided a solution capable of booking, managing, maintaining and analysing Unite Students’ complete property portfolio, allowing them to significantly differentiate themselves from their competitors.
  
  [Read More](https://www.dsp.co.uk/unite-students-oracle-ebs-application-implementation-case-study)
  
   
- [Hosting Services](https://claremont.co.uk/oracle-ebs-hosting-cloud-infrastructure)
  
  
  
  #### Cloud Hosting Solutions Tailored to Your Needs
  
    - [Hosting Oracle EBS on Private Cloud](https://claremont.co.uk/hosting-oracle-ebs-on-private-cloud)
    - [Hosting Oracle EBS on Public Cloud](https://claremont.co.uk/hosting-oracle-ebs-on-public-cloud)
    - [Oracle EBS Archiving](https://claremont.co.uk/oracle-ebs-archiving)
  
  
  
  
  
  
  
  
  #### Stonewater Case Study
  
  ![Stonewater](https://claremont.co.uk/hs-fs/hubfs/Customer%20Logos/Stonewater.png?width=200&height=200&name=Stonewater.png)Stonewater chose DSP to consolidate and migrate their assets to Oracle Cloud Infrastructure with an Oracle EBS Cloud Deployment, leading to a significantly reduced TCO.
  
  [Read More](https://www.dsp.co.uk/stonewater)
  
   
- More Services
  
  
  
  #### Oracle Services
  
    - [Oracle Database Managed Service](https://www.dsp.co.uk/oracle-database-managed-service)
    - [Oracle Database Consultancy Services](https://www.dsp.co.uk/oracle-consultancy)
    - [Oracle Cloud Services](https://www.dsp.co.uk/oracle-cloud-solutions-provider-csp)
    - [Oracle APEX Services](https://www.dsp.co.uk/oracle-apex-services)
    - [Oracle Licensing Services](https://www.dsp.co.uk/oracle-licensing-services)
    - [Oracle MySQL Services](https://www.dsp.co.uk/mysql-managed-services)
    - [Oracle Engineered Systems](https://www.dsp.co.uk/oracle-engineered-systems-partner)
  
  
  
  
  
  
  
  
  #### Microsoft Services
  
    - [SQL Server Managed Services](https://www.dsp.co.uk/sql-server-managed-services)
    - [SQL Server Consultancy](https://www.dsp.co.uk/sql-server-consultancy)
    - [Microsoft Azure Services](https://www.dsp.co.uk/microsoft-azure-services)
    - [Power BI Consultancy](https://www.dsp.co.uk/power-bi-services)
  
  
  
  
  
  
  
  
  #### Other Services
  
    - [Google Cloud Platform Services](https://www.dsp.co.uk/google-cloud-partner)
    - [API Development Services](https://www.dsp.co.uk/api-development-services)
    - [PostgreSQL Services](https://www.dsp.co.uk/postgresql-services)
    - [MongoDB Services](https://www.dsp.co.uk/mongodb-services)
    - [Hadoop Services](https://www.dsp.co.uk/hadoop-services)
- [Contact Us](https://claremont.co.uk/contact-us)

[Contact Us](https://claremont.co.uk/contact-us)

This is a search field with an auto-suggest feature attached.

- There are no suggestions because the search field is empty.

# RMAN Recovery without a Catalog

[Ben Morris](https://claremont.co.uk/blog/author/ben-morris) Dec 14, 2014 12:16:00 PM

### Contents

[Sep 27, 2017 5:05:00 PM Death of the Oracle DBA (Again)](https://claremont.co.uk/blog/death-of-the-oracle-dba-again) [Sep 11, 2017 3:08:00 PM Ignore Oracle Database Administration at your Peril](https://claremont.co.uk/blog/ignore-oracle-database-administration-at-your-peril) [Apr 24, 2017 5:10:00 PM A DBA shaped miracle](https://claremont.co.uk/blog/a-dba-shaped-miracle)

- [Tweet](https://twitter.com/share)

Normally recovering an **Oracle** database is a pretty straight forward affair these days when using RMAN, however, what about when you want to recover or clone a copy of a database to a previous date/time when you’re not using a recovery catalog?

A requirement arose recently whereby we needed to duplicate a LIVE database to a point in time that was several days older than the details held in RMAN. Issuing the usual duplicate commands with the “until time” values results in error, as shown below;

RMAN-00571: =========================================================  
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==============  
RMAN-00571: =========================================================  
RMAN-03002: failure of Duplicate Db command at 30/09/2014 20:10:07  
RMAN-05501: aborting duplication of target database  
RMAN-03015: error occurred in stored script Memory Script  
RMAN-06026: some targets not found - aborting restore  
RMAN-06024: no backup or copy of the control file found to restore

The obvious thing to do here is to check that a control file for the time and date required for recovery exists in the FRA (Flash Recovery Area), if it doesn’t then restoring it from a previous tape backup along with any necessary archivelogs is required.

So having recovered the necessary controlfile and archivelogs, we try the command again; this results in the exact same error.

One thing you can do is check if the RMAN catalog is aware of the controlfile, so using the command below results in ;

RMAN> list backup of controlfile completed before '30-SEP-2014';  
Specification does not match any backup in the repository

This suggests RMAN has nothing in its catalog for the date required, even though you know there is a controlfile there for the correct date/time required.

You can make RMAN read the contents of the FRA and reload into its catalog, using the command;

RMAN> catalog recovery area ;

or

RMAN> catalog controfilecopy ‘<full path and filename>’ ;

Both of these commands will be successful, however, when you try and issue the list backup command again, you get the same message ;

RMAN> list backup of controlfile completed before '30-SEP-2014';  
Specification does not match any backup in the repository

So what’s the answer? Well to affect a successful recovery you need to remove any reference to the source database catalog, so on the machine you want to create the new environment/clonetarget machine, complete the following steps;

### Step 1

Start up the target environment in a state ready to be duplicated, so we started up the instance using a predefined init.ora file as shown below;

startup nomount pfile=/app/db/tech\_st/11.2.0.4/dbs/duplicatedb.ora

The “pfile” should include the “db\_file\_name\_convert” and “db\_log\_file\_name\_convert” variables and be set correctly.

### Step 2

Next we need to login to “RMAN” but only connect to the auxiliary database, so use the command;

rman auxiliary /

### Step 3

Next we run the duplicate command, but specify where it should find the backups and what time we want it restoring back to duplicate database to NEWDB until time “to\_date(‘2014-09-30:03:50:00′,’YYYY-MM-DD:hh24:mi:ss’)” backup location ‘/backup/fast\_recovery\_area/DBLIVE’; We picked 3.50am here since the controlfile backup timestamp was 3.49, so 1 minute later RMAN will then start restoring controlfiles and mounting as normal;

Starting restore at 03-OCT-14  
allocated channel: ORA\_AUX\_DISK\_1  
channel ORA\_AUX\_DISK\_1: SID=506 device type=DISK

channel ORA\_AUX\_DISK\_1: restoring control file  
channel ORA\_AUX\_DISK\_1: restore complete, elapsed time: 00:00:01  
output file name=/oradata/DBLIVE/control01.dbf  
output file name=/redo1/DBLIVE/control02.dbf  
output file name=/redo2/DBLIVE/control03.dbf  
Finished restore at 03-OCT-14 database mounted

RMAN will then continue as any other duplicate/restore situation:  

channel ORA\_AUX\_DISK\_8: reading from backup piece  
/backup/fast\_recovery\_area/DBLIVE/backupset/2014\_09\_30/o1\_mf\_nnnd0\_FULL\_b049k9fq\_.bkp  
channel ORA\_AUX\_DISK\_9: starting datafile backup set restore  
channel ORA\_AUX\_DISK\_9: specifying datafile(s) to restore from backup set  
channel ORA\_AUX\_DISK\_9: restoring datafile 00009 to /oradata/NEWDB/odm.dbf  
channel ORA\_AUX\_DISK\_9: restoring datafile 00010 to /oradata/NEWDB/olap.dbf  
channel ORA\_AUX\_DISK\_9: restoring datafile 00017 to /oradata/NEWDB/a\_int02.dbf  
channel ORA\_AUX\_DISK\_9: restoring datafile 00024 to /oradata/NEWDB/undotbs2\_1.dbf  
channel ORA\_AUX\_DISK\_9: restoring datafile 00032 to /oradata/NEWDB/a\_txn\_data10.dbf

So in conclusion, it seems that RMAN whilst using a controlfile rather than a specific catalog, will only store records of the most recent controlfile backup and we have to be more explicit when running a restore to a point in time before that most recent controlfile backup

[Oracle Database](https://claremont.co.uk/blog/tag/oracle-database)

[Sep 27, 2017 5:05:00 PM Death of the Oracle DBA (Again)](https://claremont.co.uk/blog/death-of-the-oracle-dba-again) [Sep 11, 2017 3:08:00 PM Ignore Oracle Database Administration at your Peril](https://claremont.co.uk/blog/ignore-oracle-database-administration-at-your-peril) [Apr 24, 2017 5:10:00 PM A DBA shaped miracle](https://claremont.co.uk/blog/a-dba-shaped-miracle)

[Previous Patching and Customisations in Oracle E-Business Suite Release 12](https://claremont.co.uk/blog/patching-and-customisations-in-oracle-e-business-suite-release-12)

[Next A (less than direct) journey from Discoverer to Analytics in the Cloud with Oracle](https://claremont.co.uk/blog/a-less-than-direct-journey-from-discoverer-to-analytics-in-the-cloud-with-oracle)

#### Contact

**Sales Enquiries**

+44 (0) 203 880 1686

**Technical Support**

+44 (0) 330 058 8367

**Accounts Team**

+44 (0) 203 855 4160

[enquiries@claremont.co.uk](mailto:enquiries@claremont.co.uk)

#### Follow Us

<https://www.linkedin.com/company/dsp-oracle-e-business-suite> <https://x.com/DSP_EBS>

#### European Locations

[**London (Head Office)** 70 Gracechurch Street, London, EC3V 0HR](https://www.google.com/maps/place/70+Gracechurch+St,+Langbourn,+London+EC3V+0XL/@51.512117,-0.0869173,17z/data=!3m1!4b1!4m5!3m4!1s0x4876035256ab55cb:0x1f93b337c0190cf0!8m2!3d51.512117!4d-0.0847286)

[**Leeds** Richmond House, Lawnswood Business Park, Leeds, LS16 6QY](https://www.google.com/maps/dir/53.8405223,-1.6062773/DSP-Explorer/@53.8404788,-1.6061783,17z/data=!4m9!4m8!1m1!4e1!1m5!1m1!1s0x4879591e5d204ac9:0x4e41b926d72adca!2m2!1d-1.6064847!2d53.8404842)

[**Derby** Oberoi Business Hub](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu)  
[19/20 St Christophers Way](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu)  
[Pride Park](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu)  
[Derby](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu)  
[DE24 8JY](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu)

**[Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)**  
[Inniscarra,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)  
[Main Street,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)  
[Rathcoole,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)  
[Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)

#### North America Locations

[**Ottawa**](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu)  
[411 Legget Drive](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu)  
[Suite 701](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu)  
[Kanata](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu)  
[ON](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu)  
[K2K 3C9](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu)

[**Toronto**](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1)  
[TD Canada Trust Tower](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1)  
[161 Bay Street](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1)  
[Suite 2330](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1)  
[Toronto](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1)  
[ON](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1)  
[M5J 2S1](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1)

[**Montreal**](https://www.google.com/maps/place/725+Boulevard+de+Maisonneuve+O,+Montr%C3%A9al,+QC/@45.50201,-73.574302,15z/data=!4m5!3m4!1s0x4cc91a46787e39af:0x260be1fbf0ee774f!8m2!3d45.5040751!4d-73.5716092?ll=45.50201,-73.574302&z=15&t=m&hl=en-GB&gl=CA&mapclient=embed&q=725-999+Boulevard+de+Maisonneuve+O+Montr%C3%A9al,+QC+H3A+3L4&shorturl=1)  
[2000 McGill College Avenue 6e étage Montréal QC H3A 3H3](https://www.google.com/maps/place/725+Boulevard+de+Maisonneuve+O,+Montr%C3%A9al,+QC/@45.50201,-73.574302,15z/data=!4m5!3m4!1s0x4cc91a46787e39af:0x260be1fbf0ee774f!8m2!3d45.5040751!4d-73.5716092?ll=45.50201,-73.574302&z=15&t=m&hl=en-GB&gl=CA&mapclient=embed&q=725-999+Boulevard+de+Maisonneuve+O+Montr%C3%A9al,+QC+H3A+3L4&shorturl=1)  
[T2P 5C5](https://www.google.com/maps/place//data=!4m2!3m1!1s0x53716fe2d30437cd:0x83b76c388e1b9fee?source=g.page.share)

[**Minneapolis**](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu)  
[1650 West End Blvd](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu)  
[Suite #100](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu)  
[St Louis Park](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu)  
[Minnesota](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu)  
[USA](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu)  
[55416](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu)

#### About Us

Claremont, part of [DSP](http://www.dsp.co.uk), is the UK's leading Oracle E-Business Suite Partner. Specialising in Oracle EBS Managed Services, Consulting and Hosting.

![Oracle EBS Expertise](https://claremont.co.uk/hs-fs/hubfs/Expertise%20Logos/E-Business%20Suite/o-sell-prtnr-OracleEBS-EMEA-BENELUX-clr-rgb.png?width=150&height=87&name=o-sell-prtnr-OracleEBS-EMEA-BENELUX-clr-rgb.png)![Oracle EBS App to Oracle Cloud Expertise](https://claremont.co.uk/hs-fs/hubfs/Expertise%20Logos/EBS%20to%20OCI/Oracle%20EBS%20App%20to%20Oracle%20Cloud%20Expertise.png?width=150&height=98&name=Oracle%20EBS%20App%20to%20Oracle%20Cloud%20Expertise.png)

 

Registered Office: 2 Leman Street, London, United Kingdom, E1W 9US

Company Registration Number: 05294592

[Privacy Policy](https://www.dsp.co.uk/privacy-policy) - [Cookies Policy](https://www.dsp.co.uk/cookies-policy) - [Accessibility](https://www.dsp.co.uk/accessibility)

Copyright © 2024. Premiertec Consulting Ltd, trading as Claremont IT Services Ltd. All Right Reserved.

![Oracle EBS Partner](https://claremont.co.uk/hs-fs/hubfs/Certifications/Approachable_UKAS.jpg?width=150&height=95&name=Approachable_UKAS.jpg) ![Oracle EBS Partner](https://claremont.co.uk/hs-fs/hubfs/Certifications/new-cep-badge.png?width=100&height=119&name=new-cep-badge.png)

 

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "dateModified" : "2024-10-01",
  "datePublished" : "2024-10-01",
  "headline" : "RMAN Recovery without a Catalog",
  "image" : [ "https://144513092.fs1.hubspotusercontent-eu1.net/hubfs/144513092/Photo%20editors%20using%20laptop%20in%20meeting%20room%20at%20office.jpeg" ],
  "mainEntityOfPage" : {
    "@id" : "https://claremont.co.uk/blog/rman-recovery-without-a-catalog",
    "@type" : "WebPage"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Ben Morris",
    "url" : "https://claremont.co.uk/blog/author/ben-morris"
  },
  "dateModified" : "2024-07-10T11:16:30.647Z",
  "datePublished" : "2014-12-14T12:16:00.000Z",
  "headline" : "RMAN Recovery without a Catalog",
  "image" : [ "https://claremont.co.uk/hubfs/Photo%20editors%20using%20laptop%20in%20meeting%20room%20at%20office.jpeg" ],
  "mainEntityOfPage" : {
    "@id" : "https://claremont.co.uk/blog/rman-recovery-without-a-catalog",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://claremont.co.uk/hubfs/Claremont%20Logos/Claremont_Logo_Blue.png"
    },
    "name" : "Claremont"
  }
}
```