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
resetlogs | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Restore RMAN backup to another server for testing disaster recovery procedures as well as for cloning

  • Posted by Gavin Soorma
  • On July 5, 2013
  • 0 Comments
This note explains the procedure used to restore an Oracle Suggested Strategy incremental backup on another server. This is useful when we have to do periodic  testing of disaster recovery procedures where we simulate a scenario when the complete database server has crashed and a new server has been provisioned. But let us assume that […]
Read More
 

Recovery through RESETLOGS and reset of the incarnation of the database

  • Posted by Gavin Soorma
  • On October 27, 2011
  • 1 Comments
Prior to Oracle 10g, the redo log files generated after opening the database with RESETLOGS could not be used with the backups taken before the RESETLOGS was performed. Therefore, whenever a resetlogs was done, it was important to take an immediate full database backup, since all previous backups became invalid. Just to recap, a RESETLOGS […]
Read More
 4

Flashback database – with and without resetlogs.

  • Posted by Arjun Raja
  • On August 11, 2009
  • 0 Comments
FLASHBACK DATABASE – IMPACT OF RESETLOGS- A flashback database can be completed and the database can either be opened for READ ONLY or opened with a RESETLOGS option. As long as the RESETLOGS option is not used, a flashback can be rolled back . Example – Create table test – insert some records – select […]
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 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