Tuesday, 7 June 2016

Rebuild Standby database in Oracle


 
Prerequisite:
 
Suppose we have a production database RLLIVE and standby database RLLIVE.
We need to rebuild standby RLLIVE

COPY THE PROD BACKUP(DATABASE) TO STANDBY SERVER at location
 
/backup/oracle/RLLIVE/rman

SET THE ENVIRONMENT VARIABLE ON STANDBY SERVER

export ORACLE_SID=RLLIVE
export ORACLE_HOME=/oracle/app/product/12.1
export PATH=$ORACLE_HOME/bin:$PATH

START THE DATABASE IN NOMOUNT
RMAN> startup nomount;

CONNECT TO RLLIVE RMAN (On Standby Database)

$ rman target /
Recovery Manager: Release 12.1.0.1.0 - Production on Sat Jul 4 09:09:53 2015
Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
connected to target database: RLLIVE (not mounted)

RESTORE THE STANDBY CONTROL FILE
RMAN> restore controlfile from '/backup/oracle/RLLIVE/rman/ora_df884042243_s16134_s1_1.bak';
Starting restore at 04-JUL-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=402 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/data/oracle/RLLIVE/control01.ctl
output file name=/redo/oracle/RLLIVE/control02.ctl
Finished restore at 04-JUL-15

START STANDBY DATABASE IN MOUNT
RMAN> sql 'alter database mount standby database';
sql statement: alter database mount standby database
released channel: ORA_DISK_1

CATALOG RLLIVE  PROD BACKUPPIECES AFTER CONNECTING to TO STANDBY RMAN
RMAN> catalog start with '/backup/oracle/RLLIVE/rman';
searching for all files that match the pattern /backup/oracle/RLLIVE/rman
List of Files Unknown to the Database
=====================================
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150322-01
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150323-00
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150401-00
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150702-01
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150703-00
File Name: /backup/oracle/RLLIVE/rman/ora_df884042243_s16134_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884042298_s16136_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884042583_s16137_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884042889_s16138_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884043175_s16139_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884043460_s16140_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884043766_s16141_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884044091_s16142_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884044396_s16143_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884044692_s16144_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884044987_s16145_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884045263_s16146_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884045548_s16147_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884045854_s16148_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884046139_s16149_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884046445_s16150_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884046740_s16151_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884046996_s16152_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884047242_s16153_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884047517_s16154_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884047763_s16155_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884048038_s16156_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884048324_s16157_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884048770_s16158_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884049166_s16159_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884049511_s16160_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884049887_s16161_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884050223_s16162_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884050528_s16163_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884050854_s16164_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884051170_s16165_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884051455_s16166_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884051691_s16167_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884051976_s16168_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884052492_s16169_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884052968_s16170_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884053313_s16171_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884053599_s16172_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884053874_s16173_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884054150_s16174_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884054406_s16175_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884054701_s16176_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884054977_s16177_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884055233_s16178_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884055518_s16179_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884056125_s16180_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884056550_s16181_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884056856_s16182_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884057151_s16183_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884057427_s16184_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884057733_s16185_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884058028_s16186_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884058324_s16187_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884058610_s16188_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884058895_s16189_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884059171_s16190_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884059447_s16191_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884059752_s16192_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884060048_s16193_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884060333_s16194_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884060629_s16195_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884060914_s16196_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884061210_s16197_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884061505_s16198_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884061761_s16199_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884061986_s16200_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884062222_s16201_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884062457_s16202_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884062733_s16203_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884062998_s16204_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884063274_s16205_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884063520_s16206_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884063795_s16207_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884064081_s16208_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884064386_s16209_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884064742_s16210_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884065068_s16211_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884065394_s16212_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884065729_s16213_s1_1.bak
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150322-01
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150323-00
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150401-00
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150702-01
File Name: /backup/oracle/RLLIVE/rman/c-1753596596-20150703-00
File Name: /backup/oracle/RLLIVE/rman/ora_df884042243_s16134_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884042298_s16136_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884042583_s16137_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884042889_s16138_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884043175_s16139_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884043460_s16140_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884043766_s16141_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884044091_s16142_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884044396_s16143_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884044692_s16144_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884044987_s16145_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884045263_s16146_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884045548_s16147_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884045854_s16148_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884046139_s16149_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884046445_s16150_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884046740_s16151_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884046996_s16152_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884047242_s16153_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884047517_s16154_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884047763_s16155_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884048038_s16156_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884048324_s16157_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884048770_s16158_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884049166_s16159_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884049511_s16160_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884049887_s16161_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884050223_s16162_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884050528_s16163_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884050854_s16164_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884051170_s16165_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884051455_s16166_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884051691_s16167_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884051976_s16168_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884052492_s16169_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884052968_s16170_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884053313_s16171_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884053599_s16172_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884053874_s16173_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884054150_s16174_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884054406_s16175_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884054701_s16176_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884054977_s16177_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884055233_s16178_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884055518_s16179_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884056125_s16180_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884056550_s16181_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884056856_s16182_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884057151_s16183_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884057427_s16184_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884057733_s16185_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884058028_s16186_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884058324_s16187_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884058610_s16188_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884058895_s16189_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884059171_s16190_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884059447_s16191_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884059752_s16192_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884060048_s16193_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884060333_s16194_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884060629_s16195_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884060914_s16196_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884061210_s16197_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884061505_s16198_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884061761_s16199_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884061986_s16200_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884062222_s16201_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884062457_s16202_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884062733_s16203_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884062998_s16204_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884063274_s16205_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884063520_s16206_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884063795_s16207_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884064081_s16208_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884064386_s16209_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884064742_s16210_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884065068_s16211_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884065394_s16212_s1_1.bak
File Name: /backup/oracle/RLLIVE/rman/ora_df884065729_s16213_s1_1.bak
 
RESTORE DATABASE
RMAN> restore database;
Starting restore at 04-JUL-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=402 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /data/oracle/RLLIVE/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /data/oracle/RLLIVE/users02.dbf
channel ORA_DISK_1: restoring datafile 00003 to /data/oracle/RLLIVE/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /data/oracle/RLLIVE/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /data/oracle/RLLIVE/users03.dbf
channel ORA_DISK_1: restoring datafile 00006 to /data/oracle/RLLIVE/users01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /data/oracle/RLLIVE/users04.dbf
channel ORA_DISK_1: restoring datafile 00008 to /data/oracle/RLLIVE/indx_hi01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /data/oracle/RLLIVE/indx_hi02.dbf
channel ORA_DISK_1: restoring datafile 00010 to /data/oracle/RLLIVE/indx_hi03.dbf
channel ORA_DISK_1: restoring datafile 00011 to /data/oracle/RLLIVE/indx_audt01.dbf
channel ORA_DISK_1: restoring datafile 00012 to /data/oracle/RLLIVE/indx_audt02.dbf
channel ORA_DISK_1: restoring datafile 00013 to /data/oracle/RLLIVE/indx_audt03.dbf
channel ORA_DISK_1: restoring datafile 00014 to /data/oracle/RLLIVE/indx_audt04.dbf
channel ORA_DISK_1: restoring datafile 00015 to /data/oracle/RLLIVE/indx_audt05.dbf
channel ORA_DISK_1: restoring datafile 00016 to /data/oracle/RLLIVE/indx_audt06.dbf
channel ORA_DISK_1: restoring datafile 00017 to /data/oracle/RLLIVE/indx_audt07.dbf
channel ORA_DISK_1: restoring datafile 00018 to /data/oracle/RLLIVE/data_hi01.dbf
channel ORA_DISK_1: restoring datafile 00019 to /data/oracle/RLLIVE/data_hi02.dbf
channel ORA_DISK_1: restoring datafile 00020 to /data/oracle/RLLIVE/indx_med01.dbf
channel ORA_DISK_1: restoring datafile 00021 to /data/oracle/RLLIVE/work01.dbf
channel ORA_DISK_1: restoring datafile 00022 to /data/oracle/RLLIVE/patrol.dbf
channel ORA_DISK_1: restoring datafile 00023 to /data/oracle/RLLIVE/rllive_rept01.dbf
channel ORA_DISK_1: restoring datafile 00024 to /data/oracle/RLLIVE/indx_lo01.dbf
channel ORA_DISK_1: restoring datafile 00025 to /data/oracle/RLLIVE/indx_work01.dbf
channel ORA_DISK_1: restoring datafile 00026 to /data/oracle/RLLIVE/data_med01.dbf
channel ORA_DISK_1: restoring datafile 00027 to /data/oracle/RLLIVE/health01.dbf
channel ORA_DISK_1: restoring datafile 00028 to /data/oracle/RLLIVE/data_lo01.dbf
channel ORA_DISK_1: restoring datafile 00029 to /data/oracle/RLLIVE/audt01.dbf
channel ORA_DISK_1: restoring datafile 00030 to /data/oracle/RLLIVE/audt02.dbf
channel ORA_DISK_1: restoring datafile 00031 to /data/oracle/RLLIVE/audt03.dbf
channel ORA_DISK_1: restoring datafile 00032 to /data/oracle/RLLIVE/audt04.dbf
channel ORA_DISK_1: restoring datafile 00033 to /data/oracle/RLLIVE/cognos01.dbf
channel ORA_DISK_1: restoring datafile 00034 to /data/oracle/RLLIVE/vvm_repo01.dbf
channel ORA_DISK_1: restoring datafile 00035 to /blob/oracle/RLLIVE/sysaux02.dbf
channel ORA_DISK_1: restoring datafile 00036 to /data/oracle/RLLIVE/undotbs02.dbf
channel ORA_DISK_1: restoring datafile 00037 to /blob/oracle/RLLIVE/undotbs03.dbf
channel ORA_DISK_1: restoring datafile 00038 to /blob/oracle/RLLIVE/undotbs04.dbf
channel ORA_DISK_1: restoring datafile 00039 to /data/oracle/RLLIVE/users05.dbf
channel ORA_DISK_1: restoring datafile 00040 to /data/oracle/RLLIVE/audt05.dbf
channel ORA_DISK_1: restoring datafile 00041 to /data/oracle/RLLIVE/audt06.dbf
channel ORA_DISK_1: reading from backup piece /backup/oracle/RLLIVE/rman/ora_df884028686_s1 
channel ORA_DISK_1: piece handle=/backup/oracle/RLLIVE/rman/ora_df884028686_s16133_s1_1.bak tag=TAG20150702T193125
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 03:59:36
Finished restore at 04-JUL-15
 
SHUT DOWN THE DATABASE
SQL>shu immediate;
 
ON STANDBY SERVER DROP STANDBY REDO LOGS.

SQL> alter database drop standby logfile '/redo/oracle/RLLIVE/redo11.log';
Database altered.
SQL> alter database drop standby logfile '/redo/oracle/RLLIVE/redo12.log';
Database altered.
SQL> alter database drop standby logfile '/redo/oracle/RLLIVE/redo13.log';
Database altered.
SQL> alter database drop standby logfile '/redo/oracle/RLLIVE/redo14.log';
Database altered.
SQL> alter database drop standby logfile '/redo/oracle/RLLIVE/redo15.log';
Database altered.
SQL> alter database drop standby logfile '/redo/oracle/RLLIVE/redo16.log';
Database altered.
SQL> alter database drop standby logfile '/redo/oracle/RLLIVE/redo17.log';
Database altered.

START DATABASE IN MOUNT MODE
SQL>STARTUP MOUNT;
 
RECREATE THE STANDBY REDO LOG
alter database add standby logfile '/redo/oracle/RLLIVE/redo11.log' size 100m;
alter database add standby logfile '/redo/oracle/RLLIVE/redo12.log' size 100m;
alter database add standby logfile '/redo/oracle/RLLIVE/redo13.log' size 100m;
alter database add standby logfile '/redo/oracle/RLLIVE/redo14.log' size 100m;
alter database add standby logfile '/redo/oracle/RLLIVE/redo15.log' size 100m;
alter database add standby logfile '/redo/oracle/RLLIVE/redo16.log' size 100m;
alter database add standby logfile '/redo/oracle/RLLIVE/redo17.log' size 100m;

OPEN DATABASE IN MANAGED RECOVERY MODE
alter database recover managed standby database disconnect from session;
 
MONITOR SHIPPING AND LOG APPLY STATUS
SQL> select sequence#,process,status from v$managed_standby;

 SEQUENCE# PROCESS   STATUS
---------- --------- ------------
         0 ARCH      CONNECTED
         0 ARCH      CONNECTED
         0 ARCH      CONNECTED
         0 ARCH      CONNECTED
    382754 RFS       RECEIVING
    382753 RFS       RECEIVING
    382752 RFS       RECEIVING
    384869 RFS       IDLE
    382751 MRP0      APPLYING_LOG
 
 
-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Add Data file

 ************************************************** Database status Tablespace Usage ASM Disk Group Usage(RAC) Backup Filesystem Usage Alert...