Showing posts with label BACKUP N RECOVERY. Show all posts
Showing posts with label BACKUP N RECOVERY. Show all posts
Sunday, 27 April 2025

How to move a datafile that was added by mistake on local storage to shared location

›
In Real Application Cluster (RAC) environments, data files need to be on shared storage. It is possible that a data file gets added to a tab...
Wednesday, 14 August 2019

Check the last incarnation restore time of oracle database

›
Check the last incarnation restore time when the database is started with resetlogs command with following command. Incarnation is th...
6 comments:
Wednesday, 30 September 2015

Move a datafile with RMAN

›
Using RMAN is the best way before 12c to relocate a datafile with a minimum downtime. The only downtime is for switching from the old data...
Thursday, 23 July 2015

How to catalog backups / archivelogs / datafile copies / control file copies

›
RMAN Catalog: It is mainly used for following: Can store database backup scripts and backup information to safe place(RMAN Repositor...
Monday, 1 June 2015

Recovery of database using RMAN backup when system datafile is lost

›
DB Name:  TESTDB [oracle@test dbf]$   ls redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf...
1 comment:
Tuesday, 28 April 2015

Restore the database from tape backup of the Database

›
Suppose the entire server is lost,  we have the  tape copy of the backup of the database , which includes RMAN backup pieces and control...