{"id":676,"date":"2024-12-04T20:52:44","date_gmt":"2024-12-04T20:52:44","guid":{"rendered":"https:\/\/humtechno.com\/intro\/?p=676"},"modified":"2024-12-04T20:55:29","modified_gmt":"2024-12-04T20:55:29","slug":"oracle-database-recovery","status":"publish","type":"post","link":"https:\/\/humtechno.com\/intro\/2024\/12\/04\/oracle-database-recovery\/","title":{"rendered":"Oracle Database Recovery"},"content":{"rendered":"\n\n\n\n

Download Free PDF<\/a><\/p>\n\n

Situation 1<\/strong><\/p>\n\n

    \n
  1. No Database Backup<\/li>\n\n\n\n
  2. No Control file Backup<\/li>\n\n\n\n
  3. No Control file<\/li>\n\n\n\n
  4. Some Data files Corrupted<\/li>\n<\/ol>\n\n

    Create PFile<\/strong><\/p>\n\n

    export ORACLE_SID=test5<\/p>\n\n

    vi \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/dbs\/inittest5.ora<\/p>\n\n

    *.audit_file_dest=’\/u01\/app\/oracle\/admin\/test5\/adump’<\/p>\n\n

    *.audit_trail=’db’<\/p>\n\n

    *.compatible=’19.0.0′<\/p>\n\n

    *.control_files=’\/data\/test5\/control1.ctl’<\/p>\n\n

    *.db_block_size=8192<\/p>\n\n

    *.db_name=’test5′<\/p>\n\n

    *.diagnostic_dest=’\/u01\/app\/oracle’<\/p>\n\n

    *.dispatchers='(PROTOCOL=TCP) (SERVICE=test5XDB)’<\/p>\n\n

    *.log_archive_dest_1=’location=\/data\/test5\/archive’<\/p>\n\n

    *.memory_target=1049m<\/p>\n\n

    *.open_cursors=300<\/p>\n\n

    *.processes=320<\/p>\n\n

    *.remote_login_passwordfile=’EXCLUSIVE’<\/p>\n\n

    *.undo_tablespace=’UNDOTBS1′<\/p>\n\n

    Create Directories<\/strong><\/p>\n\n

    mkdir \u2013p \/u01\/app\/oracle\/admin\/test5\/adump<\/p>\n\n

    mkdir \/data\/test5<\/p>\n\n

    mkdir \/data\/test5\/archive<\/p>\n\n

    Control File Scripts<\/strong><\/p>\n\n

    CREATE CONTROLFILE<\/p>\n\n

    SET DATABASE test5<\/p>\n\n

    LOGFILE<\/p>\n\n

    GROUP 1 ‘\/data\/test5\/redo01_01.log’ size 5M,<\/p>\n\n

    GROUP 2 ‘\/data\/test5\/redo02_01.log’ size 5M<\/p>\n\n

    RESETLOGS<\/p>\n\n

    DATAFILE ‘\/data\/test5\/o1_mf_sysaux_mmw00w5g_.dbf’ reuse,<\/p>\n\n

    ‘\/data\/test5\/o1_mf_system_mmvzxlgr_.dbf’ reuse,<\/p>\n\n

    ‘\/data\/test5\/o1_mf_undotbs1_mmw029hf_.dbf’ reuse,<\/p>\n\n

    ‘\/data\/test5\/o1_mf_users_mmw02bq6_.dbf’ reuse,<\/p>\n\n

    ‘\/data\/test5\/tbs2.dbf’  reuse<\/p>\n\n

    MAXLOGFILES 50<\/p>\n\n

    MAXLOGMEMBERS 3<\/p>\n\n

    MAXLOGHISTORY 400<\/p>\n\n

    MAXDATAFILES 200<\/p>\n\n

    MAXINSTANCES 1<\/p>\n\n

    ARCHIVELOG;<\/p>\n\n

    Alter database mount;<\/p>\n\n

    select name from v$datafile;<\/p>\n\n

    select name from v$controlfile;<\/p>\n\n

    Alter database open resetlogs;<\/p>\n\n

    select table_name,tablespace_name from dba_tables where owner=’TEST’;<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":663,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[3],"tags":[107,108],"class_list":["post-676","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-database-recovery","tag-oracle-dataase-recovery"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=676"}],"version-history":[{"count":2,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/676\/revisions"}],"predecessor-version":[{"id":679,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/676\/revisions\/679"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/663"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}