Database Technology: Steps to Migrate oracle 8i Database to AWS service

All,

we got requirement to migrate our legacy oracle 8i servers to AWS server,but AWS will not support for oracle 8i,so after analyzing we have got solution from a service provided called " Stromasys".

The concept is ,Stromasys will provide emulator for all system.we used old HP-unix on top of AWS Ec2 instance and problem solved and migrating the DB to AWS now simple.

Here are the list of steps that we followed

**********************************

Here is the high level steps for this DB migration

1 Prepare the target host with requested FS and Soft link

2 Ask backup team to do restore the specific DB

3 Crosscheck & compare the number of files with Prod & Target DB on target server.

4 Modify & create the directory according to DB structure

5 Create the ctl file trace on target server

6 Modify the pfile,config,DMplus files

7 Recreate the ctl file

8 Recover the DB using until cancel and do the cancel/scn based recovery

9 Open the DB with resetlogs

11 Do the sanity check and bring down the DB

12 Create the same FS and soft link on AWS server and verify

13 Start the file copy from target server to AWS server using SFTP (includes C,R,D ,Pfile,config,DMSQL files)

14 verify the no# of CRD files on AWS server

15 Modify & create the directory according to DB structure

16 Bring up the DB on AWS server

17 Validate object count and setup any cron job required on AWS server side

Detailed steps :

*************

ora8iDB

************

oracle 8i DB migration to AWS cloud

******************************************

Stromasys legacy server expert

User:oracle On <source_server_name>

SID:ora8iDB

/opt/oracle/product/8.1.7> sqlplus "/ as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Aug 4 05:50:12 2021

<Source_server>

Connected to:

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production

JServer Release 8.1.7.4.0 - Production

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- ----------

ora8iDB READ WRITE

1.check the count CRD files count

select count(*) from dba_data_files;

data file --196

select count(member) from v$logfile;

log file--12

select count(name) from v$controlfile;

ctl file-3

Total files ==> 211

2.check the archivelog location & log seque

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/data/ora8iDB/arch/

Oldest online log sequence 281856

Next log sequence to archive 281861

Current log sequence 281861

SQL>

background_dump_dest string /opt/oracle/admin/ora8iDB/bdump

collect the CRD file detail

select file_name from dba_data_files;

FILE_NAME

----------------------------------------------------------------------------------------------------

/oracle/data/ora8iDB/data/disk01/ora8iDB_system_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_rbs01_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_temp_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_tools_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_users_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_trslus_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_trsd01_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_trsd02_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_trsd03_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_trsd04_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_trsx01_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_trsx02_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_trsx03_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_trsx04_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_other_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_other_ind_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_eo_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_eo_ind_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_testata_evt_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_testata_evt_ind_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_testata_ifd_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_testata_ifd_ind_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_testef_eo_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_testef_eo_ind_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_testef_evt_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_testef_evt_ind_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_testef_ifd_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_testef_ifd_ind_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_testef_other_ind_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_testef_other_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_slotd01_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_slotx01_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_gend01_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_gend02_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_genx01_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_genx02_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_rbs02_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_rbs03_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_rbs04_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_bakd01_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_bakd02_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_bakd03_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_bakd04_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_bakx01_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_bakx02_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_bakx03_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_bakx04_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_inv_act_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_inv_act_ind_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_ship_hist_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_ship_hist_ind_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_ord_act_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_ord_act_ind_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_lpn_dtl_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_lpn_dtl_ind_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_lpn_loc_01.dbf

/oracle/data/ora8iDB/data/disk02/ora8iDB_lpn_loc_ind_01.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_ifd_02.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_inv_act_ind_02.dbf

/oracle/data/ora8iDB/data/disk01/ora8iDB_inv_act_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_ship_hist_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_ship_hist_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_bakx02_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_bakd02_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_system_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_temp_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_bakx03_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_bakx04_01.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_eo_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_rbs01_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_rbs02_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_trsx03_03

/oracle/data/ora8iDB/data/disk03/ora8iDB_trslus_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_bakd01_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_bakx01_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_other_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_genx01_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_other_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_bakd04_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_evt_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_tools_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_users_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_trsd01_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_trsd02_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_trsd03_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_trsd04_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_trsx01_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_trsx02_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_trsx04_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_eo_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_evt_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_ifd_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_ifd_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_eo_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_eo_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_evt_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_evt_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_ifd_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_ifd_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_other_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_other_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_slotd01_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_slotx01_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_gend01_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_gend02_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_genx02_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_rbs03_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_rbs04_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_bakd03_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_ord_act_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_ord_act_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_dtl_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_dtl_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_loc_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_loc_ind_02.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_ifd_03.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_ind_03.dbf

/oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_trslus_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_trsd01_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_trsd02_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_trsd03_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_trsd04_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_trsx01_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_trsx02_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_trsx03_04.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_trsx04_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_gend01_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_gend02_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_genx01_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_genx02_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_bakd01_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_bakd02_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_bakd03_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_bakd04_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_bakx01_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_bakx02_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_bakx03_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_bakx04_02.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_inv_act_05.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_inv_act_ind_05.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_dtl_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_dtl_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_loc_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_loc_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_ord_act_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_ord_act_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbs01_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbs02_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbs03_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbs04_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_ship_hist_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_ship_hist_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_slotd01_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_slotx01_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_eo_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_eo_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_evt_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_evt_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_ifd_04.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_ifd_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_other_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_other_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_eo_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_eo_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_evt_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_evt_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_ifd_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_ifd_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_other_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_other_ind_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_system_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_temp_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_tools_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_users_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_slot_data_ts_01.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_slot_index_ts_01.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_01.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_04.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_06.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_02.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_03.dbf

/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_05.dbf

/ORACLE/ora8iDB/data5/ora8iDB_system_04.dbf

/oracle/data/ora8iDB/data/disk05/ora8iDB_testata_other_ind_04.dbf

/oracle/data/ora8iDB/data/disk05/ora8iDB_inv_act_ind_06.dbf

/oracle/data/ora8iDB/data/disk05/ora8iDB_ord_act_ind_04.dbf

/oracle/data/ora8iDB/data/disk05/ora8iDB_slot_data_ts_02.dbf

/oracle/data/ora8iDB/data/disk05/ora8iDB_bakx04_03.dbf

/oracle/data/ora8iDB/data/disk05/ora8iDB_bakd03_04.dbf

/ORACLE/ora8iDB/data5/perfstat.dbf

/oracle/data/ora8iDB/data/disk05/ora8iDB_system_05.dbf

/oracle/data/ora8iDB/data/disk06/audit_mgmt_1.dbf

/ORACLE/ora8iDB/data5/perfstat_02.dbf

196 rows selected.

select member from v$logfile;

/oracle/data/ora8iDB/redoA/ora8iDB_redo01_A.log

/oracle/data/ora8iDB/redoB/ora8iDB_redo01_B.log

/oracle/data/ora8iDB/redoB/ora8iDB_redo02_B.log

/oracle/data/ora8iDB/redoA/ora8iDB_redo02_A.log

/oracle/data/ora8iDB/redoA/ora8iDB_redo03_A.log

/oracle/data/ora8iDB/redoB/ora8iDB_redo03_B.log

/oracle/data/ora8iDB/redoB/ora8iDB_redo04_B.log

/oracle/data/ora8iDB/redoA/ora8iDB_redo04_A.log

/oracle/data/ora8iDB/redoA/ora8iDB_redo05_A.log

/oracle/data/ora8iDB/redoB/ora8iDB_redo05_B.log

/oracle/data/ora8iDB/redoB/ora8iDB_redo06_B.log

/oracle/data/ora8iDB/redoA/ora8iDB_redo06_A.log

12 rows selected.

select name from v$controlfile;

NAME

----------------------------------------------------------------------------------------------------

/oracle/data/ora8iDB/ctrl/disk01/ora8iDB_ctrl_01.ctl

/oracle/data/ora8iDB/ctrl/disk02/ora8iDB_ctrl_02.ctl

/oracle/data/ora8iDB/ctrl/disk01/ora8iDB_ctrl_03.ctl

3.add ls -ltr prefix the script

==> this used to validate the files on target server after copying from the source using the script.

*******************************

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_system_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_rbs01_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_temp_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_tools_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_users_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_trslus_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_trsd01_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_trsd02_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_trsd03_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_trsd04_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_trsx01_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_trsx02_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_trsx03_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_trsx04_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_testata_other_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_testata_other_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_testata_eo_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_testata_eo_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_testata_evt_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_testata_evt_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_testata_ifd_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_testata_ifd_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_testef_eo_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_testef_eo_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_testef_evt_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_testef_evt_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_testef_ifd_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_testef_ifd_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_testef_other_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_testef_other_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_slotd01_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_slotx01_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_gend01_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_gend02_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_genx01_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_genx02_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_rbs02_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_rbs03_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_rbs04_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_bakd01_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_bakd02_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_bakd03_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_bakd04_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_bakx01_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_bakx02_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_bakx03_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_bakx04_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_inv_act_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_inv_act_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_ship_hist_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_ship_hist_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_ord_act_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_ord_act_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_lpn_dtl_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_lpn_dtl_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_lpn_loc_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk02/ora8iDB_lpn_loc_ind_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_testata_ifd_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_inv_act_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk01/ora8iDB_inv_act_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_ship_hist_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_ship_hist_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_bakx02_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_bakd02_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_system_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_temp_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_bakx03_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_bakx04_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testata_eo_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_rbs01_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_rbs02_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_trsx03_03

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_trslus_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_bakd01_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_bakx01_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testata_other_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_genx01_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testata_other_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_bakd04_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testata_evt_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_tools_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_users_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_trsd01_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_trsd02_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_trsd03_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_trsd04_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_trsx01_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_trsx02_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_trsx04_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testata_eo_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testata_evt_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testata_ifd_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testata_ifd_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testef_eo_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testef_eo_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testef_evt_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testef_evt_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testef_ifd_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testef_ifd_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testef_other_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testef_other_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_slotd01_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_slotx01_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_gend01_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_gend02_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_genx02_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_rbs03_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_rbs04_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_bakd03_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_ord_act_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_ord_act_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_dtl_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_dtl_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_loc_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_loc_ind_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_testata_ifd_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_trslus_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_trsd01_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_trsd02_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_trsd03_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_trsd04_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_trsx01_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_trsx02_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_trsx03_04.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_trsx04_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_gend01_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_gend02_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_genx01_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_genx02_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_bakd01_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_bakd02_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_bakd03_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_bakd04_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_bakx01_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_bakx02_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_bakx03_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_bakx04_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_inv_act_05.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_inv_act_ind_05.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_dtl_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_dtl_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_loc_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_loc_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_ord_act_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_ord_act_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbs01_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbs02_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbs03_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbs04_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_ship_hist_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_ship_hist_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_slotd01_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_slotx01_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testata_eo_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testata_eo_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testata_evt_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testata_evt_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testata_ifd_04.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testata_ifd_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testata_other_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testata_other_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testef_eo_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testef_eo_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testef_evt_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testef_evt_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testef_ifd_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testef_ifd_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testef_other_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_testef_other_ind_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_system_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_temp_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_tools_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_users_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_slot_data_ts_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_slot_index_ts_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_01.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_04.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_06.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_05.dbf

ls -ltr /ORACLE/ora8iDB/data5/ora8iDB_system_04.dbf

ls -ltr /oracle/data/ora8iDB/data/disk05/ora8iDB_testata_other_ind_04.dbf

ls -ltr /oracle/data/ora8iDB/data/disk05/ora8iDB_inv_act_ind_06.dbf

ls -ltr /oracle/data/ora8iDB/data/disk05/ora8iDB_ord_act_ind_04.dbf

ls -ltr /oracle/data/ora8iDB/data/disk05/ora8iDB_slot_data_ts_02.dbf

ls -ltr /oracle/data/ora8iDB/data/disk05/ora8iDB_bakx04_03.dbf

ls -ltr /oracle/data/ora8iDB/data/disk05/ora8iDB_bakd03_04.dbf

ls -ltr /ORACLE/ora8iDB/data5/perfstat.dbf

ls -ltr /oracle/data/ora8iDB/data/disk05/ora8iDB_system_05.dbf

ls -ltr /oracle/data/ora8iDB/data/disk06/audit_mgmt_1.dbf

ls -ltr /ORACLE/ora8iDB/data5/perfstat_02.dbf

ls -ltr /oracle/data/ora8iDB/redoA/ora8iDB_redo01_A.log

ls -ltr /oracle/data/ora8iDB/redoB/ora8iDB_redo01_B.log

ls -ltr /oracle/data/ora8iDB/redoB/ora8iDB_redo02_B.log

ls -ltr /oracle/data/ora8iDB/redoA/ora8iDB_redo02_A.log

ls -ltr /oracle/data/ora8iDB/redoA/ora8iDB_redo03_A.log

ls -ltr /oracle/data/ora8iDB/redoB/ora8iDB_redo03_B.log

ls -ltr /oracle/data/ora8iDB/redoB/ora8iDB_redo04_B.log

ls -ltr /oracle/data/ora8iDB/redoA/ora8iDB_redo04_A.log

ls -ltr /oracle/data/ora8iDB/redoA/ora8iDB_redo05_A.log

ls -ltr /oracle/data/ora8iDB/redoB/ora8iDB_redo05_B.log

ls -ltr /oracle/data/ora8iDB/redoB/ora8iDB_redo06_B.log

ls -ltr /oracle/data/ora8iDB/redoA/ora8iDB_redo06_A.log

ls -ltr /oracle/data/ora8iDB/ctrl/disk01/ora8iDB_ctrl_01.ctl

ls -ltr /oracle/data/ora8iDB/ctrl/disk02/ora8iDB_ctrl_02.ctl

ls -ltr /oracle/data/ora8iDB/ctrl/disk01/ora8iDB_ctrl_03.ctl

4.modify the init.ora file and iffile and configtrslus.ora and config.ora create the respective directory on target server

User:oracle On <source_server_name>

SID:ora8iDB

/opt/oracle/admin/ora8iDB/pfile> cat initora8iDB.ora

5.edit the pfile and other 2 files according to old db structre

ifile = /opt/oracle/admin/ora8iDB/pfile/configora8iDB.ora

##############################################################################

# The following are set for DM Plus #

##############################################################################

ifile = /opt/oracle/admin/ora8iDB/pfile/configDmPlus.ora

**************************************

/opt/oracle/admin/ora8iDB/pfile> cat /opt/oracle/admin/ora8iDB/pfile/configora8iDB.ora

****************************************

6.startup the DB using the pfile with nomount and recreate the ctl file

7.take the ctl file trc from source and copy to <Target_server_name> server

ALTER DATABASE BACKUP CONTROLFILE TO TRACE-- will go to udump

8.edit the trc file and set the DB name and remove the logfile & ctl file on target location

create the controlfile trace:

********************************

9.create the directory and copy the files from source to target

mkdir -p /opt/oracle/admin/ora8iDB/pfile

mkdir -p /opt/oracle/admin/ora8iDB/bdump

mkdir -p /opt/oracle/admin/ora8iDB/udump

mkdir -p /opt/oracle/admin/ora8iDB/cdump

10.copy all CRD files from source to target server and verify if all file exist on target server and ake sure all the CRD files copied to target server.

/opt/oracle/admin/ora8iDB/pfile> wc -l files_from_prod.kshoutput.log files_from_prod.ksh

211 files_from_prod.kshoutput.log

211 files_from_prod.ksh

422 total

11.remove the ctl & redo log files from the target server before recreating the controlfile:

remove_ctl_redo_ora8iDB.ksh

CREATE CONTROLFILE SET DATABASE "ora8iDB" NORESETLOGS ARCHIVELOG

MAXLOGFILES 20

MAXLOGMEMBERS 2

MAXDATAFILES 1022

MAXINSTANCES 1

MAXLOGHISTORY 907

LOGFILE

GROUP 1 (

'/oracle/data/ora8iDB/redoA/ora8iDB_redo01_A.log',

'/oracle/data/ora8iDB/redoB/ora8iDB_redo01_B.log'

) SIZE 60M,

GROUP 2 (

'/oracle/data/ora8iDB/redoB/ora8iDB_redo02_B.log',

'/oracle/data/ora8iDB/redoA/ora8iDB_redo02_A.log'

) SIZE 60M,

GROUP 3 (

'/oracle/data/ora8iDB/redoA/ora8iDB_redo03_A.log',

'/oracle/data/ora8iDB/redoB/ora8iDB_redo03_B.log'

) SIZE 60M,

GROUP 4 (

'/oracle/data/ora8iDB/redoB/ora8iDB_redo04_B.log',

'/oracle/data/ora8iDB/redoA/ora8iDB_redo04_A.log'

) SIZE 60M,

GROUP 5 (

'/oracle/data/ora8iDB/redoA/ora8iDB_redo05_A.log',

'/oracle/data/ora8iDB/redoB/ora8iDB_redo05_B.log'

) SIZE 60M,

GROUP 6 (

'/oracle/data/ora8iDB/redoB/ora8iDB_redo06_B.log',

'/oracle/data/ora8iDB/redoA/ora8iDB_redo06_A.log'

) SIZE 60M

DATAFILE

'/oracle/data/ora8iDB/data/disk01/ora8iDB_system_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_rbs01_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_temp_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_tools_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_users_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_trslus_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_trsd01_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_trsd02_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_trsd03_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_trsd04_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_trsx01_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_trsx02_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_trsx03_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_trsx04_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_other_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_other_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_eo_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_eo_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_testata_evt_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_testata_evt_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_testata_ifd_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_testata_ifd_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_testef_eo_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_testef_eo_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_testef_evt_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_testef_evt_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_testef_ifd_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_testef_ifd_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_testef_other_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_testef_other_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_slotd01_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_slotx01_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_gend01_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_gend02_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_genx01_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_genx02_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_rbs02_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_rbs03_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_rbs04_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_bakd01_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_bakd02_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_bakd03_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_bakd04_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_bakx01_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_bakx02_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_bakx03_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_bakx04_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_inv_act_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_inv_act_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_ship_hist_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_ship_hist_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_ord_act_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_ord_act_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_lpn_dtl_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_lpn_dtl_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_lpn_loc_01.dbf',

'/oracle/data/ora8iDB/data/disk02/ora8iDB_lpn_loc_ind_01.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_testata_ifd_02.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_inv_act_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk01/ora8iDB_inv_act_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_ship_hist_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_ship_hist_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_bakx02_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_bakd02_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_system_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_temp_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_bakx03_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_bakx04_01.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_eo_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_rbs01_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_rbs02_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_trsx03_03',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_trslus_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_bakd01_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_bakx01_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_other_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_genx01_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_other_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_bakd04_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_evt_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_tools_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_users_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_trsd01_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_trsd02_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_trsd03_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_trsd04_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_trsx01_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_trsx02_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_trsx04_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_eo_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_evt_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_ifd_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_ifd_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_eo_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_eo_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_evt_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_evt_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_ifd_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_ifd_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_other_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testef_other_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_slotd01_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_slotx01_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_gend01_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_gend02_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_genx02_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_rbs03_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_rbs04_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_bakd03_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_ord_act_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_ord_act_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_dtl_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_dtl_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_loc_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_lpn_loc_ind_02.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_testata_ifd_03.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk03/ora8iDB_inv_act_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_trslus_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_trsd01_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_trsd02_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_trsd03_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_trsd04_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_trsx01_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_trsx02_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_trsx03_04.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_trsx04_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_gend01_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_gend02_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_genx01_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_genx02_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_bakd01_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_bakd02_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_bakd03_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_bakd04_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_bakx01_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_bakx02_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_bakx03_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_bakx04_02.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_inv_act_05.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_inv_act_ind_05.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_dtl_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_dtl_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_loc_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_lpn_loc_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_ord_act_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_ord_act_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbs01_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbs02_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbs03_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbs04_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_ship_hist_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_ship_hist_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_slotd01_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_slotx01_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_eo_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_eo_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_evt_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_evt_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_ifd_04.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_ifd_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_other_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testata_other_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_eo_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_eo_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_evt_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_evt_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_ifd_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_ifd_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_other_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_testef_other_ind_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_system_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_temp_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_tools_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_users_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_slot_data_ts_01.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_slot_index_ts_01.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_01.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_04.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_06.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_02.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_03.dbf',

'/oracle/data/ora8iDB/data/disk04/ora8iDB_rbsbig_05.dbf',

'/ORACLE/ora8iDB/data5/ora8iDB_system_04.dbf',

'/oracle/data/ora8iDB/data/disk05/ora8iDB_testata_other_ind_04.dbf',

'/oracle/data/ora8iDB/data/disk05/ora8iDB_inv_act_ind_06.dbf',

'/oracle/data/ora8iDB/data/disk05/ora8iDB_ord_act_ind_04.dbf',

'/oracle/data/ora8iDB/data/disk05/ora8iDB_slot_data_ts_02.dbf',

'/oracle/data/ora8iDB/data/disk05/ora8iDB_bakx04_03.dbf',

'/oracle/data/ora8iDB/data/disk05/ora8iDB_bakd03_04.dbf',

'/ORACLE/ora8iDB/data5/perfstat.dbf',

'/oracle/data/ora8iDB/data/disk05/ora8iDB_system_05.dbf',

'/oracle/data/ora8iDB/data/disk06/audit_mgmt_1.dbf',

'/ORACLE/ora8iDB/data5/perfstat_02.dbf'

CHARACTER SET WE8ISO8859P1

;

recover database using backup controlfile until cancel;

remove the redo log file and recreate the DB using controlfile

/oracle/data/ora8iDB/arch/

Target server:

startup pfile='/opt/oracle/admin/ora8iDB/pfile/initora8iDB.ora' nomount;

!ls -ltr /opt/oracle/admin/ora8iDB/pfile/*

/oracle/data/ora8iDB/arch> sqlplus ' / as sysdba'

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Aug 2 08:00:33 2021

Connected to an idle instance.

SQL> startup pfile='/opt/oracle/admin/ora8iDB/pfile/initora8iDB.ora' nomount;

ORACLE instance started.

Total System Global Area 275151892 bytes

Fixed Size 76820 bytes

Variable Size 151138304 bytes

Database Buffers 122880000 bytes

Redo Buffers 1056768 bytes

SQL> !ls -ltr /opt/oracle/admin/ora8iDB/pfile/*

-rw-rw-r-- 1 oracle dba 4839 Aug 2 07:57 /opt/oracle/admin/ora8iDB/pfile/ora8iDB_ctl.sql

12.ctl file recreation

************************

SQL> @/opt/oracle/admin/ora8iDB/pfile/ora8iDB_ctl.sql;

Control file created.

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- ----------

ora8iDB MOUNTED

SQL> select count(*) from v$backup;

SQL> select count(*) from v$recover_file;

13.Recover the DB until the last change on source Db and using the log files accordingally

*******************************************************************************************

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 1940592856157 generated at 07/12/2021 09:26:21 needed for

thread 1

ORA-00289: suggestion : /oracle/data/ora8iDB/arch/arch_ora8iDB_1_281025.arc

ORA-00280: change 1940592856157 for thread 1 is in sequence #281025

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281025.arc

ORA-00279: change 1940592860269 generated at 07/12/2021 09:42:52 needed for

thread 1

ORA-00289: suggestion : /oracle/data/ora8iDB/arch/arch_ora8iDB_1_281026.arc

ORA-00280: change 1940592860269 for thread 1 is in sequence #281026

ORA-00278: log file '/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281025.arc' no

longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281026.arc

ORA-00279: change 1940592879366 generated at 07/12/2021 10:16:44 needed for

thread 1

ORA-00289: suggestion : /oracle/data/ora8iDB/arch/arch_ora8iDB_1_281027.arc

ORA-00280: change 1940592879366 for thread 1 is in sequence #281027

ORA-00278: log file '/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281026.arc' no

longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281027.arc

ORA-00279: change 1940592898375 generated at 07/12/2021 10:58:37 needed for

thread 1

ORA-00289: suggestion : /oracle/data/ora8iDB/arch/arch_ora8iDB_1_281028.arc

ORA-00280: change 1940592898375 for thread 1 is in sequence #281028

ORA-00278: log file '/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281027.arc' no

longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281028.arc

ORA-00279: change 1940592910483 generated at 07/12/2021 11:19:13 needed for

thread 1

ORA-00289: suggestion : /oracle/data/ora8iDB/arch/arch_ora8iDB_1_281029.arc

ORA-00280: change 1940592910483 for thread 1 is in sequence #281029

ORA-00278: log file '/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281028.arc' no

longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281029.arc

ORA-00279: change 1940592923596 generated at 07/12/2021 11:44:37 needed for

thread 1

ORA-00289: suggestion : /oracle/data/ora8iDB/arch/arch_ora8iDB_1_281030.arc

ORA-00280: change 1940592923596 for thread 1 is in sequence #281030

ORA-00278: log file '/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281029.arc' no

longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281030.arc

ORA-00279: change 1940592944358 generated at 07/12/2021 12:25:35 needed for

thread 1

ORA-00289: suggestion : /oracle/data/ora8iDB/arch/arch_ora8iDB_1_281031.arc

ORA-00280: change 1940592944358 for thread 1 is in sequence #281031

ORA-00278: log file '/oracle/data/ora8iDB/arch/arch_ora8iDB_1_281030.arc' no

longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

CANCEL

Media recovery cancelled.

14.once media recovery completed ,open the DB with resetlog mode

******************************************************************

SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- ----------

ora8iDB READ WRITE

SQL> select count(*) from v$recover_file;

COUNT(*)

----------

15.finally add the DB name in oratab, this will help us to choose the SID while logging

Database Technology

Monday, November 29, 2021

Steps to Migrate oracle 8i Database to AWS service

3 comments: