| database cloning using rman [message #237503] |
Mon, 14 May 2007 12:28  |
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 #238653 is a reply to message #237524] |
Fri, 18 May 2007 17:25  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
