1 minutes readCase 3: lost data file and we have no backup (When database open)

Anup October 5, 2023

0 Comments

Reader Mode

Step 1 offline the datafile

SQL> alter database datafile ‘’ offline;

Step 2 Create datafile

SQL> Create database create datafile ‘’ as ‘’ size ;

Step 3 Recover the datafile

SQL> recover datafile ‘’;

Step 4 Online the datafile

SQL> alter database datafile ‘’ online;

Post Views: 51

Categories: Backup/Recovery, Blog

Recovery from Disaster

Reader Mode Introduction: – i.e. a situation in which your database server has been destroyed and has taken all your database files (control files, logs…

Anup May 20, 2011

0 Comments

How to Perform User Managed Inconsistent Backup & Recovery (With Example)

Reader Mode1. Backup all data file and Control file by using following commands on every Sunday. (BACKUP SCRIPTS) host ocopy C:OracleRDBMS*.001 e:temphost del C:OracleRDBMS*.001 /qset…

Anup April 8, 2010

0 Comments

Disaster Recovery

Reader ModeDisaster Recovery Introduction:– i.e. a situation in which your database server has been destroyed and has taken all your database files (control files, logs…

Anup March 8, 2010

0 Comments

Upgrade CRS and Database 10.2.0.1 to 10.2.0.5

Reader ModeFirst Task to Upgrade CRS Database Name: PROD Instances: PROD1 Node name: racnode1 Instances: PROD2 Node name: racnode2 Oracle Database Home and ASM Home:…

Anup October 6, 2022

0 Comments

Creating Standby Database Manually

Reader ModeThis document contains a guide on setting up standby databases for maximum protection, using command line mode, and avoiding using the GUI. To do…

Anup June 1, 2009

0 Comments

Related Articles

Responses