Oracle Database Commands and Practical Examples

Sunday, 6 June 2021

RMAN - Rman Backup using Sysbackup

Scenario:

Small example for taking rman backing using sysbackup instead sysdba

Database Name : TEST10

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN

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

TEST10 TEST10 TEST10 READ WRITE PRIMARY NO 0

Create user bkpadmin

SQL> CREATE USER bkpadmin identified by bkpadmin;

User created.

Grant sysbackup and some session privilege's to bkpadmin

SQL> GRANT SYSBACKUP TO bkpadmin;

Grant succeeded.

SQL> GRANT CREATE SESSION TO bkpadmin;

Grant succeeded.

Connect rman with bkpadmin user and with sysbackup privileges'

 
oracle@TEST10:~> rman target "'bkpadmin/bkpadmin@TEST10 as sysbackup'"
oracle@TEST10:~> vi /u02/scripts/rmanbackupstatusTEST10.sh
oracle@TEST10:~> vi /u02/scripts/rman_TEST10.sh
oracle@TEST10:~> vi /u02/scripts/rman_TEST10.sh
oracle@TEST10:~> cat /u02/scripts/rman_TEST10.sh
ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export ORACLE_HOME
ORACLE_SID=TEST10
export ORACLE_SID
/u01/app/oracle/product/12.1.0/dbhome_1/bin/rman target "'bkpadmin/bkpadmin@TEST10 as sysbackup'" @/u02/scripts/rman_TEST10.rcv >> /u02/scripts/rman_TEST10_bkp.log

Log file output rman_TEST10_bkp.log

RMAN> run

2> {

3> allocate channel c1 device type disk format '/u04/db_backup/rman/TEST10/Backup_%d_DB_%u_%s_%p_%T';

4> allocate channel c2 device type disk format '/u04/db_backup/rman/TEST10/Backup_%d_DB_%u_%s_%p_%T';

5> crosscheck archivelog all;

6> report obsolete;

7> delete noprompt obsolete;

8> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

9> BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 tag='FULL_BACKUP_Daily' DATABASE INCLUDE CURRENT CONTROLFILE FILESPERSET 1;

10> BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL;

11> #delete noprompt archivelog all backed up 1 times to disk;

12> copy current controlfile to '/u04/db_backup/rman/TEST10/control_%d_%u_%T.bak';

13> release channel c1;

14> release channel c2;

15> }

16>

using target database control file instead of recovery catalog

allocated channel: c1

channel c1: SID=619 device type=DISK

allocated channel: c2

channel c2: SID=924 device type=DISK

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2164_jbmlys9p_.arc RECID=2148 STAMP=1073280508

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2165_jbn3g8jp_.arc RECID=2149 STAMP=1073297385

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2166_jbnh15s4_.arc RECID=2150 STAMP=1073309254

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2167_jbov1d2z_.arc RECID=2151 STAMP=1073354317

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2168_jboxvhnb_.arc RECID=2152 STAMP=1073357200

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2169_jbr1gsfk_.arc RECID=2153 STAMP=1073426427

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2170_jbrhjjs5_.arc RECID=2154 STAMP=1073440818

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2171_jbrlcyhj_.arc RECID=2155 STAMP=1073443744

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2172_jbsqsq59_.arc RECID=2156 STAMP=1073482077

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2173_jbtovrr2_.arc RECID=2157 STAMP=1073512857

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2174_jbtox2rg_.arc RECID=2158 STAMP=1073512899

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2175_jbv6lqtz_.arc RECID=2159 STAMP=1073529976

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2176_jbw3kmp3_.arc RECID=2160 STAMP=1073559636

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2177_jbxb7c1r_.arc RECID=2161 STAMP=1073599244

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2178_jbxbd71c_.arc RECID=2162 STAMP=1073599400

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2179_jbxtyhm1_.arc RECID=2163 STAMP=1073616368

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2180_jbzjh1k7_.arc RECID=2164 STAMP=1073671170

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2181_jbzynpp9_.arc RECID=2165 STAMP=1073685687

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2182_jc08c8wh_.arc RECID=2166 STAMP=1073695626

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2183_jc0hc052_.arc RECID=2167 STAMP=1073702785

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2184_jc1tc751_.arc RECID=2168 STAMP=1073746824

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2185_jc2m3z7p_.arc RECID=2169 STAMP=1073772192

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2186_jc2phgn5_.arc RECID=2170 STAMP=1073775631

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2187_jc33q21q_.arc RECID=2171 STAMP=1073789186

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2188_jc3h370q_.arc RECID=2172 STAMP=1073800840

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2189_jc4co2t8_.arc RECID=2173 STAMP=1073830084

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2190_jc57t39b_.arc RECID=2174 STAMP=1073858916

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2191_jc5r36jm_.arc RECID=2175 STAMP=1073875594

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2192_jc5zyow9_.arc RECID=2176 STAMP=1073883640

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2193_jc613s9q_.arc RECID=2177 STAMP=1073884825

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2194_jc61x8mh_.arc RECID=2178 STAMP=1073885641

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2195_jc6l1r24_.arc RECID=2179 STAMP=1073902169

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2196_jc7w9bhr_.arc RECID=2180 STAMP=1073945420

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_31/o1_mf_1_2197_jc86v33k_.arc RECID=2181 STAMP=1073956227

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_31/o1_mf_1_2198_jc8dh756_.arc RECID=2182 STAMP=1073961991

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_31/o1_mf_1_2199_jcbj2jh9_.arc RECID=2183 STAMP=1074031217

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_01/o1_mf_1_2200_jcbvb7xj_.arc RECID=2184 STAMP=1074042729

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_01/o1_mf_1_2201_jcc0tbof_.arc RECID=2185 STAMP=1074048363

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_01/o1_mf_1_2202_jccpr5sy_.arc RECID=2186 STAMP=1074070822

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_01/o1_mf_1_2203_jcf4ghnr_.arc RECID=2187 STAMP=1074117617

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_02/o1_mf_1_2204_jcfhsm9d_.arc RECID=2188 STAMP=1074129236

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_02/o1_mf_1_2205_jcfo77xw_.arc RECID=2189 STAMP=1074134792

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_02/o1_mf_1_2206_jcgtw0xb_.arc RECID=2190 STAMP=1074173346

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_02/o1_mf_1_2207_jchrvnqt_.arc RECID=2191 STAMP=1074204053

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_03/o1_mf_1_2208_jcj52887_.arc RECID=2192 STAMP=1074216553

Crosschecked 23 objects

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_03/o1_mf_1_2209_jcj9mdo5_.arc RECID=2193 STAMP=1074221197

Crosschecked 23 objects

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Report of obsolete backups and copies

Type Key Completion Time Filename/Handle

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

Backup Set 295 23-MAY-2021 05:28:18

Backup Piece 295 23-MAY-2021 05:28:18 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9kvvht0t_308_1_20210523

Backup Set 285 23-MAY-2021 05:21:17

Backup Piece 285 23-MAY-2021 05:21:17 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9lvvht0u_309_1_20210523

Backup Set 286 23-MAY-2021 05:21:26

Backup Piece 286 23-MAY-2021 05:21:26 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9mvvht2l_310_1_20210523

Backup Set 287 23-MAY-2021 05:21:35

Backup Piece 287 23-MAY-2021 05:21:35 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9nvvht2o_311_1_20210523

Backup Set 288 23-MAY-2021 05:21:41

Backup Piece 288 23-MAY-2021 05:21:41 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9ovvht30_312_1_20210523

Backup Set 289 23-MAY-2021 05:22:04

Backup Piece 289 23-MAY-2021 05:22:04 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9pvvht38_313_1_20210523

Backup Set 290 23-MAY-2021 05:22:12

Backup Piece 290 23-MAY-2021 05:22:12 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9qvvht41_314_1_20210523

Backup Set 291 23-MAY-2021 05:22:13

Backup Piece 291 23-MAY-2021 05:22:13 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9rvvht44_315_1_20210523

Backup Set 292 23-MAY-2021 05:22:14

Backup Piece 292 23-MAY-2021 05:22:14 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9svvht46_316_1_20210523

Archive Log 2148 23-MAY-2021 05:28:28 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2164_jbmlys9p_.arc

Backup Set 294 23-MAY-2021 05:22:17

Backup Piece 294 23-MAY-2021 05:22:17 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9uvvht49_318_1_20210523

Control File Copy 24 23-MAY-2021 05:29:28 /u04/db_backup/rman/TEST10/control_TEST10_a1vvhtho_20210523.bak

Backup Set 297 23-MAY-2021 05:29:27

Backup Piece 297 23-MAY-2021 05:29:27 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_a0vvhtg5_320_1_20210523

Archive Log 2149 23-MAY-2021 10:09:45 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2165_jbn3g8jp_.arc

Archive Log 2150 23-MAY-2021 13:27:34 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2166_jbnh15s4_.arc

Archive Log 2151 24-MAY-2021 01:58:37 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2167_jbov1d2z_.arc

Archive Log 2152 24-MAY-2021 02:46:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2168_jboxvhnb_.arc

Archive Log 2153 24-MAY-2021 22:00:27 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2169_jbr1gsfk_.arc

Archive Log 2154 25-MAY-2021 02:00:18 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2170_jbrhjjs5_.arc

Archive Log 2155 25-MAY-2021 02:49:04 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2171_jbrlcyhj_.arc

Archive Log 2156 25-MAY-2021 13:27:57 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2172_jbsqsq59_.arc

Archive Log 2157 25-MAY-2021 22:00:57 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2173_jbtovrr2_.arc

Archive Log 2158 25-MAY-2021 22:01:39 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2174_jbtox2rg_.arc

Archive Log 2159 26-MAY-2021 02:46:16 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2175_jbv6lqtz_.arc

Archive Log 2160 26-MAY-2021 11:00:36 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2176_jbw3kmp3_.arc

Archive Log 2161 26-MAY-2021 22:00:44 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2177_jbxb7c1r_.arc

Archive Log 2162 26-MAY-2021 22:03:20 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2178_jbxbd71c_.arc

Archive Log 2163 27-MAY-2021 02:46:08 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2179_jbxtyhm1_.arc

Archive Log 2164 27-MAY-2021 17:59:30 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2180_jbzjh1k7_.arc

Archive Log 2165 27-MAY-2021 22:01:27 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2181_jbzynpp9_.arc

Archive Log 2166 28-MAY-2021 00:47:06 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2182_jc08c8wh_.arc

Archive Log 2167 28-MAY-2021 02:46:25 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2183_jc0hc052_.arc

Archive Log 2168 28-MAY-2021 15:00:24 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2184_jc1tc751_.arc

Archive Log 2169 28-MAY-2021 22:03:12 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2185_jc2m3z7p_.arc

Archive Log 2170 28-MAY-2021 23:00:31 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2186_jc2phgn5_.arc

Archive Log 2171 29-MAY-2021 02:46:26 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2187_jc33q21q_.arc

Archive Log 2172 29-MAY-2021 06:00:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2188_jc3h370q_.arc

Archive Log 2173 29-MAY-2021 14:08:04 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2189_jc4co2t8_.arc

Archive Log 2174 29-MAY-2021 22:08:36 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2190_jc57t39b_.arc

Archive Log 2175 30-MAY-2021 02:46:34 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2191_jc5r36jm_.arc

Archive Log 2176 30-MAY-2021 05:00:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2192_jc5zyow9_.arc

Archive Log 2177 30-MAY-2021 05:20:25 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2193_jc613s9q_.arc

Backup Set 306 30-MAY-2021 05:22:01

Backup Piece 306 30-MAY-2021 05:22:01 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_ab004bnn_331_1_20210530

Backup Set 309 30-MAY-2021 05:35:58

Backup Piece 309 30-MAY-2021 05:35:58 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_ad004cel_333_1_20210530

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Deleting the following obsolete backups and copies:

Type Key Completion Time Filename/Handle

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

Backup Set 295 23-MAY-2021 05:28:18

Backup Piece 295 23-MAY-2021 05:28:18 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9kvvht0t_308_1_20210523

Backup Set 285 23-MAY-2021 05:21:17

Backup Piece 285 23-MAY-2021 05:21:17 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9lvvht0u_309_1_20210523

Backup Set 286 23-MAY-2021 05:21:26

Backup Piece 286 23-MAY-2021 05:21:26 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9mvvht2l_310_1_20210523

Backup Set 287 23-MAY-2021 05:21:35

Backup Piece 287 23-MAY-2021 05:21:35 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9nvvht2o_311_1_20210523

Backup Set 288 23-MAY-2021 05:21:41

Backup Piece 288 23-MAY-2021 05:21:41 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9ovvht30_312_1_20210523

Backup Set 289 23-MAY-2021 05:22:04

Backup Piece 289 23-MAY-2021 05:22:04 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9pvvht38_313_1_20210523

Backup Set 290 23-MAY-2021 05:22:12

Backup Piece 290 23-MAY-2021 05:22:12 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9qvvht41_314_1_20210523

Backup Set 291 23-MAY-2021 05:22:13

Backup Piece 291 23-MAY-2021 05:22:13 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9rvvht44_315_1_20210523

Backup Set 292 23-MAY-2021 05:22:14

Backup Piece 292 23-MAY-2021 05:22:14 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9svvht46_316_1_20210523

Archive Log 2148 23-MAY-2021 05:28:28 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2164_jbmlys9p_.arc

Backup Set 294 23-MAY-2021 05:22:17

Backup Piece 294 23-MAY-2021 05:22:17 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9uvvht49_318_1_20210523

Control File Copy 24 23-MAY-2021 05:29:28 /u04/db_backup/rman/TEST10/control_TEST10_a1vvhtho_20210523.bak

Backup Set 297 23-MAY-2021 05:29:27

Backup Piece 297 23-MAY-2021 05:29:27 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_a0vvhtg5_320_1_20210523

Archive Log 2149 23-MAY-2021 10:09:45 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2165_jbn3g8jp_.arc

Archive Log 2150 23-MAY-2021 13:27:34 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2166_jbnh15s4_.arc

Archive Log 2151 24-MAY-2021 01:58:37 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2167_jbov1d2z_.arc

Archive Log 2152 24-MAY-2021 02:46:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2168_jboxvhnb_.arc

Archive Log 2153 24-MAY-2021 22:00:27 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2169_jbr1gsfk_.arc

Archive Log 2154 25-MAY-2021 02:00:18 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2170_jbrhjjs5_.arc

Archive Log 2155 25-MAY-2021 02:49:04 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2171_jbrlcyhj_.arc

Archive Log 2156 25-MAY-2021 13:27:57 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2172_jbsqsq59_.arc

Archive Log 2157 25-MAY-2021 22:00:57 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2173_jbtovrr2_.arc

Archive Log 2158 25-MAY-2021 22:01:39 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2174_jbtox2rg_.arc

Archive Log 2159 26-MAY-2021 02:46:16 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2175_jbv6lqtz_.arc

Archive Log 2160 26-MAY-2021 11:00:36 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2176_jbw3kmp3_.arc

Archive Log 2161 26-MAY-2021 22:00:44 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2177_jbxb7c1r_.arc

Archive Log 2162 26-MAY-2021 22:03:20 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2178_jbxbd71c_.arc

Archive Log 2163 27-MAY-2021 02:46:08 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2179_jbxtyhm1_.arc

Archive Log 2164 27-MAY-2021 17:59:30 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2180_jbzjh1k7_.arc

Archive Log 2165 27-MAY-2021 22:01:27 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2181_jbzynpp9_.arc

Archive Log 2166 28-MAY-2021 00:47:06 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2182_jc08c8wh_.arc

Archive Log 2167 28-MAY-2021 02:46:25 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2183_jc0hc052_.arc

Archive Log 2168 28-MAY-2021 15:00:24 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2184_jc1tc751_.arc

Archive Log 2169 28-MAY-2021 22:03:12 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2185_jc2m3z7p_.arc

Archive Log 2170 28-MAY-2021 23:00:31 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2186_jc2phgn5_.arc

Archive Log 2171 29-MAY-2021 02:46:26 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2187_jc33q21q_.arc

Archive Log 2172 29-MAY-2021 06:00:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2188_jc3h370q_.arc

Archive Log 2173 29-MAY-2021 14:08:04 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2189_jc4co2t8_.arc

Archive Log 2174 29-MAY-2021 22:08:36 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2190_jc57t39b_.arc

Archive Log 2175 30-MAY-2021 02:46:34 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2191_jc5r36jm_.arc

Archive Log 2176 30-MAY-2021 05:00:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2192_jc5zyow9_.arc

Archive Log 2177 30-MAY-2021 05:20:25 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2193_jc613s9q_.arc

Backup Set 306 30-MAY-2021 05:22:01

Backup Piece 306 30-MAY-2021 05:22:01 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_ab004bnn_331_1_20210530

Backup Set 309 30-MAY-2021 05:35:58

Backup Piece 309 30-MAY-2021 05:35:58 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_ad004cel_333_1_20210530

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9kvvht0t_308_1_20210523 RECID=295 STAMP=1073280030

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9lvvht0u_309_1_20210523 RECID=285 STAMP=1073280030

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9mvvht2l_310_1_20210523 RECID=286 STAMP=1073280086

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9nvvht2o_311_1_20210523 RECID=287 STAMP=1073280089

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9ovvht30_312_1_20210523 RECID=288 STAMP=1073280097

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9pvvht38_313_1_20210523 RECID=289 STAMP=1073280104

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9rvvht44_315_1_20210523 RECID=291 STAMP=1073280133

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9qvvht41_314_1_20210523 RECID=290 STAMP=1073280129

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2164_jbmlys9p_.arc RECID=2148 STAMP=1073280508

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9svvht46_316_1_20210523 RECID=292 STAMP=1073280134

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9uvvht49_318_1_20210523 RECID=294 STAMP=1073280137

deleted control file copy

control file copy file name=/u04/db_backup/rman/TEST10/control_TEST10_a1vvhtho_20210523.bak RECID=24 STAMP=1073280568

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_a0vvhtg5_320_1_20210523 RECID=297 STAMP=1073280522

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2165_jbn3g8jp_.arc RECID=2149 STAMP=1073297385

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2166_jbnh15s4_.arc RECID=2150 STAMP=1073309254

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2167_jbov1d2z_.arc RECID=2151 STAMP=1073354317

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2168_jboxvhnb_.arc RECID=2152 STAMP=1073357200

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2169_jbr1gsfk_.arc RECID=2153 STAMP=1073426427

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2170_jbrhjjs5_.arc RECID=2154 STAMP=1073440818

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2171_jbrlcyhj_.arc RECID=2155 STAMP=1073443744

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2172_jbsqsq59_.arc RECID=2156 STAMP=1073482077

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2173_jbtovrr2_.arc RECID=2157 STAMP=1073512857

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2174_jbtox2rg_.arc RECID=2158 STAMP=1073512899

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2175_jbv6lqtz_.arc RECID=2159 STAMP=1073529976

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2176_jbw3kmp3_.arc RECID=2160 STAMP=1073559636

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2177_jbxb7c1r_.arc RECID=2161 STAMP=1073599244

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2178_jbxbd71c_.arc RECID=2162 STAMP=1073599400

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2179_jbxtyhm1_.arc RECID=2163 STAMP=1073616368

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2180_jbzjh1k7_.arc RECID=2164 STAMP=1073671170

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2181_jbzynpp9_.arc RECID=2165 STAMP=1073685687

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2182_jc08c8wh_.arc RECID=2166 STAMP=1073695626

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2183_jc0hc052_.arc RECID=2167 STAMP=1073702785

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2184_jc1tc751_.arc RECID=2168 STAMP=1073746824

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2185_jc2m3z7p_.arc RECID=2169 STAMP=1073772192

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2186_jc2phgn5_.arc RECID=2170 STAMP=1073775631

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2187_jc33q21q_.arc RECID=2171 STAMP=1073789186

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2188_jc3h370q_.arc RECID=2172 STAMP=1073800840

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2189_jc4co2t8_.arc RECID=2173 STAMP=1073830084

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2190_jc57t39b_.arc RECID=2174 STAMP=1073858916

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2191_jc5r36jm_.arc RECID=2175 STAMP=1073875594

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2192_jc5zyow9_.arc RECID=2176 STAMP=1073883640

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2193_jc613s9q_.arc RECID=2177 STAMP=1073884825

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ab004bnn_331_1_20210530 RECID=306 STAMP=1073884920

Deleted 22 objects

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ad004cel_333_1_20210530 RECID=309 STAMP=1073885668

Deleted 22 objects

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

Starting backup at 03-JUN-2021 14:47:52

channel c1: starting compressed incremental level 0 datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00004 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/idata01.dbf

channel c1: starting piece 1 at 03-JUN-2021 14:47:52

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00002 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/sysaux01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:47:52

channel c2: finished piece 1 at 03-JUN-2021 14:48:27

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ah00fuco_337_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:35

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00008 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/tcmanagerdb01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:27

channel c2: finished piece 1 at 03-JUN-2021 14:48:28

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ai00fudr_338_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00003 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/undotbs01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:28

channel c2: finished piece 1 at 03-JUN-2021 14:48:31

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_aj00fuds_339_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:03

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00009 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafiletcprodmanager01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:31

channel c2: finished piece 1 at 03-JUN-2021 14:48:32

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ak00fudv_340_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00001 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/system01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:33

channel c2: finished piece 1 at 03-JUN-2021 14:48:48

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_al00fue1_341_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:15

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/ilog01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:48

channel c2: finished piece 1 at 03-JUN-2021 14:48:51

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_am00fueg_342_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:03

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00006 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/indx01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:51

channel c2: finished piece 1 at 03-JUN-2021 14:48:52

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_an00fuej_343_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00007 name=/u01/app/oracle/product/12.1.0/dbhome_1/tcservermanagerdb.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:52

channel c2: finished piece 1 at 03-JUN-2021 14:48:53

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ao00fuek_344_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

including current control file in backup set

channel c2: starting piece 1 at 03-JUN-2021 14:48:54

channel c2: finished piece 1 at 03-JUN-2021 14:48:58

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ap00fuel_345_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:04

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

including current SPFILE in backup set

channel c2: starting piece 1 at 03-JUN-2021 14:48:58

channel c2: finished piece 1 at 03-JUN-2021 14:48:59

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_aq00fueq_346_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c1: finished piece 1 at 03-JUN-2021 14:52:23

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ag00fuco_336_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c1: backup set complete, elapsed time: 00:04:31

Finished backup at 03-JUN-2021 14:52:23

Starting backup at 03-JUN-2021 14:52:24

current log archived

channel c1: starting compressed archived log backup set

channel c1: specifying archived log(s) in backup set

input archived log thread=1 sequence=2194 RECID=2178 STAMP=1073885641

input archived log thread=1 sequence=2195 RECID=2179 STAMP=1073902169

input archived log thread=1 sequence=2196 RECID=2180 STAMP=1073945420

input archived log thread=1 sequence=2197 RECID=2181 STAMP=1073956227

input archived log thread=1 sequence=2198 RECID=2182 STAMP=1073961991

input archived log thread=1 sequence=2199 RECID=2183 STAMP=1074031217

input archived log thread=1 sequence=2200 RECID=2184 STAMP=1074042729

input archived log thread=1 sequence=2201 RECID=2185 STAMP=1074048363

input archived log thread=1 sequence=2202 RECID=2186 STAMP=1074070822

channel c1: starting piece 1 at 03-JUN-2021 14:52:24

channel c2: starting compressed archived log backup set

channel c2: specifying archived log(s) in backup set

input archived log thread=1 sequence=2203 RECID=2187 STAMP=1074117617

input archived log thread=1 sequence=2204 RECID=2188 STAMP=1074129236

input archived log thread=1 sequence=2205 RECID=2189 STAMP=1074134792

input archived log thread=1 sequence=2206 RECID=2190 STAMP=1074173346

input archived log thread=1 sequence=2207 RECID=2191 STAMP=1074204053

input archived log thread=1 sequence=2208 RECID=2192 STAMP=1074216553

input archived log thread=1 sequence=2209 RECID=2193 STAMP=1074221197

input archived log thread=1 sequence=2210 RECID=2194 STAMP=1074264472

input archived log thread=1 sequence=2211 RECID=2195 STAMP=1074264744

channel c2: starting piece 1 at 03-JUN-2021 14:52:24

channel c1: finished piece 1 at 03-JUN-2021 14:52:49

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ar00ful8_347_1_20210603 tag=TAG20210603T145224 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:25

channel c2: finished piece 1 at 03-JUN-2021 14:52:49

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_as00ful8_348_1_20210603 tag=TAG20210603T145224 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:25

Finished backup at 03-JUN-2021 14:52:49

Starting backup at 03-JUN-2021 14:52:49

channel c1: starting datafile copy

copying current control file

output file name=/u04/db_backup/rman/TEST10/control_TEST10_at00fum2_20210603.bak tag=TAG20210603T145249 RECID=26 STAMP=1074264770

channel c1: datafile copy complete, elapsed time: 00:00:01

Finished backup at 03-JUN-2021 14:52:51

released channel: c1

released channel: c2

Recovery Manager complete.

ORA-00449: background process 'RBAL' unexpectedly terminated with error 448

Scenario:

Recently in our 2 Node RAC environment which was working fine. Linux team accidently change the ownership of grid and oracle directory in one of the node. Existing connections are able to connect but new connection not getting connected.

We stop the issue node using crsctl stop crs command after restarting. All crs services working fine getting error when starting instance on issue node.

After changing permission back still getting error. We done troubleshooting and reboot issue server several times but didn't get succeeded comparing directories we provided permission manually and started database instance.

Operating System : Suse 12 SP5

Version : 12.1.0.2.0 Enterprise edition

Changed original name and services

Node name: Srv1.Srv2

Instance name : Prod1, Prod2

Error :

Alert log error:

ORA-00449: background process 'RBAL' unexpectedly terminated with error 448

ORA-27121: unable to determine size of shared memory segment

Linux-x86_64 Error: 13: Permission denied

Srvctl command error:

PRCR-1013 : Failed to start resource ora.prod.db

PRCR-1064 : Failed to start resource ora.prod.db on node srv1

Troubleshooting scenario and solution:

grid@srv1:~> srvctl start instance -i PROD2 -d prod

Invalid instance name(s): PROD2

grid@srv1:~> srvctl status database -d prod

Instance PROD1 is running on node srv2

Instance PROD2 is not running on node srv1

grid@srv1:~> srvctl start instance -i PROD2 -d prod

PRCR-1013 : Failed to start resource ora.prod.db

PRCR-1064 : Failed to start resource ora.prod.db on node srv1

CRS-5017: The resource action "ora.prod.db start" encountered the following error:

ORA-00449: background process 'RBAL' unexpectedly terminated with error 448

. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/srv1/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.prod.db' on 'srv1' failed

CRS-2674: Start of 'ora.prod.db' on 'srv1' failed

oracle@srv1:/home/grid> cd

oracle@srv1:~> . oraenv

ORACLE_SID = [+ASM2] ? PROD2

The Oracle base remains unchanged with value /u01/app/oracle

oracle@srv1:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu May 27 16:29:22 2021

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

Connected to an idle instance.

SQL> startup

ORA-00449: background process 'RBAL' unexpectedly terminated with error 448

Check cluster services

grid@srv1:~> crsctl check cluster -all

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

srv1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

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

srv2:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

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

srv1:/u01/app/12.1.0/grid/crs/install # 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.FRA1.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.NEWFRA2.dg

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 srv2 STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE srv2 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE srv2 169.254.77.49 192.16

8.0.64,STABLE

ora.cvu

1 ONLINE ONLINE srv2 STABLE

ora.mgmtdb

1 ONLINE ONLINE srv2 Open,STABLE

ora.oc4j

1 ONLINE ONLINE srv2 STABLE

ora.scan1.vip

1 ONLINE ONLINE srv1 STABLE

ora.scan2.vip

1 ONLINE ONLINE srv2 STABLE

ora.scan3.vip

1 ONLINE ONLINE srv2 STABLE

ora.srv1.vip

1 ONLINE ONLINE srv1 STABLE

ora.srv2.vip

1 ONLINE ONLINE srv2 STABLE

ora.prod.db

1 ONLINE ONLINE srv2 Open,STABLE

2 ONLINE OFFLINE Instance Shutdown,ST

ABLE

ora.prod.prodb.svc

1 ONLINE ONLINE srv2 STABLE

ora.prod.prodb_preconnect.svc

1 ONLINE OFFLINE STABLE

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

SRDC - How to Collect Standard Information for Clusterware Startup Issues ( Doc ID 2766730.1 )

Download the attached script tar startUpCheck_Linux.tar.gz (This script will work only on Linux platform)

$ cd /tmp/

$ tar -zxvf startUpCheck_Linux.tar.gz

$ chmod +x startUpCheck_Linux.{sh,py}

You would find 2 files startUpCheck_Linux.sh and startUpCheck_Linux.py. Execute the script as "root" user as follows

# ./startUpCheck_Linux.sh -n <node list> -i <private/asm interface list>

Getting cluster_interconnect information name

srv1:~ # /u01/app/12.1.0/grid/bin/gpnptool get 2>/dev/null | xmllint --format - | egrep 'cluster_interconnect' | awk '{print $4}'| awk -F '"' '{print $2}'

p8p2

Checking startup check sequences it looks fine.
Suse 12SP5 having issue on oracle RAC suse 15 it work well

srv1:/tmp # ./startUpCheck_Linux.sh -n srv1 -i p8p2

Logfile location : /tmp/srv1_2021-5-27_14-38-26.log

Verifying if script is executed by root user ...PASSED

Verifying runlevel ...PASSED

Verifying HA stack status ...Traceback (most recent call last):

File "startUpCheck_Linux.py", line 2759, in <module>

HA_STACK_UP = validateHAStack()

File "startUpCheck_Linux.py", line 1062, in validateHAStack

BOOTSTRAP_LOC = BOOTSTRAP_DICT[OS_VERSION]

KeyError: '12-SP5'

srv1:/tmp # ./startUpCheck_Linux.sh -n srv1,srv2 -i p8p2

Logfile location : /tmp/srv1_2021-5-27_14-39-58.log

Verifying if script is executed by root user ...PASSED

Verifying runlevel ...PASSED

Verifying HA stack status ...Traceback (most recent call last):

File "startUpCheck_Linux.py", line 2759, in <module>

HA_STACK_UP = validateHAStack()

File "startUpCheck_Linux.py", line 1062, in validateHAStack

BOOTSTRAP_LOC = BOOTSTRAP_DICT[OS_VERSION]

KeyError: '12-SP5'

srv1:/tmp #

We run rootcrs.sh initially at our end but getting same error . Run rootcrs.sh -prepatch and rootcrs.sh -postpatch but instance didn't start.

Location : $GI_HOME/crs/install/

rootcrs.sh -prepatch

rootcrs.sh -postpatch

srv1:/u01/app/12.1.0/grid/crs/install # ./rootcrs.sh -prepatch

Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params

Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [2919480821].

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'srv1'

CRS-2673: Attempting to stop 'ora.crsd' on 'srv1'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'srv1'

CRS-2673: Attempting to stop 'ora.CRS.dg' on 'srv1'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'srv1'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'srv1'

CRS-2673: Attempting to stop 'ora.NEWFRA2.dg' on 'srv1'

CRS-2673: Attempting to stop 'ora.FRA1.dg' on 'srv1'

CRS-2677: Stop of 'ora.CRS.dg' on 'srv1' succeeded

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'srv1'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.srv1.vip' on 'srv1'

CRS-2677: Stop of 'ora.FRA1.dg' on 'srv1' succeeded

CRS-2677: Stop of 'ora.NEWFRA2.dg' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'srv1'

CRS-2677: Stop of 'ora.DATA.dg' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'srv1'

CRS-2677: Stop of 'ora.asm' on 'srv1' succeeded

CRS-2677: Stop of 'ora.scan1.vip' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.scan1.vip' on 'srv2'

CRS-2677: Stop of 'ora.srv1.vip' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.srv1.vip' on 'srv2'

CRS-2676: Start of 'ora.scan1.vip' on 'srv2' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'srv2'

CRS-2676: Start of 'ora.srv1.vip' on 'srv2' succeeded

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'srv2' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'srv1'

CRS-2677: Stop of 'ora.ons' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'srv1'

CRS-2677: Stop of 'ora.net1.network' on 'srv1' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'srv1' has completed

CRS-2677: Stop of 'ora.crsd' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.storage' on 'srv1'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'srv1'

CRS-2673: Attempting to stop 'ora.gpnpd' on 'srv1'

CRS-2677: Stop of 'ora.storage' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.crf' on 'srv1'

CRS-2673: Attempting to stop 'ora.ctssd' on 'srv1'

CRS-2673: Attempting to stop 'ora.evmd' on 'srv1'

CRS-2673: Attempting to stop 'ora.asm' on 'srv1'

CRS-2677: Stop of 'ora.mdnsd' on 'srv1' succeeded

CRS-2677: Stop of 'ora.gpnpd' on 'srv1' succeeded

CRS-2677: Stop of 'ora.crf' on 'srv1' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'srv1' succeeded

CRS-2677: Stop of 'ora.evmd' on 'srv1' succeeded

CRS-2677: Stop of 'ora.asm' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'srv1'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'srv1'

CRS-2677: Stop of 'ora.cssd' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'srv1'

CRS-2677: Stop of 'ora.gipcd' on 'srv1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'srv1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

2021/05/28 13:15:13 CLSRSC-347: Successfully unlock /u01/app/12.1.0/grid

srv1:/u01/app/12.1.0/grid/crs/install # ./rootcrs.sh -postpatch

Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params

2021/05/28 13:25:06 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.

2021/05/28 13:25:33 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.

CRS-4123: Oracle High Availability Services has been started.

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Starting Oracle High Availability Services-managed resources

CRS-2672: Attempting to start 'ora.mdnsd' on 'srv1'

CRS-2672: Attempting to start 'ora.evmd' on 'srv1'

CRS-2676: Start of 'ora.mdnsd' on 'srv1' succeeded

CRS-2676: Start of 'ora.evmd' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'srv1'

CRS-2676: Start of 'ora.gpnpd' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.gipcd' on 'srv1'

CRS-2676: Start of 'ora.gipcd' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'srv1'

CRS-2676: Start of 'ora.cssdmonitor' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'srv1'

CRS-2672: Attempting to start 'ora.diskmon' on 'srv1'

CRS-2676: Start of 'ora.diskmon' on 'srv1' succeeded

CRS-2676: Start of 'ora.cssd' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'srv1'

CRS-2672: Attempting to start 'ora.ctssd' on 'srv1'

CRS-2676: Start of 'ora.ctssd' on 'srv1' succeeded

CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'srv1'

CRS-2676: Start of 'ora.asm' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.storage' on 'srv1'

CRS-2676: Start of 'ora.storage' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.crf' on 'srv1'

CRS-2676: Start of 'ora.crf' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'srv1'

CRS-2676: Start of 'ora.crsd' on 'srv1' succeeded

CRS-6017: Processing resource auto-start for servers: srv1

CRS-2672: Attempting to start 'ora.net1.network' on 'srv1'

CRS-2676: Start of 'ora.net1.network' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.ons' on 'srv1'

CRS-2673: Attempting to stop 'ora.srv1.vip' on 'srv2'

CRS-2677: Stop of 'ora.srv1.vip' on 'srv2' succeeded

CRS-2672: Attempting to start 'ora.srv1.vip' on 'srv1'

CRS-2676: Start of 'ora.ons' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'srv2'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'srv2' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'srv2'

CRS-2677: Stop of 'ora.scan1.vip' on 'srv2' succeeded

CRS-2672: Attempting to start 'ora.scan1.vip' on 'srv1'

CRS-2676: Start of 'ora.srv1.vip' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'srv1'

CRS-2676: Start of 'ora.scan1.vip' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'srv1'

CRS-2676: Start of 'ora.LISTENER.lsnr' on 'srv1' succeeded

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.prod.db' on 'srv1'

CRS-5017: The resource action "ora.prod.db start" encountered the following error:

ORA-00449: background process 'RBAL' unexpectedly terminated with error 448

. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/srv1/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.prod.db' on 'srv1' failed

CRS-2679: Attempting to clean 'ora.prod.db' on 'srv1'

CRS-2681: Clean of 'ora.prod.db' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.prod.db' on 'srv1'

CRS-5017: The resource action "ora.prod.db start" encountered the following error:

ORA-00449: background process 'RBAL' unexpectedly terminated with error 448

. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/srv1/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.prod.db' on 'srv1' failed

CRS-2679: Attempting to clean 'ora.prod.db' on 'srv1'

CRS-2681: Clean of 'ora.prod.db' on 'srv1' succeeded

===== Summary of resource auto-start failures follows =====

CRS-2807: Resource 'ora.prod.db' failed to start automatically.

CRS-2807: Resource 'ora.prod.prodb_preconnect.svc' failed to start automatically.

CRS-6016: Resource auto-start has completed for server srv1

CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources

CRS-4123: Oracle High Availability Services has been started.

Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [2919480821].

PRCC-1010 : _mgmtdb was already enabled

PRCR-1002 : Resource ora.mgmtdb is already enabled

srv1:/u01/app/12.1.0/grid/crs/install #

Checking component software. Before running it was working fine.

grid@srv1:~> cluvfy comp software -n all

Component: crs

Node Name: srv1

/u01/app/12.1.0/grid/lib/acfslib.pm..."Permissions" did not match reference

/u01/app/12.1.0/grid/lib/okalib.pm..."Permissions" did not match reference

/u01/app/12.1.0/grid/lib/afdlib.pm..."Permissions" did not match reference

/u01/app/12.1.0/grid/bin/oerr.pl..."Permissions" did not match reference

3165 files verified

Software check failed

Verification of software was unsuccessful on all the specified nodes.

grid@srv2:~>

alert log error in PROD2 instance :

Fri May 28 16:14:05 2021

NOTE: failed to open +DATA/prod/PARAMETERFILE/spfile.289.1051537879

ORA-01034: ORACLE not available

ORA-27121: unable to determine size of shared memory segment

Linux-x86_64 Error: 13: Permission denied

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

Tried doc but didn't succeed. To check and fix file permissions on Grid Infrastructure environment ( Doc ID 1931142.1 )

grid@srv1:~>

srv1:/u01/app/12.1.0/grid/crs/install # ./rootcrs.sh

Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params

2021/05/31 08:20:35 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.

2021/05/31 08:22:21 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2021/05/31 08:22:21 CLSRSC-456: The Oracle Grid Infrastructure has already been configured.

srv1:/u01/app/12.1.0/grid/crs/install #

srv1:/u01/app/12.1.0/grid/crs/install # ./rootcrs.sh -init

Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params

grid@srv1:~> crsctl check cluster -all

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

srv1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

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

srv1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

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

grid@srv1:~> date

Mon May 31 08:49:08 CEST 2021

grid@srv1:~>

Finally after verifying manually and changing permission chmod 6751 on issue mode instance got started.

ls -las $ORACLE_HOME(RDBMS)/bin/oracle

ls -las $ORACLE_GRID(RDBMS)/bin/oracle

chmod 6751 /u01/app/12.1.0/grid/bin/oracle

srv1

grid@srv1:~> ls -las /u01/app/oracle/product/12.1.0/dbhome_2/bin/oracle

316688 -rwsr-s--x 1 oracle asmadmin 324287048 Sep 28 2019 /u01/app/oracle/product/12.1.0/dbhome_2/bin/oracle

grid@srv2:~> ls -las /u01/app/12.1.0/grid/bin/oracle

285260 -rwxr-x--x 1 grid oinstall 292103400 Sep 22 2019 /u01/app/12.1.0/grid/bin/oracle

srv2

grid@srv2:~> ls -las /u01/app/oracle/product/12.1.0/dbhome_2/bin/oracle

316688 -rwsr-s--x 1 oracle asmadmin 324287048 Sep 28 2019 /u01/app/oracle/product/12.1.0/dbhome_2/bin/oracle

grid@srv2:~> ls -las /u01/app/12.1.0/grid/bin/oracle

285260 -rwsr-s--x 1 grid oinstall 292103400 Sep 22 2019 /u01/app/12.1.0/grid/bin/oracle

chmod 6751 /u01/app/12.1.0/grid/bin/oracle

chmod 6751 /u01/app/oracle/product/12.1.0/dbhome_2/bin/oracle

We stopped the crs and started again on issue node, Instance got started.

grid@srv2:~> 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.FRA1.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.NEWFRA2.dg

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 srv2 STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE srv2 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE srv2 169.254.77.49 192.16

8.0.64,STABLE

ora.cvu

1 ONLINE ONLINE srv2 STABLE

ora.mgmtdb

1 ONLINE ONLINE srv2 Open,STABLE

ora.oc4j

1 ONLINE ONLINE srv2 STABLE

ora.scan1.vip

1 ONLINE ONLINE srv1 STABLE

ora.scan2.vip

1 ONLINE ONLINE srv2 STABLE

ora.scan3.vip

1 ONLINE ONLINE srv2 STABLE

ora.srv1.vip

1 ONLINE ONLINE srv1 STABLE

ora.srv2.vip

1 ONLINE ONLINE srv2 STABLE

ora.prod.db

1 ONLINE ONLINE srv2 Open,STABLE

2 ONLINE ONLINE srv1 Open,STABLE

ora.prod.prodb.svc

1 ONLINE ONLINE srv2 STABLE

ora.prod.prodb_preconnect.svc

1 ONLINE ONLINE srv1 STABLE

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

grid@srv2:~>

Subscribe to: Posts (Atom)