Welcome

Anti Essays offers essay examples to help students with their essay writing.

Sign Up

Oracle Apps Dba Essay

Open Document

Below is an essay on "Oracle Apps Dba" from Anti Essays, your source for research papers, essays, and term paper examples.

Restoring oracle 10g Cold backup on different host with different directory structure.
This is very common to restore our database from one system to another system with the same database name but having different directory structure. I try to do it with cold backup. I am using windows XP and oracle 10.2.0

Steps are as follow.

1.) Go to your source database server.
C:\Documents and Settings\Administrator>sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 18 17:08:31 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

2.) This is my file structure at the source database server.

SQL> select file_name from dba_data_files;

FILE_NAME
------------------------------------------------------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF

SQL> select name from v$controlfile;
NAME
------------------------------------------------------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL

SQL> select member from v$logfile;
MEMBER
------------------------------------------------------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG

SQL> create pfile from spfile;
File created.

SQL> shutdown immediate

3.) Now copy your datafiles, controlfile, redolog file and pfile to the destination system using os copy command at place where you want it.

4.) At destination system first to create instance using (only in case of windows OS)...

Show More


Citations

MLA Citation

"Oracle Apps Dba". Anti Essays. 20 Nov. 2017

<http://www.antiessays.com/free-essays/Oracle-Apps-Dba-555634.html>

APA Citation

Oracle Apps Dba. Anti Essays. Retrieved November 20, 2017, from the World Wide Web: http://www.antiessays.com/free-essays/Oracle-Apps-Dba-555634.html