These steps are for recovery in which we will know about how to recover from a loss of a non-system tablespace on the same location while the database is closed. Normally our database is always in open mode. In some cases we can face error ORA-01157: cannot identify/lock data file %s – see DBWR trace file” […]
Category: BACKUP AND RECOVERY
Recover from a loss of a non-system tablespace on the same location while the database is open
We are going to have a look on the steps which are followed by DBA to recover a loss of a non-system tablespace on the same location while the database is open. When we lose a non-system tablespace you cannot access and query only objects that were created on their datafiles Meanwhile users can continue to […]
Recover from a loss of a temporary tablespace
This article is about a recovery of temporary tablespace. As we know that Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory (see SORT_AREA_SIZE initialization parameter), space will be allocated in […]
Recover from a loss of a read-only tablespace
Being an Oracle DBA we are aware that there are many types of backups are available for Oracle database maintenance in the same way we have multiple ways to restore our database. One question raises here that why do we need have a different kind of ways to backup and recovery in Oracle database? Answer of this question […]
Restore lost non-system datafiles on a different location while the database is closed
With the help of this article today we are going to learn about those steps which are going to use during the restore lost non-system datafiles on different location the database is closed. In our previous post, we have discussed the restore lost non–system datafiles on a different location while the database while the database is open. We […]
Restore a lost non-system datafile on a different location while the database is open
We are going to have a look on those steps which are required to restore a lost nonsystem datafile on a different location during the Oracle a database is in open stage. We are going to lose datafiles of a non-system critical tablespace and restore them, while the database is open, to a location other […]
Switchback to the original location of the previously corrupted/damaged datafile
In this article, we are going to have look on How to switch back to the original location of the previously corrupted/damaged/lost/canceled datafile. RMAN> report schema; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name ORCL List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name […]
Recover a corrupted/damaged NON-SYSTEM datafile switching to an image copy when database in ARCHIVELOG mode
This article is about recovery of corrupted/damaged/lost/canceled NONSYSTEM datafile switching to an image copy when database in ARCHIVELOG mode. We must have an image copy of my datafiles: The following command is use to take copy. [oracle@localhost orcl]$ rman target / RMAN> backup as copy database; Starting backup at 19-07-2012 07:45:31 using channel ORA_DISK_1 channel ORA_DISK_1: […]
How to recover a corrupted/damaged NON SYSTEM datafile when database in ARCHIVELOG mode
We are going to have a session on recovery about corrupted/damaged/lost/canceled NONSYSTEM datafile (except system & sysaux). Before proceeding to be sure to have a complete backup of your test database and be sure your database is in ARCHIVELOG mode. [oracle@localhost orcl]$ ps -ef|grep smon oracle 7200 2820 0 06:57 pts/1 00:00:00 grep smon And […]
Backup a database in non-archivelog mode without recovery catalog
This article is about the backup of an Oracle database. As DBA we are well known about the types of backup. Mainly we have two kind of backups in Oracle database first one is physical and another one is logical. Each type of backups is important in Oracle database’s life maintenance. It depends on projects and client’s requirements that what kind of […]