Restore backupset to new server

easiest way I know of...  on source system,  backup control file to trace.  copy that control file to your new server.  change the name (if you want) and the locations of the files to their new locations on the new server.  Then run that script.  Apply all archive logs and open the database.

sdstuber

Thanks for replying.

At the moment all I have are a few files with very long names these are the end product of when I used the EM to create a compressed whole archive backup set including archive_logs.
So Yes I can do what you are talking about but dont I need to use rman and create a new instance or something

can you be more specific.

Regards

Darren

1. You have to create new instance on the new server. Try to use the same directories for placing the files.

2. Copy (shutdown immediate the DB before this!) and transfer in binary mode the files: all .dbf, all controll files, password file, SPFILE, all online redo logs

3. Place them in the same folders where the same files of tne new created instance reside.

3. If the directory structure is not the same you have to mount the DB and 'rename'
all changed .dbf files:

SQL>connect
 ... idle instance
SQL>startup mount
.....
SQL>alter database rename file '/u02/main/system.dbf' to 'u02/some/enh/system.dbf'
.... this for all files .dbf with new location

SQL>alter system open

Schwertner

Thanks for the reply but I think you miss read my question

I need to do this using RMAN and the location of the files are in different locations

Sorry for the missunderstanding

Darren

Just to add the source database needs to stay online shutting down isnt an option

Sorry

Excuse me!

I did it and take a protocol. It is long.
What you prefer - to post it here or to get it by mail?
I also have posted it in the past - possibly you will be able to find it.

Found the posting. It says everything.

https://www.experts-exchange.com/questions/21068294/RMAN-recover-on-a-diferent-server.html

schwertner

Thanks again for the post s will look into these

But I have quickly looked over it and I dont see where you actually restore a backupset.
I have created a compressed backup set which comprises of 7 files but how do I get these files restored to another location so that I can do recovery using RMAN

Cheers

Darren

The backup set was registered in catalog of RMAN.
Catalog was on TEST instance and MAIN instance was backuped.

3. CREATING A FULL BACKUP OF THE main INSTANCE IN THE CATALOG

C:\>rman
RMAN>

RMAN>Connect target sys/manager@main
RMAN>Connect catalog rman/rman@test
RMAN>Shutdown immediate
RMAN>Startup mount
RMAN>Backup database;  -- full backup
RMAN>Backup current controlfile;
RMAN>alter system open



But if you are not familiar with RMAN better use the clasicall way I describer by error in my first postings.

im happy to use rman so copying the files to backup server how do they get included in the catalog

They get included in the Catalog only if you use the 'catalog' command of RMAN.
Catalog stands for schema in Oracle server that comprises the back up incarnation.

If you do not use Catalog you have to find the backup set (normaly in ORACLE_BASE directory)
and to transfer it to the restored computer.

You see RMAN is complex product and need education and training.

Thanks schwertner for the help I know what you mean by it is complex but I eager to learn :)

I need to know that I can restore a hot database to another location using RMAN using scripts as quickly as possible

This is my task set by my boss

So if you can give me as much info on what commands to use for rman to point to a backupset then restore then recover this would be good

I realise that this may be a lot and I can create another post if it will help and add more points if im allowed to do this

Darren

I have posted the main notes i did when I was in your situation and
learned how to do this.
To be honest the main source is Oracle .pdf documentation.
Given that you are in England there are many excellent American books
devoted to RMAN. It is separated Unversum - a very big utility and it is
hard to understand the notions and the principles.

OK then I will use what you have given me

Thank you for the help

Darren