Skip to content
Saturday, May 28, 2022
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
  • Home
  • Backup and Recovery

Category: Backup and Recovery

Cold Backup

20 August 202020 August 2020 Administrator

SQL> create table cold_back(name varchar(100)); Table created. SQL> insert into cold_back values(‘* DATA INSERTED BEFORE BACKUP ***’); 1 Read More…

Restore archive logs from backup

20 August 202020 August 2020 Administrator

Restoring a archive log (LOG SEQ) from backups. [[email protected] backups]$ rman target / Recovery Manager: Release 11.2.0.4.0 – Production on TuRead More…

What happens during HOT BACKUP?

19 August 202019 August 2020 Administrator

During hot backup, a script or begin backup command puts a tablespace into backup mode, then copies the datafiles to disk or tape, then takes the tabRead More…

Basic Backup Techniques

18 August 202018 August 2020 Administrator

Oracle Provide you with More than Way to Backup Let’s talk about them shortly : 1- Hot Backup performed on data even though it is actively acceRead More…

Restore standby database using incremental backup

18 August 202018 August 2020 Administrator

1) Find the current scn of Standby database select current_scn from v$database; CURRENT_SCN 750098 2) Take incremental backup on primRead More…

RECRATE CORRUPTED ORACLE INVENTORY

18 August 202018 August 2020 Administrator

First let us understand what is orainventoy where it exists and what it contains oraInventory is repository (directory) which store oracle softwarRead More…

Recover datafile without backup

18 August 202018 August 2020 Administrator

IF you newly created datafile has gone and you didnĂ­t get change to take backup after creation if your database in archive mode then you will be recRead More…

How to recover database if system datafile lost

18 August 202018 August 2020 Administrator

If system datafile removed from disk then you can recover system datafile only in mount state of database. SQL> alter tablespace system offlineRead More…

How to recover a deleted datafile when database is open

18 August 202018 August 2020 Administrator

On development server a team member try to access the data from a table got below error messages as datafile not find after searching we found that dRead More…

Block corruption

18 August 202018 August 2020 Administrator

1) Create a tablespace SQL> create tablespace abc datafile ‘C:\APP\USER\ORADATA\MYDATABASE\abc.dbf’ size 200k; 2) Connect the user create a Read More…

Posts navigation

Older posts

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 58
  • 29,908

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.