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 […]
RMAN

How to Restore Archivelog to Different Location

Posted on
Here is my case, I would like to resolve the gap between the primary and the standby database, but the log_archive_dest_1 is very limited, I can’t restore all of required archived log to the destination. So I decided to restore them to another location. RMAN> run {   allocate channel c1 type ‘sbt_tape’;   set […]
RMAN

How to Backup Oracle Database Parallelly by RMAN

Posted on
If you do not explicitly allocate the channel(s) in the run block, RMAN will follow the default channel and parallelism setting for parallel backup. For example:RMAN> show all;…CONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 5; # default…RMAN> run {  backup database;}2> 3>Starting backup at 08-JUN-16allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=12 devtype=DISKallocated […]
Database

How Do I Know DBID of a Database

Posted on
Different database has their own DBID that can make recovery catalog distinguish which is which, but in the same data guard infrastructure, the database, either primary or standby shares one DBID.It’s especially convenient for restoring primary or standby database through catalog with the same DBID, no matter what the backup sets were coming from which […]
RMAN

How to Resolve ORA-01153 an incompatible media recovery is active

Posted on
ORA-01153 Got an error ORA-01153 like this: SQL> recover standby database until cancel; ORA-01153: an incompatible media recovery is active Let’s see the content of ORA-01153 Description ORA-01153: an incompatible media recovery is active Cause Attempted to start an incompatible media recovery or open resetlogs during media recovery or RMAN backup . Media recovery sessions […]