Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
recovery | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

RMAN Backup and Recovery scenarios involving loss of SPFILE

  • Posted by Gavin Soorma
  • On June 17, 2013
  • 3 Comments
Let us look at some backup and recovery scenarios pertaining to the SPFIILE. The SPFILE is a small but very important file and if we lose the spfile, we cannot start the database even if all the other database files are present and intact. So in my opinion, it is quite an important thing to […]
Read More
 3

Some more RMAN Recovery Scenarios

  • Posted by Gavin Soorma
  • On June 25, 2010
  • 11 Comments
I have added a few more RMAN recovery scenarios which I have come across recently and may be faced by others – so thought I’d share those with the community. The first relates to a case where we need to create a replica of a production database on a test or development environment and we […]
Read More
 

READ ONLY Tablespace Restore and Recovery

  • Posted by Gavin Soorma
  • On August 12, 2009
  • 0 Comments
Keeping static or historical data in read only tablespaces is a good practice especially for data warehouse type environments. Using the RMAN SKIP READONLY command, we can reduce the backup window and overhead as well by excluding these read only tablespaces from the database backupsets. But we need to keep in mind that we need […]
Read More
 

RMAN Backup and Recovery scenarios

  • Posted by Gavin Soorma
  • On July 14, 2009
  • 0 Comments
The following notes will illustrate the steps required to recover from a number of common failure scenarios that a DBA could possibly face in his career. RMAN Restore on another machine with different file system- same database name RMAN duplicate database on the same host Loss Of All Files – Disaster Recovery Incomplete Recovery (until […]
Read More
 

RMAN recovery from loss of all control files

  • Posted by Gavin Soorma
  • On July 3, 2009
  • 0 Comments
SCENARIO – LOSS OF ALL CONTROLFILES (NO CATALOG) To simulate this scenario, we will create and populate a table with some records, recover the database from a loss of all control files and then perform an incomplete recovery until the point of failure. SQL> insert into myobjects select * from myobjects; 919664 rows created. SQL> […]
Read More
 

Recovery From Loss Of Datafile For Which No Backup Is Available

  • Posted by Gavin Soorma
  • On July 2, 2009
  • 3 Comments
SCENARIO – 10g Database Loss of datafile which has not been backed up. CREATE NEW TABLESPACE TEST SQL> create tablespace test datafile ‘/u02/oradata/testdb/test.dbf’ size 10m; Tablespace created. TAKE A BACKUP OF THE DATABASE AT THIS POINT >>>>>>>>> ADD DATAFILE TO TEST TABLESPACE SQL> alter tablespace test add datafile ‘/u02/oradata/testdb/test01.dbf’ size 10m; Tablespace altered. SIMULATE FAILURE […]
Read More
 

Recovery from a backup taken before a RESETLOGS

  • Posted by Gavin Soorma
  • On June 28, 2009
  • 0 Comments
Simulate loss of redo log files [oracle@itlinuxdevblade08 opsdba]$ rm redo*.log Check alert log Errors in file /u02/ORACLE/opsdba/bdump/opsdba_arc1_29898.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u02/ORACLE/opsdba/redo01.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Wed Jun […]
Read More