|
||||
|
As discussed, earlier, Another important nice feature in RMAN from 12c is using network based recovery or incremental backup strategy from the servics. This eliminates taking incremental backups or copy those backup to standby and saves lot of time. Lets check, On Primary, check the latest log Check on Primary SQL> archive log […] From 12c Onwards, RMAN has been enhanced to restore/recover the datafiles/tablespaces etc from the network services rather copying them manually. This enhanancement facilitates easy recovery operations when you have standby database without backups or activation etc. YOu can even recover the database from standby using service in RMAN in restore command. Lets see how […] Excellent step by step document from my colleague, Venkat, with his kind permission I am publishing the same for all benefit. Please note the following can be done using Duplicate database from active database without moving any backups etc. But that is another variant. ########################################################################################### Copy RAC database to another RAC Server ########################################################################################### Task: Copy […] Here is the step by step document for recovering the standby if archive is missing and not recoverable, using a feature called rollforward standby using incremental backup introduced in 10g. 1) After recovery in step above login to sqlplus and get the current scn from standby database; SQL> col CURRENT_SCN format 999999999999 SQL> select current_scn […] Series: Part 1, Part 2, Part3 Typical Oracle physical corruptions may pose are, (a) ORA-01578 – This error explains physical structural damage with a particular block. (b) ORA-08103 – This error is a logical corruption error for a particular data block. (c) ORA-00600 [2662] – This error is related to block corruption , and occurs […] Series: Part 1, Part 2, Part3 Oracle will have two types of corruptions , Physical & Logical corruptions. Physical Block Corruptions This kind of block corruptions are normally reported by Oracle with error ORA-1578 and the detailed corruption description is printed in the alert log. Corruption Examples are: Bad header – the beginning of the […] SQL> recover database ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done Am trying to recover a database after a controlfile lost and restored from the backup. But How does Oracle knows that we are using a backup control file where does it look after to get […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!