Thursday, 19 March 2020

Drop Oracle database Manually

oracle@8:~> . oraenv
ORACLE_SID = [] ? zabbixdr
The Oracle base remains unchanged with value /u01/app/oracle

oracle@8:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 19 08:49:16 2020

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size                  2932632 bytes
Variable Size             536871016 bytes
Database Buffers         3741319168 bytes
Redo Buffers               13844480 bytes
Database mounted.
Database opened.
SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRKORID  zabbixdr        zabbixdr                      READ WRITE           PRIMARY          NO                 0

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount exclusive restrict;
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size                  2932632 bytes
Variable Size             536871016 bytes
Database Buffers         3741319168 bytes
Redo Buffers               13844480 bytes
Database mounted.

SQL> !cat d.sql
set lines 200
select name, instance_name,db_unique_name, open_mode, database_role, flashback_on  current_scn,to_char(standby_became_primary_scn) failover_scn from v$database,v$instance;

SQL>


SQL>  @d


NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRKORID  zabbixdr        zabbixdr                      MOUNTED              PRIMARY          NO                 0

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>

alert.log file

drop database
Mon Mar 08 16:55:36 2021
Deleted file /u01/app/oracle/oradata/zabbixdr/system01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/sysaux01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/undotbs01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdbseed/system01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/users01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdbseed/sysaux01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdb1/system01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdb1/sysaux01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdb1/pdb1_users01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/redo01.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo02.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo03.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo04.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo05.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo06.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo07.log
Deleted file /u01/app/oracle/oradata/zabbixdr/temp01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdbseed/pdbseed_temp012021-02-16_05-38-06-PM.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdb1/temp012021-02-16_05-38-06-PM.dbf
Stopping background process RVWR
Starting background process RSM0
Mon Mar 08 16:55:36 2021
RSM0 started with pid=29, OS id=4553
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2t9qj0p_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2t9qncv_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2tly5jo_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2vh1307_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2w44w63_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2z99v3c_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2z9bsf4_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2z9clx4_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2zt0wq6_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j31xrxfl_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j33knsy7_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j34oh724_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j35ozjhl_.flb
Flashback Database Disabled
Deleted file /u01/app/oracle/product/12.1.0.2/db_1/dbs/snapcf_zabbixdr.f
Shutting down archive processes
Archiving is disabled
Mon Mar 08 16:55:37 2021
ARCH shutting down
ARC3: Archival stopped
Mon Mar 08 16:55:37 2021
ARCH shutting down
ARC2: Archival stopped
Mon Mar 08 16:55:37 2021
ARCH shutting down
ARC1: Archival stopped
Mon Mar 08 16:55:37 2021
ARCH shutting down
ARC0: Archival stopped
ALTER DATABASE MOUNT
ORA-750 signalled during: ALTER DATABASE MOUNT...

------------------- Same as primary single instance database  ------------------------------

oracle@test08:~> . oraenv
ORACLE_SID = [oracle] ? NEWSMRUPGR10
The Oracle base remains unchanged with value /u01/app/oracle
oracle@test08:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 24 08:29:13 2021

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

Connected to an idle instance.

SQL> startup mount exclusive restrict;
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  3712904 bytes
Variable Size            1426065528 bytes
Database Buffers          704643072 bytes
Redo Buffers               13062144 bytes
Database mounted.
SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
NEWSMRUP  NEWSMRUPGR10     NEWSMRUPGR10                   MOUNTED              PRIMARY          NO                 0

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>

alert.log

Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Tue Aug 24 08:30:56 2021
drop database
Tue Aug 24 08:30:56 2021
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/system01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/sysaux01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/undotbs01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/idata01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/ilog01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/indx01.dbf
Deleted file /u01/app/oracle/oradata/NEWSMRUPGR10/redo01.log
Deleted file /u01/app/oracle/oradata/NEWSMRUPGR10/redo02.log
Deleted file /u01/app/oracle/oradata/NEWSMRUPGR10/redo03.log
Deleted file /u01/app/oracle/oradata/NEWSMRUPGR10/temp01.dbf
Deleted file /u01/app/oracle/product/12.1.0/dbhome_1/dbs/snapcf_NEWSMRUPGR10.f
Shutting down archive processes
Archiving is disabled

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)