ASM

How to Resolve SPFILE in DB_UNKNOWN

Posted on
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN in ASM. It seems to be a bug in Oracle 10g RMAN (Is it Bug 5370663?). Let’s reproduce the problem. First, check what we have in the diskgroup ORA_DATA by […]
RMAN

How to Resolve ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

Posted on
Found ORA-19602 When I tried to backup a NOARCHIVELOG database in MOUNT state, I got ORA-19602 like the following case: RMAN> startup mount; … RMAN> backup database tag ‘20190416-before-yearly-import’; Starting backup at 16-APR-19 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=393 device type=DISK channel ORA_DISK_1: starting full datafile […]
RMAN

How RMAN Restore Database by a Backup Set

Posted on
Suppose we have restored the whole OS to the new server including Oracle software and directory structure. Our goal is to restore the database to the target server solely by a backup set for testing purpose. The content of the backup set that we copied from the source server to the target server is listed […]
RMAN

How to Resolve RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode

Posted on
RMAN-06149 Trying to backup a database in the development environment. But failed with “RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode”. RMAN> backup database tag ‘BEFORE-IMPORT-PRODUCTION-2018Q1’; Starting backup at 18-APR-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=352 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== […]
Archived Log File

Online Archived Logs vs Backup Archived Logs

Posted on
Let me make it short first. If you can tell the difference between the following two RMAN statements, then you have already know the difference. RMAN> list archivelog all; RMAN> list backup of archivelog all; Of course, I can also explain the difference much longer. Online Archived Logs Online archived logs are derived from online […]
RMAN

How to Compress RMAN Backupset

Posted on
You can enable the compression feature of RMAN by the following 2 ways: One time setting RMAN> show all; RMAN configuration parameters for database with db_unique_name ORCL are: … CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default … CONFIGURE COMPRESSION ALGORITHM ‘BASIC’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE ; […]
RMAN

How to Resolve ORA-19505 and ORA-27037 in Error Stack

Posted on
ORA-19505 with ORA-27037 When I tried to duplicate a target database to an auxiliary one by this run block. RUN {   ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;   ALLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE DISK;   ALLOCATE AUXILIARY CHANNEL c3 DEVICE TYPE DISK;   ALLOCATE AUXILIARY CHANNEL c4 DEVICE TYPE DISK;   DUPLICATE […]
RMAN

How to Check Oracle Data Files Healthy

Posted on
Two ways that you can verify data files, one is using Oracle utility dbverify, the other is RMAN command.DbverifyWe can use dbv to check specific data file for block healthy.[oracle@localhost ~] dbv feedback=0 blocksize=8192 file=/oracle/oradata/ORCL/USER01.dbf…Page 2760912 is marked corrupt***Corrupt block relative dba: 0x4baa20d0 (file 302, block 2760912)Completely zero block found during dbv:One dbv command can […]