Solved

Oracle RMAN clone

Posted on 2010-08-26
6
682 Views
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
0
Comment
Question by:hussainkhan22
  • 3
  • 2
6 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 333 total points
ID: 33531082
0
 
LVL 18

Assisted Solution

by:sventhan
sventhan earned 167 total points
ID: 33534114
0
 

Author Comment

by:hussainkhan22
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
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 333 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:
http://forums.oracle.com/forums/thread.jspa?threadID=1115472&tstart=0


RESTORE AND RECOVERY PROCEDURE OF PRODUCTION DATABASE BACKUP ON TEST SERVERS
0
 

Author Comment

by:hussainkhan22
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.
0
 
LVL 76

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now