Home » RDBMS Server » Backup & Recovery » restore online backup to different server with different dir (oracle 11g r2)
restore online backup to different server with different dir [message #606844] Wed, 29 January 2014 23:51 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
I have a oracle 11g r2 database on red hat linux.Now i want to
restore online backup to different server with different directory.

how to do it
Re: restore online backup to different server with different dir [message #606846 is a reply to message #606844] Thu, 30 January 2014 00:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmadvre.htm#BRADV89833
Re: restore online backup to different server with different dir [message #606870 is a reply to message #606846] Thu, 30 January 2014 05:20 Go to previous messageGo to next message
mrkamranumer
Messages: 11
Registered: January 2014
Junior Member
Hi dear its my lab and you can follow these steps
LAB : 4 CONVERT DATABASE (LINUX 64-BIT TO WINDOWS XP 32-BIT
1. Open source database for check current OS Version with sqlplus "/ as sysdba"
2. SQL> select * from v$transportable_platform order by 2;
3. SQL> Select platform_id,platform_name from v$database;
4. Shutdown immediate;
5. Startup mount;
6. Alter database open read only;
7. Set serveroutput on;
8. Declare
V_return Boolean;
Begin
V_return:=dbms_tdb.check_db('Microsoft Windows IA (32-bit)');
End;
/
9. PL/SQL procedure successfully completed. (Message is displayed when procedure created)
Declare
V_return Boolean;
Begin
V_return:=dbms_tdb.check_external;
End;
/
The following directories exists in the database: SYS.DATA_PUMP_DIR (message displayed)
10. PL/SQL procedure successfully completed. (Message displayed)
11. Rman target /
Convert database new database 'pms_loc' transport script '/home/oracle/pms_loc/transport.sql' db_file_name_convert '/d02/app/oracle/oradata/cagis' '/home/oracle/pms_loc/'
to platform 'Microsoft Windows IA (32-bit)';
Recovery manager complete
Exit
12. Sqlplus "/ as sysdba"
13. Create pfile ='/home/oracle/pms_loc/pms.ora' from spfile;
14. Copy '/home/oracle/pms_loc' to windows with winscp or ftp software
15. Make these directories
Cd $ORACLE_HOME
Mkdir admin
Cd admin
Mkdir pms_loc
Cd pms_loc
Mkdir adump bdump cdump udump
Cd $ORACLE_HOME
Mkdir flash_recovery_area
Mkdir oradata
Cd oradata
Mkdir pms_loc
Cp *.DBF files into windows oradata directory
For Control Files Entry you will need to open '/home/oracle/pms_loc/transport.sql' file
And modify all paths accordingly.
Sqlplus "/ as sysdba"
@transport.sql
Select count(*) from obj$ where status in (4,5,6);
/  count(*) 2862 Found
/  count(*) 2625 Found
/  count(*) 2625 Found
Select * from tab;
Enjoy this -----------------That's all

Re: restore online backup to different server with different dir [message #606938 is a reply to message #606846] Thu, 30 January 2014 22:21 Go to previous message
reyazan
Messages: 53
Registered: February 2005
Member
thanks
Previous Topic: The doubt about full db recovery via exp/imp
Next Topic: Backup Failed
Goto Forum:
  


Current Time: Thu Mar 28 07:49:58 CDT 2024