{"id":912,"date":"2008-10-17T15:09:21","date_gmt":"2008-10-17T19:09:21","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/"},"modified":"2008-10-17T15:15:24","modified_gmt":"2008-10-17T19:15:24","slug":"oracle-database-recovery-scenario-and-solution","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/","title":{"rendered":"Oracle Database Recovery Scenario and Solution"},"content":{"rendered":"

The purpose of this article \u00a0is to get acquianted with some of the recovery scenarios , this topic is useful for the folks who is having less experience and looking for good DBA exposure and preparing for interview .<\/p>\n

\u00a0\u00a0 I am trying to\u00a0 jotting down both RMAN and normal database technique :-<\/p>\n

\u00a01.Complete Closed database Recovery. System tablespace is missing <\/font><\/strong>\u00a0<\/font>In this case complete recovery is performed, only the system tablespace is missing , so the database can be opened without resetting the redologs.<\/font>\u00a0<\/font><\/p>\n

    \n
  1. rman target\/<\/font><\/li>\n
  2. startup nomount;<\/font><\/li>\n
  3. restore database ;<\/font><\/li>\n
  4. recover database ;<\/font><\/li>\n
  5. alter database open;<\/font><\/li>\n<\/ol>\n

    If the system tablespace is missing or corrupted the database can not be started up so a complete closed database recovery must be performed.<\/font><\/p>\n

    Pre \u2013 requisites: A closed or open database backup and archive logs.<\/font><\/p>\n

    a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Use OS command to restore the missing or corrupted system datafile to its original location , i.e. :<\/font><\/p>\n

    cp \u2013p \/fh01\/backup\/uman\/system01.dbf\u00a0\u00a0 \/fh02\/oradata\/system01.dbf <\/font><\/p>\n

    b.\u00a0\u00a0\u00a0\u00a0\u00a0 startup mount;<\/font><\/p>\n

    c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 recover datafile 1 ;<\/font><\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 alter database open ;<\/font><\/p>\n

    2. Complete Open Database Recovery. Non \u2013 System tablespace is missing.<\/strong>\u00a0\u00a0 If a non system tablespace is missing or corrupted while the database is open, recovery<\/strong><\/font>\u00a0\u00a0 Can be performed while the database remains open<\/strong>.<\/font>Pre \u2013 requisites: A closed or open database backup and archive logs.<\/font>a\u00a0\u00a0\u00a0 .\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cp \u2013p \/fh01\/backup\/uman\/user01.dbf\u00a0 \/fh02\/oradata\/user01.dbf<\/font>b.\u00a0\u00a0\u00a0\u00a0\u00a0 alter tablespace <tablespace_name> offline immediate ;<\/font>c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 recover tablespace <tablespace_name> ;<\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 alter tablespace <tablespace_name> online ;<\/p>\n

    a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 rman target \/<\/p>\n

    b.\u00a0\u00a0\u00a0\u00a0\u00a0 sql \u2018alter tablespace <tablespace_name> offline immediate ;<\/p>\n

    c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 restore datafile 3;<\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 recover datafile 3;<\/p>\n

    e.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sql \u2018 alter tablespace <tablespace_name> online\u2019;<\/p>\n

    3. Complete Open Database Recovery .(when database is initially closed).Non system tablespace is missing .<\/strong>\u00a0<\/p>\n

    A user datafile is missing when trying to startup the database. The datafile can be turned offline and the database started up. Restore and\u00a0 recover are performed using Rman and without Rman .After recovery is preformed the datafile can be turned online again .<\/p>\n

    a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sqlplus \u201c as\/ sysdba\u201d<\/p>\n

    b.\u00a0\u00a0\u00a0\u00a0\u00a0 startup mount<\/p>\n

    c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 alter database datafile \u2018<datafile_name>\u2019 offline ;<\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 alter database open ;<\/p>\n

    e.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exit ;<\/p>\n

    f.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 rman target \/<\/p>\n

    g.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 restore datafile \u2018<datafile_name>\u2019;<\/p>\n

    h.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 recover datafile \u2018<datafile_name>\u2019;<\/p>\n

    i.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sql \u2018alter tablespace <tablespace_name> online\u2019;<\/p>\n

    If a non system datafile that was not backed up since last backup is missing, recovery can be perform if all archived logs since the creation of the missing datafile exist. Since database is up you can check the tablespace .<\/p>\n

    If a non system tablespace is missing or corrupted and the database is crashed ,recovery can be performed after the database is open .<\/p>\n

    \u00a0Pre requisites: – A closed or open database backup and archived logs .\u00a0a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 startup ; (You ill get Ora \u2013 1157 ora \u2013 1110 and the name of the missing datafile , the database ill remain mounted )<\/p>\n

    b.\u00a0\u00a0\u00a0\u00a0\u00a0 Use OS commands to restore the missing or corrupted datafile to its original location\u00a0 i.e<\/p>\n

    cp \u2013p \/fh01\/backup\/uman\/user01.dbf\u00a0 \/fh02\/oradata\/user01.dbf\u00a0\u00a0<\/p>\n

    c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Alter database datafile3 offline; (Tablespace cannot be used because database is not open )<\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 Alter database open ;<\/p>\n

    e.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Recover datafile 3;<\/p>\n

    f.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Alter tabelspace <tablespace_name> online;<\/p>\n

    4. Recovery of missing datafile that has no backup (database is open)<\/strong>If a non system datafile that was not backed up since last backup is missing, recovery can be perform if all archived logs since the creation of the missing datafile exist.<\/strong>\u00a0<\/p>\n

    Pre requisites : All relevant archived logs.<\/p>\n

    a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Alter tablespace <tablespace_name> offline immediate ;<\/p>\n

    b.\u00a0\u00a0\u00a0\u00a0\u00a0 Alter tablespace create datafile \u2018\/fh02\/oradata\/newdata.dbf\u2019 ;<\/p>\n

    c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Recover tablespace <tablespace_name> ;<\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 Alter tablespace <tablespace_name> online ;<\/p>\n

    If the datafile command needs to be executed to place the datafile on a location different than the original use :<\/p>\n

    \u00a0 Alter database create datafile \u2018\/fh01\/backup\/uman\/newdata.dbf\u2019 as \u2018\u2018\/fh02\/oradata\/rajat\/newdata.dbf\u2019 ;<\/p>\n

    1.\u00a0\u00a0\u00a0\u00a0\u00a0 sqlplus \u201c\/as sysdba \u201c<\/p>\n

    2.\u00a0\u00a0\u00a0\u00a0\u00a0 Alter tablespace <tablespace_name> offline immediate ;<\/p>\n

    3.\u00a0\u00a0\u00a0\u00a0\u00a0 Alter tablespace create datafile \u2018\/fh01\/backup\/uman\/newdata.dbf\u2019 ;<\/p>\n

    4.\u00a0\u00a0\u00a0\u00a0\u00a0 exit<\/p>\n

    5.\u00a0\u00a0\u00a0\u00a0\u00a0 rman\u00a0 target \/<\/p>\n

    6.\u00a0\u00a0\u00a0\u00a0\u00a0 Recover tablespace <tablespace_name> ;<\/p>\n

    7.\u00a0\u00a0\u00a0\u00a0\u00a0 Alter tablespace <tablespace_name> online ;<\/p>\n

    If the datafile command needs to be executed to place the datafile on a location different than the original use :<\/p>\n

    \u00a0\u00a0\u00a0\u00a0 Alter database create datafile \u2018\/fh01\/backup\/uman\/newdata.dbf\u2019 as \u2018\u2018\/fh02\/oradata\/rajat\/newdata.dbf\u2019 ;<\/p>\n

    5.Restore and Recovery of a datafile to a different location , Database is up<\/strong>.<\/p>\n

    If a non \u2013 system datafile is missing and its original location is not available , restore can be made to different location\u00a0 and recovery performed.<\/p>\n

    Pre Requisites: – All relevant archived logs , complete cold or hot backup.<\/p>\n

    a. \u00a0Use OS commands to restore the missing or corrupted datafile to its original location\u00a0 i.e<\/p>\n

    cp \u2013p \/fh01\/backup\/uman\/user01.dbf\u00a0 \/fh02\/oradata\/user01.dbf<\/p>\n

    b. alter tablespace <tablespace_name> offline immediate ;<\/p>\n

    c. alter tablespace <tablespace_name> rename datafile \/fh01\/oradata\/user01.dbf\u2019 to \u2018 \/fh02\/oradata\/rajat\/user01.dbf\u2019<\/p>\n

    d. rman target \/<\/p>\n

    e. recover tablespace <tablespace_name><\/p>\n

    f. sql \u2018 alter tablespace <tablespace_name> online \u2018 ;<\/p>\n

    If a non \u2013 system datafile is missing and its original location is not available , restore can be made to different location\u00a0 and recovery performed.<\/p>\n

    Pre Requisites: – All relevant archived logs , complete cold or hot backup.<\/p>\n

    a.\u00a0 Use OS commands to restore the missing or corrupted datafile to its original location\u00a0 i.e<\/p>\n

    cp \u2013p \/fh01\/backup\/uman\/user01.dbf\u00a0 \/fh02\/oradata\/user01.dbf<\/p>\n

    b. alter tablespace <tablespace_name> offline immediate ;<\/p>\n

    c. alter tablespace <tablespace_name> rename datafile\u00a0 \/fh01\/oradata\/user01.dbf\u2019 to \u2018 \/fh02\/oradata\/rajat\/user01.dbf\u2019<\/p>\n

    d. recover tablespace <tablespace_name><\/p>\n

    e. alter tablespace <tablespace_name> online<\/p>\n

    6. Control file recovery <\/strong>\u00a0<\/strong><\/p>\n

    \u00a0Always multiplex your control files. Control files are missing , database crash.<\/p>\n

    Pre Requisites: A backup of your controlfile , and all relevant archived log files .<\/p>\n

    a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 startup;(You get ora \u2013 205 , missing control file, instance start but database is not mounted )<\/p>\n

    b.\u00a0\u00a0\u00a0\u00a0\u00a0 Use OS command to copy the missing controlfile to its original location<\/p>\n

    cp \u2013p \/fh01\/backup\/uman\/control101.dbf\u00a0 \/fh02\/oradata\/control101.dbf<\/p>\n

    c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 alter database mount ;<\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 recover automatic database using backup controlfile ;<\/p>\n

    e.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 alter database open resetlogs ;<\/p>\n

    f.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 make a new complete backup , as the database is open in a new incarnation and previous archived log are not relevant.<\/p>\n

    Always multiplex your control files. Control files are missing , database crash.<\/p>\n

    Pre Requisites: A backup of your controlfile , and all relevant archived log files.When<\/p>\n

    Using Rman always set configuration parameter.<\/p>\n

    Autobackup of controlfile to ON . You will need the dbid to restore the controlfile.<\/p>\n

    Get it from the name of the backup controlfile.<\/p>\n

    It is the number following the \u2018c-\u2018 at the start of the same.<\/p>\n

    a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 rman target\/<\/p>\n

    b.\u00a0\u00a0\u00a0\u00a0\u00a0 set dbid <dbid><\/p>\n

    c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 startup nomount ;<\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 restore controlfile from autobackup ;<\/p>\n

    e.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 alter database mount ;<\/p>\n

    f.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 recover database;<\/p>\n

    g.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 alter database open resetlogs ;<\/p>\n

    h.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 make a new complete backup , as the database is open in a new incarnation and previous archived log are not relevant<\/p>\n

    \u00a07.\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong>Incomplete Recovery, Until Time\/Sequence\/Cancel <\/strong>\u00a0<\/strong>\u00a0<\/strong><\/p>\n

    \u00a0\u00a0\u00a0 <\/strong>Incomplete recovery may be necessary when the database crash and needs to be recovered, and in recovery process you find that an archived log is missing .In this case recovery can only be made until the sequence before the one that is missing.<\/p>\n

    Another scenario for incomplete recovery occurs when an important object was dropped or incorrect data was committed on it.<\/p>\n

    \u00a0In this case recovery needs to be performed until before the object was dropped.<\/p>\n

    Pre requisites: A full closed or open database backup and archived logs , the time or sequence that the \u2018until\u2019 recovery needs to be performed .<\/p>\n

    \u00a0\u00a0a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If the database is open , shutdown it to perform full restore.<\/p>\n

    b.\u00a0\u00a0\u00a0\u00a0\u00a0 Rman target \\<\/p>\n

    c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Startup mount ;<\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 Restore database ;<\/p>\n

    e.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Recover database until sequence 8 thread 1 ;(You must pass the thread , if a single instance ill be always be 1 )<\/p>\n

    a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If the database is open , shutdown abort<\/p>\n

    b.\u00a0\u00a0\u00a0\u00a0\u00a0 Use OS commands to restore all the datafiles to its original locations :<\/p>\n

    Cp \u2013p \/user\/backup\/*.dbf\u00a0 \/u01\/oradata\/<\/p>\n

    c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 startup mount ;<\/p>\n

    d.\u00a0\u00a0\u00a0\u00a0\u00a0 recover automatic database until time \u20182007-01-01:10:10:10\u2019 ;<\/p>\n

    e.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 alter database open resetlogs ;<\/p>\n

    f.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 make a new complete backup , as the database is open in a new incarnation and previous archived log are not relevant<\/p>\n

    Alternatively you may use instead of until time , until sequence or until cancel ;<\/p>\n

    Recover automatic database until sequence 120 thread 1 ;or<\/p>\n

    Recover database until cancel ;<\/p>\n

    \u00a0\u00a0\u00a0<\/p>\n

    <\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

    The purpose of this article \u00a0is to get acquianted with some of the recovery scenarios , this topic is useful […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[424],"tags":[],"class_list":["post-912","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"\nOracle Database Recovery Scenario and Solution -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database Recovery Scenario and Solution -\" \/>\n<meta property=\"og:description\" content=\"The purpose of this article \u00a0is to get acquianted with some of the recovery scenarios , this topic is useful […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-10-17T19:09:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-10-17T19:15:24+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/\",\"name\":\"Oracle Database Recovery Scenario and Solution -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2008-10-17T19:09:21+00:00\",\"dateModified\":\"2008-10-17T19:15:24+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database Recovery Scenario and Solution\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Database Recovery Scenario and Solution -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database Recovery Scenario and Solution -","og_description":"The purpose of this article \u00a0is to get acquianted with some of the recovery scenarios , this topic is useful […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/","article_published_time":"2008-10-17T19:09:21+00:00","article_modified_time":"2008-10-17T19:15:24+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/","name":"Oracle Database Recovery Scenario and Solution -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2008-10-17T19:09:21+00:00","dateModified":"2008-10-17T19:15:24+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/10\/17\/oracle-database-recovery-scenario-and-solution\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Database Recovery Scenario and Solution"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/912","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=912"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/912\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}