| RMAN recovery asm backup to new database os file system [message #292158] |
Tue, 08 January 2008 01:46  |
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
|
Member |
|
|
I have an RMAN backup of my database which uses ASM. Now i want to use this backup to clone the database on another computer not using ASM. Can i do this using RMAN?
in other words can i use the set newname from duplicate or recovery technique to restore the asm backed up files as os files?
e.g
set newname file 1 to 'c:\oradata\system.dbf';
where file 1 in control file is '+data1\...\<some omf name>'.
refers to the ASM file.
|
|
|
|
| Re: RMAN recovery asm backup to new database os file system [message #293006 is a reply to message #292158] |
Thu, 10 January 2008 09:55  |
umakishore
Messages: 5
Registered: January 2008
|
Junior Member |
|
|
Use can use rman to restore Database to New server.
1.restore the controlfile to filesystem
or
alter database backup controlfile to '/u01/..../controlfile.cntrl';
and then move the controlfile to New server.
2. On primary database
SQL> select file_name from dba_data_files ;
+INFDATA/infprod/datafile/users.259.625755629
+INFDATA/infprod/datafile/sysaux.257.625755627
+INFDATA/infprod/datafile/undotbs1.258.625755629
+INFDATA/infprod/datafile/system.256.625755627
to generate list of datafiles.
select ' set newname for datafile '||file_id ||' to ''c:\oradata\'||substr(file_name,27)||''' ;'
from dba_data_files;
set newname for datafile 4 to 'c:\oradata\users.259.625755629' ;
set newname for datafile 3 to 'c:\oradata\sysaux.257.625755627' ;
set newname for datafile 2 to 'c:\oradata\undotbs1.258.625755629' ;
set newname for datafile 1 to 'c:\oradata\system.256.625755627' ;
3.Startup mount
4. restore the Database
5.recover the database
6.Alter database open resetlogs;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
