Go Premium for a chance to win a PS4. Enter to Win


Oracle RMAN clone

Posted on 2010-08-26
Medium Priority
Last Modified: 2013-12-12
Hi guys I need to clone my database with RMAN. SO can you please tell me the steps in details
Question by:hussainkhan22
  • 3
  • 2
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 1332 total points
ID: 33531082
LVL 18

Assisted Solution

sventhan earned 668 total points
ID: 33534114

Author Comment

ID: 33534926
Hey one last question than I will close this question also.
When I take RMAN backup where does the backup is stored with catalog and without catalog. and If we need to restore this backup on different system than just copying this backup and pasting on different machine and issuing restore backup will that work
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1332 total points
ID: 33535033
The backup is stored on the database server (or disks the database server can see). The location can be tweaked with the script and spfile parameters.

What is stored in the catalog is the metadata about the backups. Things like the backup sets, archived redo logs backups etc...

With Catalog: RMAN stores all the metadata in an Oracle database. This is typically a separate database.

Without catalog: RMAN stores this metadata in the controlfile.

>>If we need to restore this backup on different system

I suggest you read about this in the docs.

You can also check out:


Author Comment

ID: 33543970
Hey I downloaded Oracle Grid 10 and its showing 2 setup files. Which one should I start with.

1. C:\Hussainkhan\gc_10205_part1of2(2)\3822442\3822442\Disk1

2. C:\Hussainkhan\gc_10205_part2of2\p3731593_10205_NT\3731593\Disk1

I have windows XP on my laptop so which one should I start with.
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33544080
>>Hey I downloaded Oracle Grid 10

Did you post this in the wrong question?

I always find starting with the first part of anything with multiple parts works best...so the first one.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question