{"id":339,"date":"2024-07-20T19:35:58","date_gmt":"2024-07-20T19:35:58","guid":{"rendered":"https:\/\/humtechno.com\/intro\/?p=339"},"modified":"2024-09-21T09:27:27","modified_gmt":"2024-09-21T09:27:27","slug":"oracle-rman-backup-restore-linux","status":"publish","type":"post","link":"https:\/\/humtechno.com\/intro\/2024\/07\/20\/oracle-rman-backup-restore-linux\/","title":{"rendered":"Oracle RMAN Backup Restore (Linux)"},"content":{"rendered":"\n

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

Step 1 : Parameter Files not Exist its fresh RMAN Backup Restore on New Environment<\/h4>\n\n\n\n

export ORACLE_SID = mydb1
rman target \/
startup nomount;
Restore spfile from ‘\/backup\/backup\/c-1680948073-20210520-00’;
exit
sqlplus \/ as sysdba
create pfile from spfile;<\/p>\n\n\n\n

Change Required Parameters File in Oracle Home dbs (Linux) or Database (Windows) Folder “initmydb1.ora”<\/strong><\/p>\n\n\n\n

After Performed Changes in New Pfile execute below Steps<\/strong><\/p>\n\n\n\n

sqlplus \/ as sysdba
shutdown immediate;
startup nomount;
create spfile from Pfile;
shutdown immediate;
startup nomount;<\/p>\n\n\n\n

Step 2 : Restore Control file<\/h4>\n\n\n\n

rman target \/
restore controlfile from ‘\/backup\/backup\/master_200521\/c-1680948073-20210520-00’;
alter database mount;<\/p>\n\n\n\n

Step 3 : Catalog Backup<\/h4>\n\n\n\n

rman target \/
Crosscheck backup;
noprompt delete expired backup;
catalog start with ‘\/backup\/backup’;<\/p>\n\n\n\n

Step 4 : Create script of Restore<\/h4>\n\n\n\n

If you want to restore on Non ASM File System and New File System of Data file below statement will generate Script and then you need to Change the Path<\/p>\n\n\n\n

sqlplus \/ as sysdba
set linesize 1000
set pagesize 10000
select ‘SET NEWNAME FOR DATAFILE ‘ || file# || ‘ TO ‘ || ”” || name || ”” || ‘;’ from v$datafile;<\/p>\n\n\n\n

Restore Scripts<\/strong><\/p>\n\n\n\n

mkdir \/backup\/logs
mkdir \/backup\/scripts
vi \/backup\/scripts\/rman_restore.sh<\/p>\n\n\n\n

export ORACLE_SID=mydb
export ORACLE_HOME=\/u01\/app\/oracle\/19.2.0\/db_home1\/
export PATH = $PATH:$ORACLE_HOME
rman target \/ LOG=’\/backup\/logs\/rman_restore.log’ <<EOF
run{
SET NEWNAME FOR DATAFILE 1 TO ‘\/data\/database\/mydb\/o1_mf_system_lvpwl674_.dbf’;
SET NEWNAME FOR DATAFILE 2 TO ‘\/data\/database\/mydb\/CISTS_01_1.dbf’;
SET NEWNAME FOR DATAFILE 3 TO ‘\/data\/database\/mydb\/o1_mf_sysaux_lvpwnvoc_.dbf’;restore database;
SWITCH DATAFILE ALL;
Recover database;
}
exit;
EOF<\/p>\n\n\n\n

Step 5 : Execute Restore<\/h4>\n\n\n\n

Check Incarnation of Database it should be same as database which backup you are restoring<\/strong><\/p>\n\n\n\n

rman target \/
list incarnation of database;<\/p>\n\n\n\n

If not Same then change Incarnation<\/strong><\/p>\n\n\n\n

rman target \/
RESET DATABASE TO INCARNATION 2;<\/p>\n\n\n\n

nohup sh \/backup\/scripts\/rman_restore.sh &<\/p>\n\n\n\n

Step 6 : Monitoring RMAN<\/h4>\n\n\n\n

sqlplus \/ as sysdba<\/p>\n\n\n\n

SELECT round(( ( ( sofar ) \/ (totalwork) ) *100) ,10) “% Complete” FROM v$session_longops WHERE opname LIKE ‘RMAN%’
AND opname NOT LIKE ‘%aggregate%’
AND totalwork != 0;<\/p>\n\n\n\n

tail -f \/backup\/logs\/rman_restore.log<\/p>\n\n\n\n

Step 7 : Recover Database<\/h4>\n\n\n\n

If Required to Restore Specific Archive Files (If Restore Database Complete but Error in Recovery no any archive Restore and Recover)<\/strong><\/p>\n\n\n\n

rman target \/
restore archivelog from sequence 72457 until sequence 72475 thread 1;
restore archivelog from sequence 72527 until sequence 72545 thread 2;
recover database;
or
sqlplus \/ as sysdba
recover database using backup control file until cancel;
enter “auto”<\/p>\n\n\n\n

Step 8 : Change File Location<\/h4>\n\n\n\n

Change Temp File and Redo Log File Path Before Opening Database by using SQL Script.
<\/strong>sqlplus \/ as sysdba
select ‘Alter database rename file ‘ || ”” || member || ”” || ‘ to ‘ || ”” || member || ”” || ‘;’ from v$logfile;
select ‘Alter database rename file ‘ || ”” || name || ”” || ‘ to ‘ || ”” || name || ”” || ‘;’ from v$tempfile;
Alter database rename file ‘+PDATA\/T24PRODDB\/ONLINELOG\/group_64.838.1080826843’ to ‘+DATA\/T24STG\/ONLINELOG\/group_64.838.1080826843’;
alter database rename file ‘+DATA\/T24STG\/B34E68EABF0501A0E0530AAC15194891\/TEMPFILE\/temp.864.1069657275’ to ‘+PDATA\/T24PRODDB\/B34E68EABF0501A0E0530AAC15194891\/TEMPFILE\/temp.864.1069657275’;<\/p>\n\n\n\n

Step 9 : Open Database in Reset Logs
<\/strong>recover database using backup controlfile until cancel;
alter database open resetlogs;
shutdown immediate;
startup nomount;
if using wallet open wallet
alter database mount;
alter database open;<\/p>\n\n\n\n

Step 10 : Disable RAC node if RAC to Single Database
<\/strong>sqlplus \/ as sysdba
alter database enable thread 2;<\/p>\n\n\n\n

Step 11 : If using Container Databases
<\/strong>sqlplus \/ as sysdba
ALTER PLUGGABLE DATABASE all open;
ALTER PLUGGABLE DATABASE ALL SAVE STATE;<\/p>\n\n\n\n

Step 12 : Check and Create temporary Tablespace
<\/strong>sqlplus \/ as sysdba
SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME = ‘DEFAULT_TEMP_TABLESPACE’;
CREATE TEMPORARY TABLESPACE TEMP_02 TEMPFILE ‘\/data\/database\/t24stgdr3\/temp_02.dbf’ SIZE 500m autoextend on next 10m maxsize unlimited;<\/p>\n\n\n\n\n\n

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

Download PDF<\/p>\n","protected":false},"author":1,"featured_media":333,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[3],"tags":[23,24,25],"class_list":["post-339","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle-database-restore","tag-restore-database","tag-rman-restore"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/339","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=339"}],"version-history":[{"count":11,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/339\/revisions"}],"predecessor-version":[{"id":533,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/339\/revisions\/533"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/333"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}