• 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

Oracle RMAN – Restore and Recovery of a Noarchivelog Database

by admin

Restore and Recovery of a NOARCHIVELOG database using RMAN

When performing a consistent backup (also known as cold or offline backup) with Recovery Manager, it will backup the datafiles and generate a backup controlfile, the online redo logs are never backed up by RMAN.

Hence, after a full database restore, the database has to be opened with RESETLOGS, because online redo logs are not available. The OPEN RESETLOGS command will create the online redo logs based on information from the database’s controlfile.

This would be the scenario :

1. both controlfile and datafiles are checkpointed at the same SCN, and
2. this controlfile is a backup controlfile

These conditions are true for a consistent, full backup of a NOARCHIVELOG database using RMAN. So, a more practical and convenient way to restore and recover a consistent, full backup of a NOARCHIVELOG database is to OPEN RESETLOGS the database just after the restore of the datafiles and the backup controlfile:

In RMAN:

run {
      allocate channel c1 type disk;
      restore controlfile to '[pathname]';
      replicate controlfile from '[pathname]';
      sql "alter database mount";
      restore database;
      sql 'alter database open resetlogs';
      release channel c1;
    }
RMAN> reset database;

This mechanism also works well without RMAN. If you have a consistent backup of datafiles having used OS utilities (like cp, tar, dd, etc.), as well as a backup controlfile having executed an ALTER DATABASE BACKUP CONTROLFILE TO ‘file’ command, you can proceed as followed:

– Restore datafiles and backup controlfile

– In SQLPLUS:

sql> startup mount
sql> alter database open resetlogs

Filed Under: oracle

Some more articles you might also be interested in …

  1. How to find the Oracle Database size
  2. How to check the status of OMS and Agent in OEM 13cR2
  3. Empty Directories in the Flash Recovery Area (FRA) are not deleted
  4. Beginners Guide to RMAN compression for backups
  5. RMAN-06059 During RMAN Backup of archivelogs ( How to backup archivelogs moved to a different location)
  6. How to relocate or move oracle database files using RMAN
  7. Rman Backups Failing with RMAN-20004
  8. How to convert Linux dd .img to .VDI, VMDK, VHD with VIrtualBox Command
  9. How to Start/Stop/Relocate SCAN listener in Oracle 11gR2 RAC
  10. Beginners Guide to Sequences in Oracle

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright