Friday, February 26, 2016

RMAN-00600: internal error, arguments [8201] [] [] [] [] while doing the database restore

This error occurs if for some reason that resync catalog did not happen. 

So solution is do it. See below:

RMAN> run {
2> allocate  channel ch1 type 'sbt_tape'
3> PARMS="SBT_LIBRARY=/local/Base64/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
4> TRACE 0;
5> restore database;
6> }
allocated channel: ch1
channel ch1: SID=460 device type=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 10.0.0(BUILD116)
Starting restore at 10-FEB-16
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/10/2016 10:04:52
RMAN-00600: internal error, arguments [8201] [] [] [] []
RMAN> 


The solution is log on to the database server and then resync using


$: rman target / catalog rman/password@rcat
Recovery Manager: Release 11.1.0.7.0 - Production on Fri Feb 10 10:16:32 2016
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: TESTDB1 (DBID=5432652134)
connected to recovery catalog database
RMAN> show all;
database reset to incarnation 245687
starting full resync of recovery catalog
full resync complete
RMAN configuration parameters for database with db_unique_name TESTDB1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/dbfiles/TESTDB1/backups/control01.ctl';
RMAN> 

Wednesday, February 3, 2016

Convert oracle asm disk from member to candiate

In order to convert the member asm disk to candiate we need to first clear the contents of the disk and then remove and add again.

In this example we are converting CRS1 and CRS2 from member to candidate.


steps are:

[root@rac1 ~]# dd if=/dev/zero of=/dev/sdl1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.0349507 s, 2.9 MB/s
[root@rac1 ~]#
[root@rac1 ~]# oracleasm deletedisk CRS1
Disk "CRS1" defines an unmarked device
Dropping disk: done
[root@rac1 ~]#
[root@rac1 ~]# oracleasm createdisk CRS1 /dev/sdl1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]#

[root@rac1 ~]# dd if=/dev/zero of=/dev/sdm1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.0166484 s, 6.2 MB/s
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# oracleasm deletedisk CRS2
Disk "CRS2" defines an unmarked device
Dropping disk: done
[root@rac1 ~]#
[root@rac1 ~]# oracleasm createdisk CRS2 /dev/sdm1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]#
[root@rac1 ~]# oracleasm listdisks
ASM1
ASM2
ASM3
ASM4
ASM5
ASM6
ASM7
ASM8
CRS1
CRS2
[root@rac1 ~]#

After this we can see that CRS1 and CRS2 are now candidate disks


If you are wondering that how did not know what disk is linked with CRS1 and CRS2 then see my post "determine the path behind the oracle asm disk"