Home » RDBMS Server » Backup & Recovery » database cloning using rman
database cloning using rman [message #237503] Mon, 14 May 2007 12:28 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Hello everyone,

I want to clone my production database to a development system. I have used the following RMAN script to create the backup of the database:

rman connect target /

run { shutdown immediate; startup mount; }

run
{
allocate channel ch01 type disk;
backup as compressed backupset incremental level 0 cumulative database format '/data/oradss/RMAN/%d_full_offline_%Y.%M.%D_%t' include current controlfile;
release channel ch01;
}

run { alter database open; }

The sript has been executed and the backup sets have been created on the production.
I have transferred the files to the development server and created the same mount points for datafiles on the development server.
What are the steps required to recover the database using RMAN?

FYI
OS: SuSE Linux SLES10
DB: 10.2.0.3

Thanks,
Sankalpa

[Updated on: Mon, 14 May 2007 13:30]

Report message to a moderator

Re: database cloning using rman [message #237511 is a reply to message #237503] Mon, 14 May 2007 13:31 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Can someone please let me know how to proceed.

Thanks,
Sankalpa
Re: database cloning using rman [message #237513 is a reply to message #237503] Mon, 14 May 2007 13:41 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>Can someone please let me know how to proceed.
If you do not like the quality or timeliness of any response, you are entitled to a full and complete refund.
Re: database cloning using rman [message #237522 is a reply to message #237511] Mon, 14 May 2007 14:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Claiming an answer is a sure way to shut me up.

Regards
Michel
Re: database cloning using rman [message #237524 is a reply to message #237522] Mon, 14 May 2007 14:23 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
I was not claiming an answer. I was just waiting for the feedback. Anyways thaks for the reply.
Re: database cloning using rman [message #238653 is a reply to message #237524] Fri, 18 May 2007 17:25 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
HEY
WHEN YA TOOK BACKUP THIS PARAMETER WAS SET TO ON??
CONFIGURE CONTROFILE AUTOBACKUP

IF YES THEN SIMPLY MOVE ALL BACKUP SET TO ODER MACHINE BY SCP OR WUTEVE DEN

CONNECT WID RMAN AND ENTER THE DBID (C IT FROM PRODUCTION)

RMAN> set dbid ------------
RMAN> startup nomount
rman>restore spfile from '------------------'
OR
RESTORE SPFILE FROM AUTOBACKUP;
RMAN> startup force nomount
RMAN>Restore controlfile from autobackup;
RMAN>sql 'alter database mount';
RMAN>run{
restore database;
recover database ;
};


Hope it would help you;)

[Updated on: Fri, 18 May 2007 17:36]

Report message to a moderator

Previous Topic: Database duplication
Next Topic: Loss of Controlfile
Goto Forum:
  


Current Time: Sat Dec 03 14:17:25 CST 2016

Total time taken to generate the page: 0.16020 seconds