We want to make a test database from production database. And our production database is on ASM and our test machine was linux file sysetm.
see the steps how we restored it.
1) Start the test database in nomount mode
sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 – Production on Tue Oct 2 08:30:29 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2096632 bytes
Variable Size 385876488 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14680064 bytes
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
2) Restore controlfile from backup
[oracle@test rman]$ rmant target / Recovery Manager: Release 10.2.0.5.0 - Production on Tue Oct 2 08:31:07 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: prod (not…
View original post 1,039 more words