• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

RMAN

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

by admin

The Problem Received below error while restoring COLD backup of source database using RMAN at target server. RMAN> run{ 2> restore database; 3> } Starting restore at 07-SEP-16 RMAN-06908: WARNING: operation will not run in parallel on the allocated channels RMAN-06909: WARNING: parallelism require Enterprise Edition allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=391 device type=DISK released […]

Filed Under: oracle, RMAN

How does the RMAN Retention Policy Obsolete Incremental Backupsets

by admin

The report/delete obsolete commands works in two steps. First, we identify the oldest full backup (i.e. full or level 0 backupset, or image copy) of every file that is not obsolete, as defined by the retention policy (either REDUNDANCY or RECOVERY WINDOW). Every older full backup is obsolete. Then, all archived logs and level > […]

Filed Under: oracle, RMAN

How do we Set A Retention Policy For Tape Backups And Disk Backups Differently

by admin

Question: How do we Set A Retention Policy For Tape Backups And Disk Backups Differently? For example, setting the tape retention policy to 14 days while setting it to 3 days for the disk backups. Step 1: Set the retention policy. RMAN currently only allows one retention policy. The retention policy should be set to […]

Filed Under: oracle, RMAN

RMAN backup Concepts for Oracle RAC

by admin

Oracle Recovery Manager Oracle Database provides RMAN for backing up and restoring the database. RMAN enables you to back up, restore, and recover data files, control files, SPFILEs, and archived redo logs. You can run RMAN from the command line or you can use it from the Backup Manager in Enterprise Manager. In addition, RMAN […]

Filed Under: oracle, oracle 12c, RAC, RMAN

Oracle Database: How to catalog tape backup pieces

by admin

Starting with 10g, it’s possible to use the RMAN CATALOG command to add backuppieces stored in the disk to the RMAN repository. You may need to catalog backup pieces in the following situations: You copy or move a backup piece with an operating system utility and want it to be usable by RMAN. The RMAN […]

Filed Under: oracle, RMAN

How to upgrade RMAN catalog SCHEMA from 11g to 12.1.0.2 without upgrading the catalog database

by admin

Question: Our rman catalog database is 11.2.0.3 right now, do I need to upgrade the database to 12.1.0.2 first, and then upgrade the catalog to 12.1.0.2? The version of the RMAN catalog database does not need to match that of the recovery catalog. Therefore you can upgrade the RMAN catalog without upgrading the RMAN database. […]

Filed Under: oracle, Oracle 11g, oracle 12c, RMAN

Oracle RMAN Pluggable Database Point in Time Recovery

by admin

Point in time recovery of a Pluggable Database (from hereon referred to as a PDB) requires ALL files including UNDO to be restored and recovered to the specified time. As all PDBs write to the ROOT UNDO tablespace, point in time recovery of a PDB will use an auxiliary instance and will restore the CDB$ROOT […]

Filed Under: oracle, oracle 12c, RMAN

Oracle RMAN 12c – New Features

by admin

This post provides information on enhancements available in RMAN within Oracle 12c. Support for Container and Pluggable Databases RMAN in 12c provides full backup and recovery support for a Pluggable Database environment. You can perform the backup of the entire container database (CDB), either full or using an incremental backup strategy, or one/many pluggable databases […]

Filed Under: oracle, oracle 12c, RMAN

RMAN Restore/Duplicate Performs Implicit Crosschecking and Cataloging

by admin

The Problem After restoring a controlfile, the restore database can take a long time to restore due to implicit croscchecking and cataloging. RMAN> restore database; RMAN-03090: Starting implicit crosscheck backup at 2012/10/05 01:56:55 RMAN-08030: allocated channel: ORA_DISK_1 RMAN-08500: channel ORA_DISK_1: SID=63 device type=DISK RMAN-06206: Crosschecked XXXX objects ——> Time taken Time taken Time taken list […]

Filed Under: oracle, RMAN

Oracle RMAN interview questions

by admin

General RMAN Questions What is RMAN and How to configure it? RMAN is an Oracle Database client that performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies the dba jobs by managing the production database’s backing up, restoring, and recovering database files. This tool integrates […]

Filed Under: Interview Questions, oracle, RMAN

Next Page »

Primary Sidebar

Recent Posts

  • “aws s3 ls” Command Examples
  • “aws s3 cp” Command Examples
  • “aws route53” Command Examples
  • “aws rds” Command Examples

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright