|
|
本帖最后由 hadba 于 2018-12-30 17:35 编辑
SHCIPSP- Recovering Standby via RMAN INCREMENTAL Backup
set linesize 150
set pagesize 1000
column sid format 999,999
column machine format a23
column osuser format a12
column username format a12
column logon_time format a20
select sid,serial#, type, status, machine,username, osuser,
to_char(LOGON_TIME, 'DD-MON-YYYY hh24:mi:ss') as LOGON_TIME
from gv$session
where type not in ('BACKGROUND')
and username not in ('SYS','DBSNMP')
order by logon_time;
SID SERIAL# TYPE STATUS MACHINE USERNAME OSUSER LOGON_TIME
-------- ---------- ---------- -------- ----------------------- ------------ ------------ --------------------
104 32672 USER INACTIVE shainorab1a.cn.db.com PUBLIC oracle 30-DEC-2018 13:52:22
OWNER SCHEMA_SIZE_M
-------------------- -------------
CIPS_OWNER 20176
[On Primary Host]$ cd /u01/app/oracle/backup/SHCIPSP/CHG0001066230
$ vi imp_data_only_CIPS_OWNER.par
DIRECTORY=CHG0001106403
DUMPFILE=SHCIPS_fullexp_PRD_20181218.dmp
LOGFILE=imp_data_only_CIPS_OWNER.log
CONTENT=DATA_ONLY
TABLE_EXISTS_ACTION=APPEND
PARALLEL=10
CLUSTER=NO
LOGTIME=ALL
METRICS=YES
JOB_NAME=imp_schema_CIPS_OWNER
SCHEMAS=CIPS_OWNER
$ nohup impdp "'/ as sysdba'" parfile=imp_data_only_CIPS_OWNER.par > import.log &
$ impdp "'/ as sysdba'" attach=imp_schema_CIPS_OWNER
Import> status
**************************************************************************************************************************
Delete All Archived Redo Logs in FRA
**************************************************************************************************************************
NAME SPACE_LIMIT_GB SPACE_USED_MB SPACE_RECLAIMABLE_MB NUMBER_OF_FILES FRA_USED_PCT
--------------- -------------- ------------- -------------------- --------------- ------------
+RECO01 200 22807 17 505 11
NAME SPACE_LIMIT_GB SPACE_USED_MB SPACE_RECLAIMABLE_MB NUMBER_OF_FILES FRA_USED_PCT
--------------- -------------- ------------- -------------------- --------------- ------------
+RECO01 200 0 0 0 0
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 0 0 0
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
AUXILIARY DATAFILE COPY 0 0 0
8 rows selected.
**************************************************************************************************************************
Trying to start Redo Transport on Primary
**************************************************************************************************************************
$ dgmgrl /
DGMGRL> show configuration;
DGMGRL> show database shcipsp;
DGMGRL> show database shcipsp_sb;
DGMGRL> EDIT DATABASE shcipsp SET STATE='TRANSPORT-ON';
DGMGRL> show configuration;
DGMGRL> show database shcipsp;
DGMGRL> show database shcipsp_sb;
For example:
[SHCIPSP1]oracle@shainorap1a.cn.db.com $ dgmgrl /
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.
DGMGRL> show configuration;
Configuration - shcipsp_dataguard
Protection Mode: MaxPerformance
Members:
shcipsp - Primary database
shcipsp_sb - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 25 seconds ago)
DGMGRL> EDIT DATABASE shcipsp SET STATE='TRANSPORT-ON';
Succeeded.
DGMGRL> show configuration;
Configuration - shcipsp_dataguard
Protection Mode: MaxPerformance
Members:
shcipsp - Primary database
shcipsp_sb - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 49 seconds ago)
DGMGRL> show database shcipsp;
Database - shcipsp
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
SHCIPSP1
SHCIPSP2
Database Error(s):
ORA-16783: cannot resolve gap for database shcipsp_sb
Database Status:
ERROR
DGMGRL> show database shcipsp_sb;
Database - shcipsp_sb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 15 minutes 53 seconds (computed 1 second ago)
Apply Lag: 15 minutes 53 seconds (computed 1 second ago)
Average Apply Rate: 8.00 KByte/s
Real Time Query: OFF
Instance(s):
SHCIPSP1 (apply instance)
SHCIPSP2
Database Status:
SUCCESS
PID PROCESS STATUS CLIENT_P CLIENT_PID THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS
------------ --------- ------------ -------- ------------ ---------- ---------- ---------- ---------- ----------
24866 ARCH CLOSING ARCH 24866 2 1465 1 629 0
24874 ARCH CONNECTED ARCH 24874 0 0 0 0 0
24889 ARCH CLOSING ARCH 24889 1 1527 638976 69 0
24893 ARCH CLOSING ARCH 24893 2 1451 8192 38 0
27494 RFS IDLE ARCH 33062 0 0 0 0 0
27294 RFS IDLE LGWR 32742 1 1528 1350 1 0
27355 RFS IDLE UNKNOWN 33052 0 0 0 0 0
28871 MRP0 WAIT_FOR_GAP N/A N/A 1 1485 0 0 0
27392 RFS IDLE UNKNOWN 12211 0 0 0 0 0
27504 ARCH CLOSING ARCH 27504 2 1449 1 950 0
27508 ARCH CONNECTED ARCH 27508 0 0 0 0 0
27512 ARCH CLOSING ARCH 27512 2 1450 1 733 0
27516 ARCH CLOSING ARCH 27516 2 1448 1 950 0
34500 RFS IDLE ARCH 12201 0 0 0 0 0
34447 RFS IDLE LGWR 11956 2 1466 84 1 0
15 rows selected.
SQL> set linesize 180
column name for a15
column value for a15
column unit for a30
column time_computed format a20
SELECT NAME, VALUE, UNIT, TIME_COMPUTED
FROM V$DATAGUARD_STATS
WHERE NAME IN ('transport lag', 'apply lag');
AME VALUE UNIT TIME_COMPUTED
--------------- --------------- ------------------------------ --------------------
transport lag +00 00:18:52 day(2) to second(0) interval 12/30/2018 14:26:26
apply lag +00 00:18:52 day(2) to second(0) interval 12/30/2018 14:26:26
ERROR_CODE SEVERITY MESSAGE TIMESTAMP
---------- ------------- --------------------------------------------------------------------------- ---------------------------
0 Control ARC3: Completed archiving thread 1 sequence 1528 (4102257-4102930) 30-DEC-18 14:27:17
0 Control LGWR: Beginning to archive log 2 thread 1 sequence 1529 30-DEC-18 14:27:17
0 Control LGWR: Completed archiving log 1 thread 1 sequence 1528 30-DEC-18 14:27:17
0 Control ARC3: Beginning to archive thread 1 sequence 1528 (4102257-4102930) 30-DEC-18 14:27:17
0 Control ARCH: Completed archiving thread 1 sequence 1527 (4090642-4102257) 30-DEC-18 14:22:58
0 Control ARCH: Beginning to archive thread 1 sequence 1527 (4090642-4102257) 30-DEC-18 14:22:58
0 Control LGWR: Beginning to archive log 1 thread 1 sequence 1528 30-DEC-18 14:22:58
0 Control ARC3: Completed archiving thread 1 sequence 1526 (4089365-4090642) 30-DEC-18 14:17:24
0 Control ARC3: Beginning to archive thread 1 sequence 1526 (4089365-4090642) 30-DEC-18 14:17:24
0 Control ARC1: Beginning to archive thread 1 sequence 1525 (4088724-4089365) 30-DEC-18 14:17:09
0 Control ARC1: Completed archiving thread 1 sequence 1525 (4088724-4089365) 30-DEC-18 14:17:09
0 Control ARC0: Completed archiving thread 1 sequence 1524 (4087300-4088724) 30-DEC-18 14:16:55
**************************************************************************************************************************
ORA-16724: cannot resolve gap for one or more standby databases
**************************************************************************************************************************
[SHCIPSP1]oracle@shainorap1a.cn.db.com $ dgmgrl /
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.
DGMGRL> show configuration;
Configuration - shcipsp_dataguard
Protection Mode: MaxPerformance
Members:
shcipsp - Primary database
Error: ORA-16724: cannot resolve gap for one or more standby databases
shcipsp_sb - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 19 seconds ago)
DGMGRL> show database shcipsp;
Database - shcipsp
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
SHCIPSP1
SHCIPSP2
Database Error(s):
ORA-16783: cannot resolve gap for database shcipsp_sb
Database Status:
ERROR
DGMGRL> show database shcipsp_sb;
Database - shcipsp_sb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 21 minutes 24 seconds (computed 0 seconds ago)
Apply Lag: 21 minutes 24 seconds (computed 0 seconds ago)
Average Apply Rate: 8.00 KByte/s
Real Time Query: OFF
Instance(s):
SHCIPSP1 (apply instance)
SHCIPSP2
Database Status:
SUCCESS
Sun Dec 30 14:23:10 2018
Archived Log entry 450 added for thread 1 sequence 1527 ID 0xf1127982 dest 1:
Sun Dec 30 14:23:10 2018
Fetching gap sequence in thread 1, gap sequence 1485-1526
Sun Dec 30 14:25:18 2018
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 1485-1526
DBID 4044546690 branch 994961411
FAL[client]: All defined FAL servers have been attempted.
------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that's sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
------------------------------------------------------------
RFS[5]: Selected log 31 for thread 1 sequence 1529 dbid 4044546690 branch 994961411
Sun Dec 30 14:27:17 2018
Archived Log entry 451 added for thread 1 sequence 1528 ID 0xf1127982 dest 1:
**************************************************************************************************************
Recovering RAC Standby using an RMAN Incremental Backup
**************************************************************************************************************
[SHCIPSP1]oracle@shainorap1a.cn.db.com $ dgmgrl /
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.
DGMGRL> show configuration;
Configuration - shcipsp_dataguard
Protection Mode: MaxPerformance
Members:
shcipsp - Primary database
Error: ORA-16724: cannot resolve gap for one or more standby databases
shcipsp_sb - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 51 seconds ago)
DGMGRL> show database shcipsp;
Database - shcipsp
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
SHCIPSP1
SHCIPSP2
Database Error(s):
ORA-16783: cannot resolve gap for database shcipsp_sb
Database Status:
ERROR
DGMGRL> show database shcipsp_sb;
Database - shcipsp_sb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 23 minutes 54 seconds (computed 1 second ago)
Apply Lag: 23 minutes 54 seconds (computed 1 second ago)
Average Apply Rate: 8.00 KByte/s
Real Time Query: OFF
Instance(s):
SHCIPSP1 (apply instance)
SHCIPSP2
Database Status:
SUCCESS
***********************************************************************
Step 2: Stop Redo Transport and Redo Apply
***********************************************************************
On the primary cluster, using the DGMGRL CLI, disable the standby apply process.
$ dgmgrl /
DGMGRL> show configuration;
DGMGRL> show database shcipsp;
DGMGRL> show database shcipsp_sb;
DGMGRL> EDIT DATABASE shcipsp_sb SET STATE='APPLY-OFF';
DGMGRL> EDIT DATABASE shcipsp SET STATE='TRANSPORT-OFF';
DGMGRL> show database shcipsp;
DGMGRL> show database shcipsp_sb;
For example:
[SHCIPSP1]oracle@shainorap1a.cn.db.com $ dgmgrl /
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.
DGMGRL> show configuration;
Configuration - shcipsp_dataguard
Protection Mode: MaxPerformance
Members:
shcipsp - Primary database
Error: ORA-16724: cannot resolve gap for one or more standby databases
shcipsp_sb - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 32 seconds ago)
DGMGRL> show database shcipsp;
Database - shcipsp
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
SHCIPSP1
SHCIPSP2
Database Error(s):
ORA-16783: cannot resolve gap for database shcipsp_sb
Database Status:
ERROR
DGMGRL> show database shcipsp_sb;
Database - shcipsp_sb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 25 minutes 40 seconds (computed 1 second ago)
Apply Lag: 25 minutes 40 seconds (computed 1 second ago)
Average Apply Rate: 8.00 KByte/s
Real Time Query: OFF
Instance(s):
SHCIPSP1 (apply instance)
SHCIPSP2
Database Status:
SUCCESS
DGMGRL> EDIT DATABASE shcipsp_sb SET STATE='APPLY-OFF';
Succeeded.
DGMGRL> EDIT DATABASE shcipsp SET STATE='TRANSPORT-OFF';
Succeeded.
DGMGRL> show database shcipsp;
Database - shcipsp
Role: PRIMARY
Intended State: TRANSPORT-OFF
Instance(s):
SHCIPSP1
SHCIPSP2
Database Error(s):
ORA-16783: cannot resolve gap for database shcipsp_sb
Database Status:
ERROR
DGMGRL> show database shcipsp_sb;
Database - shcipsp_sb
Role: PHYSICAL STANDBY
Intended State: APPLY-OFF
Transport Lag: 26 minutes 14 seconds (computed 0 seconds ago)
Apply Lag: 26 minutes 13 seconds (computed 0 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
SHCIPSP1 (apply instance)
SHCIPSP2
Database Status:
SUCCESS
Step 4: Note the Standby SCN
CURRENT_SCN
-----------
4052479
*******************************************************************************************
Step 5: Take Incremental RMAN Backup and controlfile for standby
*******************************************************************************************
On the primary cluster, while connected to a recovery catalog, take an incremental backup using the
SCN from step Step 4:
$ mkdir -p /u01/app/oracle/backup/SHCIPSP/4standby
$ cd /u01/app/oracle/backup/SHCIPSP/4standby
$ vi rman_inc_backup_4standby.ksh
#!/bin/ksh
$ORACLE_HOME/bin/rman << EOF
connect target
sql 'alter system switch logfile';
sql 'alter system switch logfile';
run{
change archivelog all crosscheck;
allocate channel d1 type disk;
allocate channel d2 type disk;
BACKUP INCREMENTAL FROM SCN 4052479 as compressed backupset DATABASE
FORMAT '/u01/app/oracle/backup/SHCIPSP/4standby/4standby_%d_inc_%U.rmn' TAG 'FOR STANDBY';
copy current controlfile for standby to '/u01/app/oracle/backup/SHCIPSP/4standby/4standby_%d_inc_ctl.ctl';
}
exit
EOF
$ chmod 755 rman_inc_backup_4standby.ksh
$ nohup /u01/app/oracle/backup/SHCIPSP/4standby/rman_inc_backup_4standby.ksh > rman_inc_backup.log &
SID SERIAL# SOFAR TOTALWORK OPNAME % Complete
------- ---------- -------------- --------------- ----------------------------------- ----------
93 9,253 0 10,455,431 RMAN: aggregate input 0
SID SERIAL# SPID CLIENT_INFO
------- ------- ------------------------ -------------------------
57 45889 13108 rman channel=d2
61 17878 13050 rman channel=d1
SID SERIAL# SOFAR TOTALWORK OPNAME % Complete
------- -------------- -------------- --------------- ----------------------------------- ----------
57 45,889 440,440 5,079,040 RMAN: incremental datafile backup 8.67
61 17,878 1,407,729 5,373,952 RMAN: incremental datafile backup 26.2
*******************************************************************************************
Step 6: Copy Backup files and Control file to Standby - DR host
*******************************************************************************************
[On DR Host] $ mkdir -p /u01/app/oracle/backup/SHCIPSP_SB/4standby
[On PRD Host] $ cd /u01/app/oracle/backup/SHCIPSP/4standby/ && ls -lrt
$ du -max ./* | sort -nr | head -10
$ scp 4standby_SHCIPSP_inc* \
[url=mailto racle@shainorab1a.cn.db.com:/u01/app/oracle/backup/SHCIPSP_SB/4standby/]oracle@shainorab1a.cn.db.com:/u01/app/oracle/backup/SHCIPSP_SB/4standby/[/url]
[SHCIPSP1]oracle@shainorap1a.cn.db.com $ du -max ./* | sort -nr | head -10
1157 ./4standby_SHCIPSP_inc_0ctm2va2_1_1.rmn
1043 ./4standby_SHCIPSP_inc_0btm2va2_1_1.rmn
35 ./4standby_SHCIPSP_inc_ctl.ctl
2 ./4standby_SHCIPSP_inc_0dtm2vre_1_1.rmn
1 ./rman_inc_com_backup_4standby.ksh
1 ./rman_inc_backup_4standby.ksh
1 ./rman_inc_backup.log
1 ./rman_full_backup_4standby.log
1 ./rman_full_backup_4standby.ksh
1 ./rman_backup_4standby.log
RMAN> restore controlfile from '/u01/app/oracle/backup/SHCIPSP_SB/4standby/4standby_SHCIPSP_inc_ctl.ctl';
Starting restore at 30-DEC-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 instance=SHCIPSP1 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=+REDOLOG01/SHCIPSP_SB/CONTROLFILE/current.634.996052357
output file name=+REDOLOG02/SHCIPSP_SB/CONTROLFILE/current.634.996052359
Finished restore at 30-DEC-18
$ sqlplus / as sysdba;
SQL> alter system set control_files='+REDOLOG01/SHCIPSP_SB/CONTROLFILE/current.634.996052357',
'+REDOLOG02/SHCIPSP_SB/CONTROLFILE/current.634.996052359' scope=spfile sid='*';
SQL> shutdown immediate;
RMAN> CATALOG START WITH '+REG_DATA01/SHCIPSP_SB/DATAFILE/' noprompt;
searching for all files that match the pattern +REG_DATA01/SHCIPSP_SB/DATAFILE/
List of Files Unknown to the Database
=====================================
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.534.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.532.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/undo.533.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_indx01.536.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/undotbs2.540.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/system.539.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/users.541.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/sysaux.535.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/tools.538.996052611
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/audits.537.996052611
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.534.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.532.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/undo.533.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_indx01.536.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/undotbs2.540.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/system.539.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/users.541.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/sysaux.535.996052609
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/tools.538.996052611
File Name: +REG_DATA01/SHCIPSP_SB/DATAFILE/audits.537.996052611
RMAN> SWITCH DATABASE TO COPY;
datafile 1 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/system.539.996052609"
datafile 2 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/sysaux.535.996052609"
datafile 3 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/undo.533.996052609"
datafile 4 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/tools.538.996052611"
datafile 5 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/users.541.996052609"
datafile 6 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/audits.537.996052611"
datafile 7 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/undotbs2.540.996052609"
datafile 8 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.532.996052609"
datafile 9 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.534.996052609"
datafile 10 switched to datafile copy "+REG_DATA01/SHCIPSP_SB/DATAFILE/cips_indx01.536.996052609"
RMAN> REPORT SCHEMA;
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name SHCIPSP_SB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 2048 SYSTEM *** +REG_DATA01/SHCIPSP_SB/DATAFILE/system.539.996052609
2 2048 SYSAUX *** +REG_DATA01/SHCIPSP_SB/DATAFILE/sysaux.535.996052609
3 4096 UNDO *** +REG_DATA01/SHCIPSP_SB/DATAFILE/undo.533.996052609
4 256 TOOLS *** +REG_DATA01/SHCIPSP_SB/DATAFILE/tools.538.996052611
5 512 USERS *** +REG_DATA01/SHCIPSP_SB/DATAFILE/users.541.996052609
6 2048 AUDITS *** +REG_DATA01/SHCIPSP_SB/DATAFILE/audits.537.996052611
7 4096 UNDOTBS2 *** +REG_DATA01/SHCIPSP_SB/DATAFILE/undotbs2.540.996052609
8 30720 CIPS_DATA01 *** +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.532.996052609
9 30720 CIPS_DATA01 *** +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.534.996052609
10 5120 CIPS_INDX01 *** +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_indx01.536.996052609
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 512 TEMP 32767 +REG_DATA01/SHCIPSP/TEMPFILE/temp.481.994961417
SID SERIAL# SPID CLIENT_INFO
------- ------- ------------------------ -------------------------
35 15764 22237 rman channel=ch2
39 43971 22233 rman channel=ch1
SID SERIAL# SOFAR TOTALWORK OPNAME % Complete
------- -------------- -------------- --------------- ----------------------------------- ----------
35 15,764 1,616,913 5,079,040 RMAN: incremental datafile restore 31.84
39 43,971 1,999,554 5,373,952 RMAN: incremental datafile restore 37.21
[SHCIPSP1]oracle@shainorab1a.cn.db.com $ cat rman_recover_noredo.log
Recovery Manager: Release 12.1.0.2.0 - Production on Sun Dec 30 16:50:05 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: SHCIPSP (DBID=4044546690, not open)
RMAN> 2> 3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=39 instance=SHCIPSP1 device type=DISK
allocated channel: ch2
channel ch2: SID=35 instance=SHCIPSP1 device type=DISK
Starting recover at 30-DEC-18
channel ch1: starting incremental datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: +REG_DATA01/SHCIPSP_SB/DATAFILE/system.539.996052609
destination for restore of datafile 00002: +REG_DATA01/SHCIPSP_SB/DATAFILE/sysaux.535.996052609
destination for restore of datafile 00006: +REG_DATA01/SHCIPSP_SB/DATAFILE/audits.537.996052611
destination for restore of datafile 00008: +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.532.996052609
destination for restore of datafile 00010: +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_indx01.536.996052609
channel ch1: reading from backup piece /u01/app/oracle/backup/SHCIPSP_SB/4standby/4standby_SHCIPSP_inc_0btm2va2_1_1.rmn
channel ch2: starting incremental datafile backup set restore
channel ch2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: +REG_DATA01/SHCIPSP_SB/DATAFILE/undo.533.996052609
destination for restore of datafile 00004: +REG_DATA01/SHCIPSP_SB/DATAFILE/tools.538.996052611
destination for restore of datafile 00005: +REG_DATA01/SHCIPSP_SB/DATAFILE/users.541.996052609
destination for restore of datafile 00007: +REG_DATA01/SHCIPSP_SB/DATAFILE/undotbs2.540.996052609
destination for restore of datafile 00009: +REG_DATA01/SHCIPSP_SB/DATAFILE/cips_data01.534.996052609
channel ch2: reading from backup piece /u01/app/oracle/backup/SHCIPSP_SB/4standby/4standby_SHCIPSP_inc_0ctm2va2_1_1.rmn
channel ch1: piece handle=/u01/app/oracle/backup/SHCIPSP_SB/4standby/4standby_SHCIPSP_inc_0btm2va2_1_1.rmn tag=FOR STANDBY
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 00:06:35
channel ch2: piece handle=/u01/app/oracle/backup/SHCIPSP_SB/4standby/4standby_SHCIPSP_inc_0ctm2va2_1_1.rmn tag=FOR STANDBY
channel ch2: restored backup piece 1
channel ch2: restore complete, elapsed time: 00:06:55
Finished recover at 30-DEC-18
released channel: ch1
released channel: ch2
RMAN>
Recovery Manager complete.
SQL> set linesize 150
set pagesize 1000
column status format a10
column log_member format a60
SELECT A.GROUP#, B.THREAD#, B.STATUS, A.TYPE, A.MEMBER AS LOG_MEMBER,
B.BYTES/1024/1024 AS LOGSIZE_MB
FROM V$LOGFILE A, V$LOG B
WHERE A.GROUP# = B.GROUP#
ORDER BY A.GROUP#;
GROUP# THREAD# STATUS TYPE LOG_MEMBER LOGSIZE_MB
---------- ---------- ---------- ------- ------------------------------------------------------------ ----------
1 1 INACTIVE ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_1.377.994961411 512
1 1 INACTIVE ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_1.377.994961413 512
2 1 INACTIVE ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_2.378.994961413 512
2 1 INACTIVE ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_2.378.994961413 512
3 2 INACTIVE ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_3.379.994961465 512
3 2 INACTIVE ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_3.379.994961465 512
4 2 INACTIVE ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_4.380.994961467 512
4 2 INACTIVE ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_4.380.994961467 512
5 1 INACTIVE ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_5.381.994963021 512
5 1 INACTIVE ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_5.381.994963021 512
6 1 CURRENT ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_6.382.994963027 512
6 1 CURRENT ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_6.382.994963029 512
7 1 INACTIVE ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_7.383.994963033 512
7 1 INACTIVE ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_7.383.994963035 512
8 2 INACTIVE ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_8.384.994963041 512
8 2 INACTIVE ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_8.384.994963043 512
9 2 INACTIVE ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_9.385.994963053 512
9 2 INACTIVE ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_9.385.994963053 512
10 2 CURRENT ONLINE +REDOLOG01/SHCIPSP/ONLINELOG/group_10.386.994963063 512
10 2 CURRENT ONLINE +REDOLOG02/SHCIPSP/ONLINELOG/group_10.386.994963065 512
20 rows selected.
************************************************************************************
Step 11: Start the redo apply on the Standby database
************************************************************************************
SQL> set lines 132
set pagesize 9999
column pid format a10
col client_pid format a12
SELECT PID, PROCESS, STATUS, CLIENT_PROCESS, CLIENT_PID,
THREAD#, SEQUENCE#, BLOCK#,BLOCKS, DELAY_MINS
FROM GV$MANAGED_STANDBY;
PID PROCESS STATUS CLIENT_P CLIENT_PID THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS
---------- --------- ------------ -------- ------------ ---------- ---------- ---------- ---------- ----------
14282 ARCH CONNECTED ARCH 14282 0 0 0 0 0
14286 ARCH CONNECTED ARCH 14286 0 0 0 0 0
14290 ARCH CONNECTED ARCH 14290 0 0 0 0 0
14294 ARCH CONNECTED ARCH 14294 0 0 0 0 0
45929 MRP0 WAIT_FOR_LOG N/A N/A 1 1531 0 0 0
SQL> set lines 132
set pagesize 9999
column pid format a10
col client_pid format a12
SELECT PID, PROCESS, STATUS, CLIENT_PROCESS, CLIENT_PID,
THREAD#, SEQUENCE#, BLOCK#,BLOCKS, DELAY_MINS
FROM GV$MANAGED_STANDBY;
PID PROCESS STATUS CLIENT_P CLIENT_PID THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS
---------- --------- ------------ -------- ------------ ---------- ---------- ---------- ---------- ----------
14282 ARCH CONNECTED ARCH 14282 0 0 0 0 0
14286 ARCH CONNECTED ARCH 14286 0 0 0 0 0
14290 ARCH CLOSING ARCH 14290 2 1477 1 59 0
14294 ARCH CLOSING ARCH 14294 1 1540 6144 1750 0
45929 MRP0 APPLYING_LOG N/A N/A 2 1478 18 1048576 0
1058 RFS IDLE ARCH 33062 0 0 0 0 0
1063 RFS IDLE UNKNOWN 12197 0 0 0 0 0
1071 RFS IDLE UNKNOWN 33052 0 0 0 0 0
895 RFS IDLE UNKNOWN 33070 0 0 0 0 0
1077 RFS IDLE UNKNOWN 12201 0 0 0 0 0
1133 RFS IDLE UNKNOWN 12211 0 0 0 0 0
948 RFS IDLE LGWR 32742 1 1541 19 1 0
978 RFS IDLE LGWR 11956 2 1478 18 1 0
13 rows selected.
set linesize 180
column name format a15
column value format a15
column unit format a30
column time_computed format a20
SELECT NAME, VALUE, UNIT, TIME_COMPUTED
FROM V$DATAGUARD_STATS
WHERE NAME IN ('transport lag', 'apply lag');
NAME VALUE UNIT TIME_COMPUTED
--------------- --------------- ------------------------------ --------------------
transport lag +00 00:00:00 day(2) to second(0) interval 12/30/2018 17:10:43
apply lag +00 00:00:00 day(2) to second(0) interval 12/30/2018 17:10:43
*****************************************************************************************************************************
Step 13: Run a switch logfile from primary database
ERROR_CODE SEVERITY MESSAGE TIMESTAMP
---------- ------------- --------------------------------------------------------------------------- ---------------------------
0 Control LGWR: Completed archiving log 6 thread 1 sequence 1541 30-DEC-18 17:11:35
0 Control ARC3: Beginning to archive thread 1 sequence 1541 (4132642-4133048) 30-DEC-18 17:11:35
0 Control LGWR: Beginning to archive log 7 thread 1 sequence 1542 30-DEC-18 17:11:35
0 Control ARC3: Completed archiving thread 1 sequence 1541 (4132642-4133048) 30-DEC-18 17:11:35
0 Control ARC3: Completed archiving thread 1 sequence 1540 (4129442-4132642) 30-DEC-18 17:08:59
0 Control ARC3: Beginning to archive thread 1 sequence 1540 (4129442-4132642) 30-DEC-18 17:08:59
0 Control LGWR: Beginning to archive log 6 thread 1 sequence 1541 30-DEC-18 17:08:58
0 Control ARC1: Beginning to archive thread 1 sequence 1539 (4127183-4129442) 30-DEC-18 16:55:03
0 Control ARC1: Completed archiving thread 1 sequence 1539 (4127183-4129442) 30-DEC-18 16:55:03
0 Control ARC0: Beginning to archive thread 1 sequence 1538 (4124345-4127183) 30-DEC-18 16:40:02
0 Control ARC0: Completed archiving thread 1 sequence 1538 (4124345-4127183) 30-DEC-18 16:40:02
SQL> set lines 132
set pagesize 9999
column pid format a10
col client_pid format a12
SELECT PID, PROCESS, STATUS, CLIENT_PROCESS, CLIENT_PID,
THREAD#, SEQUENCE#, BLOCK#,BLOCKS, DELAY_MINS
FROM GV$MANAGED_STANDBY;
PID PROCESS STATUS CLIENT_P CLIENT_PID THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS
---------- --------- ------------ -------- ------------ ---------- ---------- ---------- ---------- ----------
14282 ARCH CONNECTED ARCH 14282 0 0 0 0 0
14286 ARCH CONNECTED ARCH 14286 0 0 0 0 0
14290 ARCH CLOSING ARCH 14290 1 1541 1 163 0
14294 ARCH CLOSING ARCH 14294 1 1540 6144 1750 0
45929 MRP0 APPLYING_LOG N/A N/A 1 1542 76 1048576 0
1058 RFS IDLE ARCH 33062 0 0 0 0 0
1063 RFS IDLE UNKNOWN 12197 0 0 0 0 0
1071 RFS IDLE UNKNOWN 33052 0 0 0 0 0
895 RFS IDLE UNKNOWN 33070 0 0 0 0 0
1077 RFS IDLE UNKNOWN 12201 0 0 0 0 0
1133 RFS IDLE UNKNOWN 12211 0 0 0 0 0
948 RFS IDLE LGWR 32742 1 1542 76 1 0
978 RFS IDLE LGWR 11956 2 1478 246 1 0
13 rows selected.
set linesize 180
column name format a15
column value format a15
column unit format a30
column time_computed format a20
SELECT NAME, VALUE, UNIT, TIME_COMPUTED
FROM V$DATAGUARD_STATS
WHERE NAME IN ('transport lag', 'apply lag');
NAME VALUE UNIT TIME_COMPUTED
--------------- --------------- ------------------------------ --------------------
transport lag +00 00:00:00 day(2) to second(0) interval 12/30/2018 17:13:18
apply lag +00 00:00:00 day(2) to second(0) interval 12/30/2018 17:13:18
INSTANCE_NAME STATUS DATABASE_STATUS INSTANCE_ROLE HOST_NAME LOGINS STARTUP_TIME
-------------------- ---------- ----------------- ------------------ ------------------------- ---------- -------------------
SHCIPSP1 MOUNTED ACTIVE PRIMARY_INSTANCE shainorab1a.cn.db.com ALLOWED 2018_12_30 17:16:10
SHCIPSP2 MOUNTED ACTIVE PRIMARY_INSTANCE shainorab1b.cn.db.com ALLOWED 2018_12_30 17:16:10
|
|
楼主: hadba
IP卡
狗仔卡
楼主
显身卡
发表于 2019-1-25 10:12
