Category: Backup and Recovery

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

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…

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…

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…

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

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

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…

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

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…

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…