script to check mysql db user locked status

 SELECT 

    user, host, account_locked

FROM

    mysql.user

WHERE

    user = 'mysqluser' ;

mysql> CREATE USER mysqluser

    -> IDENTIFIED BY '5password67'

    -> ACCOUNT LOCK;

Query OK, 0 rows affected (2.10 sec)

mysql> SELECT

    ->     user, host, account_locked

    -> FROM

    ->     mysql.user

    -> WHERE

    ->     user = 'mysqluser' AND

    ->     host='localhost';

Empty set (0.00 sec)

mysql> SELECT

    ->     user, host, account_locked

    -> FROM

    ->     mysql.user

    -> WHERE

    ->     user = 'mysqluser' ;

+-----------+------+----------------+

| user      | host | account_locked |

+-----------+------+----------------+

| mysqluser | %    | Y              |

+-----------+------+----------------+

1 row in set (0.00 sec)

If the mysql server is performing slow than how to find out the process which is causing problem.

 If the mysql server is performing slow than how to find out the process which is causing problem.

Answer: Best way is to check with: ‘SHOW PROCESSLIST / SHOW ENGINE INNODB STATUS

script to check the uptime of a mysql database server?

SELECT
  VARIABLE_VALUE AS Uptime_seconds,
  NOW() AS "Now",
  NOW() - INTERVAL VARIABLE_VALUE SECOND AS "Up since",
  DATEDIFF(NOW(), NOW() - INTERVAL VARIABLE_VALUE SECOND) AS "Uptime_days"
FROM performance_schema.session_status
WHERE VARIABLE_NAME = 'Uptime';

 mysql> SELECT

    ->   VARIABLE_VALUE AS Uptime_seconds,

    ->   NOW() AS "Now",

    ->   NOW() - INTERVAL VARIABLE_VALUE SECOND AS "Up since",

    ->   DATEDIFF(NOW(), NOW() - INTERVAL VARIABLE_VALUE SECOND) AS "Uptime_days"

    -> FROM performance_schema.session_status

    -> WHERE VARIABLE_NAME = 'Uptime';

+----------------+---------------------+----------------------------+-------------+

| Uptime_seconds | Now                 | Up since                   | Uptime_days |

+----------------+---------------------+----------------------------+-------------+

| 100752         | 2021-12-27 10:02:34 | 2021-12-26 06:03:22.000000 |           1 |

+----------------+---------------------+----------------------------+-------------+

1 row in set (0.01 sec)

mysql> SHOW GLOBAL STATUS LIKE '%UPTIME%';

+---------------------------+--------+

| Variable_name             | Value  |

+---------------------------+--------+

| Uptime                    | 100776 |

| Uptime_since_flush_status | 100776 |

+---------------------------+--------+

2 rows in set (0.00 sec)

What are the different database engine present in MySQL?

different database engine present in MySQL

MyISAM

Heap

Merge

INNO DB

ISAM

 What are the advantages of MyISAM over InnoDB?

MyISAM follows a conservative approach to disk space management and stores each MyISAM table in a separate file, which can be further compressed if required. On the other hand, InnoDB stores the tables in the tablespace. Its further optimization is difficult.

What is InnoDB?

InnoDB is a storage database for SQL. The ACID-transactions are also provided in InnoDB and also includes support for the foreign key. Initially owned by InnobaseOY now belongs to Oracle Corporation after it acquired the latter since 2005.

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

What is ISAM?

It is a system for file management developed by IBM, which allows records to access sequentially or even randomly.

How to grant super user privilege to user in MySQL?

 Grant All Privilege's On All Databases

GRANT ALL PRIVILEGES ON * . * TO 'someuser'@'localhost';

FLUSH PRIVILEGES;

Show Grants

SHOW GRANTS FOR 'someuser'@'localhost';

How to list the tables in MySQL ?

SELECT table_name 
FROM information_schema.tables
WHERE table_schema = 'your_db_name';

mysql> use mysql;

Database changed

mysql> show tables;

+----------------------------------------------+

| Tables_in_mysql                              |

+----------------------------------------------+

| columns_priv                                 |

| component                                    |

| db                                           |

| default_roles                                |

| engine_cost                                  |

command to spool query output to another log file in MySQL

 Spooling  SQL query Output in a File in MySQL & MariaDB

mysql> use testdb;

Database changed

mysql> tee testspool.txt;

Logging to file 'testspool.txt;'

mysql> select name from emp;

mysql> notee

Outfile disabled.

commands in MySQL to get the current user and date

 mysql> SELECT CURRENT_DATE();

+----------------+

| CURRENT_DATE() |

+----------------+

| 2021-12-24     |

+----------------+

1 row in set (0.00 sec)

mysql> select current_user();

+----------------+

| current_user() |

+----------------+

| aaadbadmin@%   |

+----------------+

1 row in set (0.00 sec)

mysql> select @@datadir;

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

select @@datadir

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

+----------------------------------------+

| @@datadir                              |

+----------------------------------------+

| E:\MySQL8\MySQL\MySQL Server 8.0\Data\ |

+----------------------------------------+

1 row in set (0.00 sec)

to know the current database

mysql> SELECT DATABASE()

    -> ;

+--------------------+

| DATABASE()         |

+--------------------+

| information_schema |

+--------------------+

1 row in set (0.00 sec)

How to start/stop MySQL services in windows and Linux servers

 On Windows

If you are using Windows Open the Command Prompt and type

To Stop MySQL Service:

net stop MySQL80 

To Start MySQL Service:

net start MySQL80

On Linux

# /etc/init.d/mysqld start

# /etc/init.d/mysqld stop

# /etc/init.d/mysqld restart

command to get the parameter values in MySQL?

 

mysql> SHOW VARIABLES LIKE '%slow_query_log%';

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

SHOW VARIABLES LIKE '%slow_query_log%'

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

+---------------------+------------------------+

| Variable_name       | Value                  |

+---------------------+------------------------+

| slow_query_log      | ON                     |

| slow_query_log_file | <server_name>-slow.log |

+---------------------+------------------------+

2 rows in set (0.00 sec)

How to copy a table using CTAS (create Table as Select from ) in MySQL

 

Syntax for CTAS:

create table  <db_name.table_name> as select * from <db_name.table_name> ;

mysql> create table test3.reports_bak as select * from reports;

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

create table test3.reports_bak as select * from reports

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

Query OK, 55 rows affected (0.04 sec)

Records: 55  Duplicates: 0  Warnings: 0

mysql> use test3;

Database changed

mysql> show tables;

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

show tables

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

+-----------------+

| Tables_in_test3 |

+-----------------+

| reports_bak     |

+-----------------+

1 row in set (0.00 sec)

create/Drop database in MySQL?

 mysql> create database test1;

when you create DB on ,it will create directory under data with db name and under this Directory  all the tables will be added.

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

create database test1

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

Query OK, 1 row affected (0.00 sec)

mysql> SELECT schema_name FROM information_schema.schemata;

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

SELECT schema_name FROM information_schema.schemata

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

+------------------------+

| SCHEMA_NAME            |

+------------------------+

| mysql                  |

| information_schema     |

| performance_schema     |

| sys                    |

| aaabbbb_dba_management |

| aaabbbb_xxxxxxtdb      |

| xxxxxxt                |

| aaabbbb_xxxxxxtkdndb   |

| test3                  |

| test1                  |

+------------------------+

10 rows in set (0.00 sec)

mysql> drop database test1;

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

drop database test1

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

Query OK, 0 rows affected (0.01 sec)

mysql> SELECT schema_name FROM information_schema.schemata;

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

SELECT schema_name FROM information_schema.schemata

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

+------------------------+

| SCHEMA_NAME            |

+------------------------+

| mysql                  |

| information_schema     |

| performance_schema     |

| sys                    |

| aaabbbb_dba_management |

| aaabbbb_xxxxxxtdb      |

| xxxxxxt                |

| aaabbbb_xxxxxxtkdndb   |

| test3                  |

+------------------------+

9 rows in set (0.00 sec)

create/drop/Alter user in MySQL database?

 The following is the basic syntax to create a new user in MySQL:

CREATE USER testmysqlusr IDENTIFIED BY 'petcom123';  

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

mysql> CREATE USER testmysqlusr IDENTIFIED BY 'petcom123';

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

CREATE USER testmysqlusr IDENTIFIED BY 'petcom123'

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

Query OK, 0 rows affected (0.04 sec)

ALTER USER 'testmysqlusr'@'localhost' IDENTIFIED BY 'macd123'; 

Query OK, 0 rows affected (0.04 sec)

mysql>SHOW GRANTS FOR 'testmysqlusr'@'localhost';

mysql> SHOW GRANTS FOR 'testmysqlusr'@'localhost';

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

SHOW GRANTS FOR 'testmysqlusr'@'localhost'

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

ERROR 1141 (42000): There is no such grant defined for user 'testmysqlusr' on host 'localhost'

mysql>

mysql> drop user testmysqlusr;

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

drop user testmysqlusr

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

Query OK, 0 rows affected (0.01 sec)

How to check the MySQL version?

 How to check the MySQL version?

We can check the MySQL version on Linux using the below command:

mysql -v  

"E:\MySQL8\MySQL\MySQL Server 8.0\bin\mysql.exe" -v -u aaadbadmin -p  -h localhost -P 3430

C:\Users\_SQLAdmin>"E:\MySQL8\MySQL\MySQL Server 8.0\bin\mysql.exe" -v -u aaadbadmin -p  -h localhost -P 3430

Enter password: **********

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 204130

Server version: 8.0.22 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

How to view the database name in MySQL?

mysql>  SELECT schema_name FROM information_schema.schemata;

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

SELECT schema_name FROM information_schema.schemata

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

+------------------------+

| SCHEMA_NAME            |

+------------------------+

| mysql                  |

| information_schema     |

| performance_schema     |

| sys                    |

| aaabbbb_dba_management |

| aaabbbb_xxxxxxtdb      |

| xxxxxxt                |

| aaabbbb_xxxxxxtkdndb   |

| test3                  |

+------------------------+

9 rows in set (0.00 sec)

mysql> select db,user from mysql.db;

+------------------------+---------------+

| db                     | user          |

+------------------------+---------------+

| aaabbbb_dba_management | aaadbadmin    |

| performance_schema     | mysql.session |

| sys                    | mysql.sys     |

| aaabbbb_xxxxxxtdb      | xxxxxxt_admin |

| aaabbbb_xxxxxxtkdndb   | xxxxxxt_admin |

| xxxxxxt                | xxxxxxt_admin |

+------------------------+---------------+

6 rows in set (0.00 sec)

mysql> show databases;

+------------------------+

| Database               |

+------------------------+

| information_schema     |

| aaabbbb_dba_management |

| aaabbbb_xxxxxxtdb      |

| aaabbbb_xxxxxxtkdndb   |

| mysql                  |

| performance_schema     |

| sys                    |

| test3                  |

| xxxxxxt                |

+------------------------+

9 rows in set (0.00 sec)

How to check user privileges in MySQL database?

 mysql> SHOW GRANTS FOR 'root'@'localhost';

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Grants for root@localhost                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION                                                                                                                                               |

| GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GROUP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION |

| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

3 rows in set (0.00 sec)

mysql> select super_priv from mysql.user where user='mysqldbadmin';

+------------+

| super_priv |

+------------+

| Y          |

+------------+

1 row in set (0.00 sec)

script to check database size in MySQL?

script to  check database size in MySQL

SELECT table_schema AS 'Database Name',  

SUM(data_length + index_length) 'Size in Bytes',  

ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) 'Size in MB'  

FROM information_schema.tables  

WHERE table_schema = 'mysql'  

GROUP BY table_schema;  

+---------------+---------------+------------+

| Database Name | Size in Bytes | Size in MB |

+---------------+---------------+------------+

| mysql         |       5292032 |       5.05 |

+---------------+---------------+------------+

1 row in set (0.00 sec)

How to stop /start /status of PostgreSQL service on linux server

 How to stop /start /status of PostgreSQL service

<linux_server>>:/postgresql_SW> psql --version 

psql (PostgreSQL) 12.1pg_ctl status

<linux_server>>:/postgresql_SW>pg_ctl: server is running (PID: 16915)

/usr/pgsql-11/bin/postgres "-D" "/var/lib/pgsql/11/data"

<linux_server>>:/postgresql_SW>  pg_ctl stop

waiting for server to shut down.... done

server stopped

<linux_server>>:/postgresql_SW> pg_ctl status

pg_ctl: no server running

<linux_server>>:/postgresql_SW> pg_ctl start

waiting for server to start....2021-09-13 13:16:43.724 UTC [24156] LOG:  listening on IPv4 address "0.0.0.0", port 5432

2021-09-13 13:16:43.724 UTC [24156] LOG:  listening on IPv6 address "::", port 5432

2021-09-13 13:16:43.725 UTC [24156] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

2021-09-13 13:16:43.731 UTC [24156] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"

2021-09-13 13:16:43.747 UTC [24156] LOG:  redirecting log output to logging collector process

2021-09-13 13:16:43.747 UTC [24156] HINT:  Future log output will appear in directory "log".

 done

server started

<linux_server>>:/postgresql_SW> pg_ctl -D /var/lib/pgsql/11/data stop

waiting for server to shut down.... done

server stopped

<linux_server>>:/postgresql_SW> pg_ctl -D /var/lib/pgsql/11/data status

pg_ctl: no server running

<linux_server>>:/postgresql_SW> pg_ctl -D /var/lib/pgsql/11/data start

waiting for server to start....2021-09-13 13:17:19.374 UTC [24204] LOG:  listening on IPv4 address "0.0.0.0", port 5432

2021-09-13 13:17:19.374 UTC [24204] LOG:  listening on IPv6 address "::", port 5432

2021-09-13 13:17:19.376 UTC [24204] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

2021-09-13 13:17:19.381 UTC [24204] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"

2021-09-13 13:17:19.397 UTC [24204] LOG:  redirecting log output to logging collector process

2021-09-13 13:17:19.397 UTC [24204] HINT:  Future log output will appear in directory "log".

 done

server started

how to get DDL of table in postgreSQL using pg_dump

 how to get DDL of table in PostgreSQL

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

<linux_server>:/var/opt/pgsql11/data/tablespace/app_tablespace> pg_dump -t 'public.phonebook' -d testdb

--

-- PostgreSQL database dump

--

-- Dumped from database version 11.6

-- Dumped by pg_dump version 12.1

SET statement_timeout = 0;

SET lock_timeout = 0;

SET idle_in_transaction_session_timeout = 0;

SET client_encoding = 'SQL_ASCII';

SET standard_conforming_strings = on;

SELECT pg_catalog.set_config('search_path', '', false);

SET check_function_bodies = false;

SET xmloption = content;

SET client_min_messages = warning;

SET row_security = off;

SET default_tablespace = '';

--

-- Name: phonebook; Type: TABLE; Schema: public; Owner: postgres

--

CREATE TABLE public.phonebook (

    phone character varying(32),

    firstname character varying(32),

    lastname character varying(32),

    address character varying(64)

);

ALTER TABLE public.phonebook OWNER TO postgres;

--

-- Data for Name: phonebook; Type: TABLE DATA; Schema: public; Owner: postgres

--

COPY public.phonebook (phone, firstname, lastname, address) FROM stdin;

+1 123 456 7890 John    Doe     North America

\.

--

-- PostgreSQL database dump complete

--

script to check who is the owner of the schema in Redshift

script to check who is the owner of the schema in Redshift

select n.nspname, u.usename as owner from pg_catalog.pg_namespace n, pg_user  u where n.nspname='schema4' and n.nspowner=u.usesysid;

script to check default privilege's Applied to schema in Redshift database?

 when we provide access to Redshift schemas  objects, we need to consider providing the access to future  objects as well,so we need to grant "alter default privilege" for considering for future object.

Here is the script will check if the schema/user granted default privilege's for future object :

select pg_get_userbyid(d.defacluser) as user, 

n.nspname as schema, 

case d.defaclobjtype when 'r' then 'tables' when 'f' then 'functions' end 

as object_type, 

array_to_string(d.defaclacl, ' + ')  as default_privileges 

from pg_catalog.pg_default_acl d 

left join pg_catalog.pg_namespace n on n.oid = d.defaclnamespace;

|user                        |schema      |object_type|default_privileges                                                 |

|----------------------------|------------|-----------|-------------------------------------------------------------------|

|dbadmin_service12@domain.com|Appln_schema|tables     |group OLAP1_redshift_readwrite_qa=arwd/"dbadmin_service@domain.com"|==> which means this user has update,select,insert,Delete privileges for future creating objects/tables

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

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

<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

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

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(*)

----------

         0

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