DisplayAdd1

TechnoTechDB is a platform, which will help to grow your carrier in Information sector. Having 15 years of Experience in Oracle/MongoDB/Postgres/Mysql databases, along with having good expertise level of knowledge in Scripting to automate database task. Our goal to start with zero to hero level expertise in Database. You can access/refer my some blogs on https://mrorcldba.blogspot.com link and post your comments and your suggestion to motive us.

Saturday, 23 January 2016

Archive log gap Resolve on standby using RMAN incremental backup


Resolve Archive log gap on standby using RMAN incremental backup if missing of logs from standby and  primary.


--on standby

SQL>  select distinct checkpoint_change# from v$datafile_header order by 1;

note down minimums SCN number for incremental  backup


--on Primary

RMAN> run
 {
 BACKUP as compressed backupset device type disk INCREMENTAL FROM SCN 6504939829410 DATABASE FORMAT '/var/opt/backups/incremental_orcl_%U' tag
  'FOR_STANDBY_24July_2015';
 }

RMAN>  backup current controlfile for standby format '/var/opt/backups/new_orcl_contorl_stb.ctl';

sftp oracle backup to standby database


--on standby

NOTE down data FILE ID name FILE name of datafile on standby in case of data file rename.
NOTE down temp FILE ID and name FILE name of datafile on standby in case of temp data file rename.
NOTE down redo name FILE name of datafile on standby.



SQL>set head off pages 0 feed off echo off verify off
SQL>set lines 200
SQL>spool rename_datafiles.lst
SQL>select 'SET NEWNAME FOR DATAFILE ' || FILE# || ' TO ''' || '+asm_data_dg/dbci1sb/datafile/' || substr(name,instr(name,'/',-1)+1) || ''';' from v$datafile;
SQL>spool off

SQL>set head off pages 0 feed off echo off
SQL>spool rename_logfiles.lst
SQL>SELECT 'SQL "ALTER DATABASE RENAME FILE '''''||  MEMBER ||'''''' ||chr(10)||'to ''''' || member || '''''" ;' FROM V$LOGFILE;

SQL> create pfile='/tmp/init.ora' from spfile;
SQL> alter database backup controlfile to trace as '/tmp/col_ctrl.sql'


RMAN> report schema
RMAN> list incarnation of database;
RMAN> backup current controlfile  format '/var/opt/backups/orcl_contorl_stb_old.ctl';

SQL> shut immediate
shut down database and remove old controlfile

SQL>  startup nomount
RMAN> restore contorlfile from '/var/opt/backups/new_orcl_contorl_stb.ctl';
RMAN>  run
{
SET NEWNAME FOR DATAFILE 1 TO '+ASM_DATA_DG/orcldbci1sb/datafile/system.1590.859964471';
SET NEWNAME FOR DATAFILE 2 TO '+ASM_DATA_DG/orcldbci1sb/datafile/sysaux.1081.859965099';
SET NEWNAME FOR DATAFILE 3 TO '+ASM_DATA_DG/orcldbci1sb/datafile/undotbs1.1079.859975849';
SET NEWNAME FOR DATAFILE 4 TO '+ASM_DATA_DG/orcldbci1sb/datafile/undotbs2.2493.859958385';
SET NEWNAME FOR DATAFILE 5 TO '+ASM_DATA_DG/orcldbci1sb/datafile/users.1532.859968013';
switch datafile all;
switch tempfile all;
}

RMAN> recover database noredo;




No comments:

Post a Comment

Steps to Rename Host in Oracle RESTART (ASM) in Linux

  oracle@localhost ] asmcmd ASMCMD> lsdg State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_...