Wednesday 22 May 2019

Remove oracle RAC database version 12c STEPS

STEP 1:

[root@srv1 ~]# crsctl status resource -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.DATA.dg
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.FRA.dg
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.asm
               ONLINE  ONLINE       srv1                     Started,STABLE
               ONLINE  ONLINE       srv2                     Started,STABLE
ora.net1.network
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.ons
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       srv1                     STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       srv1                     STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       srv1                     STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       srv1                     169.254.179.114 192.
                                                             168.10.1,STABLE
ora.cvu
      1        ONLINE  ONLINE       srv2                     STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       srv1                     Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       srv2                     STABLE
ora.rac.db
      1        ONLINE  ONLINE       srv1                     Open,STABLE
      2        ONLINE  ONLINE       srv2                     Open,STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.srv1.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.srv2.vip
      1        ONLINE  ONLINE       srv2                     STABLE
--------------------------------------------------------------------------------

STEP 2:

[oracle@srv1 deinstall]$ . oraenv
ORACLE_SID = [smr1] ? rac1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srv1 deinstall]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 30 17:25:06 2019

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> sho parameter cluster_database

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     TRUE
cluster_database_instances           integer     2
SQL> alter system set cluster_database=FALSE scope=spfile sid='*';

System altered.

SQL>


STEP 3:

[root@srv1 ~]# srvctl stop database -d rac


STEP 4 :
[oracle@srv1 deinstall]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 30 17:41:08 2019

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 1795162112 bytes
Fixed Size                  2925456 bytes
Variable Size             553651312 bytes
Database Buffers         1224736768 bytes
Redo Buffers               13848576 bytes
Database mounted.
SQL>  select instance_name,status,logins from v$Instance;

INSTANCE_NAME    STATUS       LOGINS
---------------- ------------ ----------
rac1             MOUNTED      RESTRICTED


STEP 5: 
SQL> drop database;

Database dropped.


STEP 6:

[root@srv1 ~]# srvctl remove database -db rac
Remove the database rac? (y/[n]) y
[root@srv1 ~]#

STEP 7: 

[root@srv1 ~]# crsctl status resource -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.DATA.dg
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.FRA.dg
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.asm
               ONLINE  ONLINE       srv1                     Started,STABLE
               ONLINE  ONLINE       srv2                     Started,STABLE
ora.net1.network
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.ons
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       srv1                     STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       srv1                     STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       srv1                     STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       srv1                     169.254.179.114 192.
                                                             168.10.1,STABLE
ora.cvu
      1        ONLINE  ONLINE       srv2                     STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       srv1                     Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       srv2                     STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.srv1.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.srv2.vip
      1        ONLINE  ONLINE       srv2                     STABLE
--------------------------------------------------------------------------------
[root@srv1 ~]#


Posted by at No comments:

Device "/dev/sdb1" is already labeled for ASM disk "CRS1"


  • This arcticle is for knowledge sharing



 [root@srv1 ~]# oracleasm createdisk CRS1 /dev/sdb1
Device "/dev/sdb1" is already labeled for ASM disk "CRS1"
[root@srv1 ~]# oracleasm listdisks
[root@srv1 ~]# oracleasm listdisks
[root@srv1 ~]# oracleasm createdisk CRS2 /dev/sdc1
Device "/dev/sdc1" is already labeled for ASM disk "CRS2"
[root@srv1 ~]# oracleasm createdisk CRSDATA1 /dev/sdb1
Device "/dev/sdb1" is already labeled for ASM disk "CRS1"
[root@srv1 ~]# dd if=/dev/zero of=/dev/sdb1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00149722 s, 68.4 MB/s
[root@srv1 ~]# oracleasm createdisk CRS1 /dev/sdb1
Writing disk header: done
Instantiating disk: done
[root@srv1 ~]# dd if=/dev/zero of=/dev/sdc1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00150767 s, 67.9 MB/s
[root@srv1 ~]# dd if=/dev/zero of=/dev/sdd1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00158146 s, 64.8 MB/s
[root@srv1 ~]# dd if=/dev/zero of=/dev/sde1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00163386 s, 62.7 MB/s
[root@srv1 ~]# dd if=/dev/zero of=/dev/sdf1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00152457 s, 67.2 MB/s
[root@srv1 ~]# dd if=/dev/zero of=/dev/sdd1 bs=1024 count=100

Posted by at No comments:

Consistent Backup using RMAN with no archivelog


  • This article is just for knowledge sharing.


 [oracle@srv1 scripts]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri May 3 13:40:48 2019

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


Connected to:
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> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     30
Next log sequence to archive   32
Current log sequence           32
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1795162112 bytes
Fixed Size                  2925456 bytes
Variable Size             553651312 bytes
Database Buffers         1224736768 bytes
Redo Buffers               13848576 bytes
Database mounted.
SQL> Alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     30
Current log sequence           32

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1795162112 bytes
Fixed Size                  2925456 bytes
Variable Size             553651312 bytes
Database Buffers         1224736768 bytes
Redo Buffers               13848576 bytes
Database mounted.
SQL> exit
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
[oracle@srv1 scripts]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Fri May 3 13:43:21 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SMR1 (DBID=3405103807, not open)

RMAN> BACKUP DATABASE;

Starting backup at 03-MAY-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/smr1/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/smr1/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/smr1/undotbs01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/smr1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-MAY-19
channel ORA_DISK_1: finished piece 1 at 03-MAY-19
piece handle=/u01/app/oracle/fast_recovery_area/SMR1/backupset/2019_05_03/o1_mf_nnndf_TAG20190503T134327_gdqy17v8_.bkp tag=TAG20190503T134327 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 03-MAY-19

Starting Control File and SPFILE Autobackup at 03-MAY-19
piece handle=/u01/app/oracle/fast_recovery_area/SMR1/autobackup/2019_05_03/o1_mf_s_1007300570_gdqy213t_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 03-MAY-19

RMAN> exit


Recovery Manager complete.
[oracle@srv1 scripts]$ cd /u01/app/oracle/fast_recovery_area/SMR1/backupset/2019_05_03/
[oracle@srv1 2019_05_03]$ ll
total 1280796
-rw-r-----. 1 oracle oinstall 1311531008 May  3 13:43 o1_mf_nnndf_TAG20190503T134327_gdqy17v8_.bkp
[oracle@srv1 2019_05_03]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri May 3 14:26:31 2019

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


Connected to:
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> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
SMR1      MOUNTED              PRIMARY

SQL> alter database open;

Database altered.

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
SMR1      READ WRITE           PRIMARY

SQL> exit
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
[oracle@srv1 2019_05_03]$ ll
total 1280796
-rw-r-----. 1 oracle oinstall 1311531008 May  3 13:43 o1_mf_nnndf_TAG20190503T134327_gdqy17v8_.bkp
[oracle@srv1 2019_05_03]$

Posted by at No comments:
Subscribe to: Posts (Atom)