Tags » Backup/Recovery

Free Ebook on SQL Server Backup and Restore - thank you Red Gate

If you are starting to learn SQL Server administration, or just need to rehash on your backup and restore fundamentals, here’s a great ebook to read: 119 more words

SQL Server

How to create a physical standby database ?

Database Version : 11.2.0.X

Primary Database Name : OP01EODB

The database should be in archivelog mode .

Sqlplus / as sysdba

Select force_logging from v$database ; 193 more words

High Availability

30% Off - Tenorshare iPhone Data Recovery Discount Coupon Code


All-in-one iOS device data restore software
 All iOS Devices Supported
 iPhone/iPad/iPod Touch

System Requirements:
Platforms: Windows XP (32 bit), Windows Server 2012/2011/2008/2003, Vista, Windows 7, Windows 8 (32-bit and 64-bit) 720 more words


Recover Control File Scenarios

Secnario 1

The case where we have lost all the control files including the multiplexed ones and we do not have a backup of any controlfile available . 60 more words


How to find the archivelogs using SCN number ?

During database recovery, you may have a SCN number and need to know the archivelog names. Here is the SQL for the answer:

column first_change# format 9999999999999
column next_change# format 9999999999999
alter session set nls_date_format='DD-MON-RRRR HH24:MI:SS';
select name,thread#,sequence#,status,first_time,
from gv$archived_log 
where 9545121678404 between first_change# and next_change#; 26 more words

Security Fix Breaks Recovery

Oracle’s “Security Alert Advisory for CVE-2012-3132” issued a warning about an attack vector that once again was discovered by security expert David Litchfield… 454 more words


30% Off - Softtote Data Recovery for Mac Discount Coupon Code

List Price:
$69.99  $48.99       30% Off
Discount:               -$21.00
Coupon code:    BEST-XU61-MDNI

System Requirements:

Platforms: Mac OS X 10.5, 10.6, 10.7 Lion, 10.8
Processor: at least with x86… 668 more words