How to do Oracle Binary Manual installation on new server!

Here we will discuss how to do the manual installation/configuration of oracle binary and restore database on new server using backup.

To configure the Oracle Home binary on new server or existing one backup of all we need to take the binary file backup. After that follow the below steps to configure.

Step 1: -Copy all binary files from backup.

Step 2: -Copy all dbfiles, logfiles, controlfiles and tempfles.

Step 3: -Copy pfile from backup and edit them as current database structure.

Step 4: -Grant permission on all datafiles and control files to oracle.

Step 4: -Set parameter as below.

Set Environment Variables to setup the binary to do manual installation.

export ORACLE_HOME=/u01/oracle/orahome/12c

export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=HRIS
or
PATH=$PATH:$ORACLE_HOME/bin
export PATH


Under: - oracle home.

$ cd /u01/oracle/orahome/12c
$ which sqlplus
/u01/oracle/orahome/12c/bin/sqlplus
$ sqlplus /nolog
/u01/oracle/orahome/12c/HRISDB/controlfiles
/u01/oracle/orahome/12c/admin/PROD/udump


$sqlplus /nolog
SQL>conn / sys as sysdba
Connected
SQL>starup nomount pfile='pfile.ora';
Check then db files,logfile and controlfile location and update it as located on server.
SQL> alter database mount;
SQL> select name from v$datafiles;
SQL> select member from v$logfiles;
SQL> select file_name from v$tempfile;

In Mount mode do the rename file as below: –

SQL> alter database rename file 'old file name ' to 'location.filename.dbf';

Rename all datafile and logfile then alter database tempfile ‘filename’ drop and do the alter tablespace temp file size reuse.

SQL>alter database open;

Here we will check logfile members.

SQL> SELECT MEMBER FROM V$LOGFILE;
MEMBER
--------------------------------------------------------------------------------
/oradata/HRIS/hrisdata/redofiles/redo03HRIS.log

/oradata/HRIS/hrisdata/redofiles/redo03mHRIS.log

/oradata/HRIS/hrisdata/redofiles/redo02HRIS.log

/oradata/HRIS/hrisdata/redofiles/redo02mHRIS.log

/oradata/HRIS/hrisdata/redofiles/redo01HRIS.log

/oradata/HRIS/hrisdata/redofiles/redo01mHRIS.log


SQL> select file#,ts#, status, enabled, bytes, RFILE# from v$tempfile;
FILE#TS# STATUSENABLEDBYTESRFILE#
---------- ---------- ------- ---------- ---------- ----------
52 ONLINEREAD WRITE05
62 ONLINEREAD WRITE06
72 ONLINEREAD WRITE07
82 ONLINEREAD WRITE08

ALTER TABLESPACE lmtemp ADD TEMPFILE ‘/u02/oracle/data/lmtemp02.dbf’ SIZE 18M REUSE.

After that now you are able to release database for user.