Thursday 14 November 2019

RAC - Restore RAC RMAN Backup linux to Single Instance Window database 12c

#######################################################################

RMAN Backup - 2 node RAC 12.1.0.2.0 version on OEL 6.7 linux operating system.

RMAN  Restore - Single instance on window server.



 HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node (Doc ID 415579.1)
#######################################################################
C:\Users\varunyadav>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 13 17:24:56 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 2298478592 bytes
Fixed Size                  3834584 bytes
Variable Size             905973032 bytes
Database Buffers         1375731712 bytes
Redo Buffers               12939264 bytes
SQL>
SQL>
SQL> alter database mount;

Database altered.

SQL>
####################################################################

C:\Users\varunyadav>rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Nov 13 17:25:50 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: RAC (not mounted)

RMAN> restore controlfile from 'C:\varun_docs\rman_bkp_rac\control01_cf_d-rac_id-2608333762_35ugp2l6.bak';

Starting restore at 13-NOV-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=577 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=C:\APP\VARUNYADAV\ORADATA\RAC\CONTROL01.CTL
output file name=C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\CONTROL02.CTL
Finished restore at 13-NOV-19

RMAN> catalog start with 'C:\varun_docs\rman_bkp_rac';

released channel: ORA_DISK_1
Starting implicit crosscheck backup at 13-NOV-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=577 device type=DISK
Crosschecked 21 objects
Finished implicit crosscheck backup at 13-NOV-19

Starting implicit crosscheck copy at 13-NOV-19
using channel ORA_DISK_1
Finished implicit crosscheck copy at 13-NOV-19

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\ARCHIVELOG\2019_11_13\O1_MF_1_6_GWQH7CGR_.ARC

searching for all files that match the pattern C:\varun_docs\rman_bkp_rac

List of Files Unknown to the Database
=====================================
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2OUGP2DN_88_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2PUGP2DO_89_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2QUGP2E7_90_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2RUGP2EM_91_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2SUGP2F9_92_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_33UGP2L4_99_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_34UGP2L4_100_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\CONTROL01_CF_D-RAC_ID-2608333762_35UGP2L6.BAK
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2TUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2UUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2VUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_30UGP2G0_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_31UGP2H7_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_32UGP2HE_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\STANDBYCONTROL_36UGP2LD_1_1.CTL

Do you really want to catalog the above files (enter YES or NO)?

Do you really want to catalog the above files (enter YES or NO)? YEs
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2OUGP2DN_88_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2PUGP2DO_89_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2QUGP2E7_90_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2RUGP2EM_91_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2SUGP2F9_92_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_33UGP2L4_99_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_34UGP2L4_100_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\CONTROL01_CF_D-RAC_ID-2608333762_35UGP2L6.BAK
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2TUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2UUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2VUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_30UGP2G0_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_31UGP2H7_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_32UGP2HE_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\STANDBYCONTROL_36UGP2LD_1_1.CTL

RMAN> RUN
2> {
3> set newname for datafile 1 to "C:\app\varunyadav\oradata\rac\system01.dbf";
4> set newname for datafile 3 to "C:\app\varunyadav\oradata\rac\sysaux01.dbf";
5> set newname for datafile 4 to "C:\app\varunyadav\oradata\rac\undotbs01.dbf";
6> set newname for datafile 5 to "C:\app\varunyadav\oradata\rac\undotbs02.dbf";
7> set newname for datafile 2 to "C:\app\varunyadav\oradata\rac\idata01.dbf";
8> set newname for datafile 6 to "C:\app\varunyadav\oradata\rac\users01.dbf";
9> set newname for datafile 7 to "C:\app\varunyadav\oradata\rac\ilog01.dbf";
10> set newname for datafile 8 to "C:\app\varunyadav\oradata\rac\indx01.dbf";
11> set newname for tempfile 1 to "C:\app\varunyadav\oradata\rac\temp01.dbf";
12> RESTORE DATABASE;
13> SWITCH DATAFILE ALL;
14> SWITCH TEMPFILE ALL;
15> recover database;
16> }

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 13-NOV-19
using channel ORA_DISK_1

skipping datafile 1; already restored to file C:\app\varunyadav\oradata\rac\system01.dbf
skipping datafile 3; already restored to file C:\app\varunyadav\oradata\rac\sysaux01.dbf
skipping datafile 2; already restored to file C:\app\varunyadav\oradata\rac\idata01.dbf
skipping datafile 4; already restored to file C:\app\varunyadav\oradata\rac\undotbs01.dbf
skipping datafile 5; already restored to file C:\app\varunyadav\oradata\rac\undotbs02.dbf
skipping datafile 7; already restored to file C:\app\varunyadav\oradata\rac\ilog01.dbf
skipping datafile 6; already restored to file C:\app\varunyadav\oradata\rac\users01.dbf
skipping datafile 8; already restored to file C:\app\varunyadav\oradata\rac\indx01.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 13-NOV-19

datafile 1 switched to datafile copy
input datafile copy RECID=12 STAMP=1024248929 file name=C:\app\varunyadav\oradata\rac\system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=13 STAMP=1024248931 file name=C:\app\varunyadav\oradata\rac\idata01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=14 STAMP=1024248932 file name=C:\app\varunyadav\oradata\rac\sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=15 STAMP=1024248933 file name=C:\app\varunyadav\oradata\rac\undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=16 STAMP=1024248934 file name=C:\app\varunyadav\oradata\rac\undotbs02.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=17 STAMP=1024248935 file name=C:\app\varunyadav\oradata\rac\users01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=18 STAMP=1024248937 file name=C:\app\varunyadav\oradata\rac\ilog01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=19 STAMP=1024248939 file name=C:\app\varunyadav\oradata\rac\indx01.dbf

renamed tempfile 1 to C:\app\varunyadav\oradata\rac\temp01.dbf in control file

Starting recover at 13-NOV-19
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=536
channel ORA_DISK_1: reading from backup piece C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_34UGP2L4_100_1_20191113
channel ORA_DISK_1: piece handle=C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_34UGP2L4_100_1_20191113 tag=TAG20191113T125500
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=492
channel ORA_DISK_1: reading from backup piece C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_33UGP2L4_99_1_20191113
channel ORA_DISK_1: piece handle=C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_33UGP2L4_99_1_20191113 tag=TAG20191113T125500
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\ARCHIVELOG\2019_11_13\O1_MF_1_492_GWQWMHM5_.ARC thread=1 sequence=492
archived log file name=C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\ARCHIVELOG\2019_11_13\O1_MF_2_536_GWQWMGF5_.ARC thread=2 sequence=536
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/13/2019 17:50:22
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile 'C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\ARCHIVELOG\2019_11_13\O1_MF_2_536_GWQWMGF5_.ARC'
ORA-10878: parallel recovery slave died unexpectedly

RMAN>

RMAN> SQL "ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_1.275.1020351751''  to  ''C:\app\varunyadav\oradata\rac\redo01.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_1.275.1020351751''  to  ''C:\app\varunyadav\oradata\rac\redo01.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_1.262.1020351753''  to  ''C:\app\varunyadav\oradata\rac\redo02.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_1.262.1020351753''  to  ''C:\app\varunyadav\oradata\rac\redo02.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_2.263.1020351755''  to  ''C:\app\varunyadav\oradata\rac\redo03.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_2.263.1020351755''  to  ''C:\app\varunyadav\oradata\rac\redo03.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_2.276.1020351753''  to  ''C:\app\varunyadav\oradata\rac\redo04.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_2.276.1020351753''  to  ''C:\app\varunyadav\oradata\rac\redo04.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_3.264.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo05.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_3.264.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo05.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_3.280.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo06.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_3.280.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo06.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_4.265.1020352335''  to  ''C:\app\varunyadav\oradata\rac\redo07.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_4.265.1020352335''  to  ''C:\app\varunyadav\oradata\rac\redo07.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_4.281.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo08.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_4.281.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo08.log''

RMAN>
RMAN>

RMAN>

RMAN> alter database open resetlogs;

Statement processed

RMAN>
RMAN> alter database open resetlogs;

Statement processed

RMAN> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
RAC       READ WRITE           PRIMARY

RMAN> select member from v$logfile;



MEMBER
--------------------------------------------------------------------------------

C:\APP\VARUNYADAV\ORADATA\RAC\REDO04.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO03.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO01.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO02.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO06.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO05.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO08.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO07.LOG


8 rows selected

RMAN> select name from v$datafile;



NAME
--------------------------------------------------------------------------------

C:\APP\VARUNYADAV\ORADATA\RAC\SYSTEM01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\IDATA01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\SYSAUX01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\UNDOTBS01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\UNDOTBS02.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\USERS01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\ILOG01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\INDX01.DBF


8 rows selected

RMAN>

C:\Users\varunyadav>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Nov 14 19:23:07 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,open_mode,database_Role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
RAC       READ WRITE           PRIMARY

SQL> select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
         1 OPEN   PUBLIC
         2 CLOSED PUBLIC

SQL> select group# from v$log where THREAD#=2;

    GROUP#
----------
         3
         4

SQL> alter database disable thread 2;

Database altered.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL> select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
         1 OPEN   PUBLIC
         2 CLOSED DISABLED

SQL> sho parameter undo;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled                    boolean     FALSE
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
SQL> select tablespace_name from dba_tablespaces where contents='UNDO';

TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2

SQL> drop tablespace UNDOTBS2 including contents and datafiles;

Tablespace dropped.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
C:\APP\VARUNYADAV\ORADATA\RAC\TEMP01.DBF

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP

SQL> create temporary tablespace TEMP1 tempfile 'C:\APP\VARUNYADAV\ORADATA\RAC\TEMP001.DBF' size 50M;

Tablespace created.

SQL> alter database default temporary tablespace TEMP1;

Database altered.

SQL> drop tablespace TEMP including contents and datafiles;

Tablespace dropped.

SQL>

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP1

SQL>
Posted by at No comments:
Labels: ,

Tuesday 12 November 2019

[INS-41112] Specified network interface doesnt maintain connectivity across cluster nodes.



Cause - Installer has detected that network interface eth0 does not maintain connectivity on all cluster nodes.  Action - Ensure that the chosen interface has been configured across all cluster nodes.  Additional Information:
Summary of the failed nodes srv2  - PRVG-11850 : The system call "connect" failed with error "113" while executing exectask on node "srv2"
No route to host  - Cause:  An attempt to execute exectask on the specified node failed.  - Action:  Examine the accompanying error message for details or contact Oracle Support Services. srv1  - PRVG-11850 : The system call "connect" failed with error "113" while executing exectask on node "srv1"
No route to host  - Cause:  An attempt to execute exectask on the specified node failed.  - Action:  Examine the accompanying error message for details or contact Oracle Support Services.
#####################################################

Solution : This was the real time scenario  found during installation, No MAC address values defined by linux team on /etc/sysconfig/network/ ifcfg-em1 file  value HWADDR=xx:xx:xxx:xx:xx:xx



  • Check MAC address by typing command on terminal : /sbin/ifconfig
  • Add  HWADDR=xx:xx:xxx:xx:xx:xx  value  on /etc/sysconfig/network/ifcfg-em1 file  (on both nodes both NIC card)



oracle@sgdcplm01:/etc/sysconfig/network> cat ifcfg-p8p2

BOOTPROTO='static'
BROADCAST=''
ETHTOOL_OPTIONS=''
IPADDR='xx.xx.xx.xxx/xx'
MTU=''
NAME='Ethernet Controller X710 for 10GbE backplane'
NETWORK=''
REMOTE_IPADDR=''
STARTMODE='auto'
oracle@sgdcplm02:/etc/sysconfig/network> cat ifcfg-em2
BOOTPROTO='static'
BROADCAST=''
ETHTOOL_OPTIONS=''
IPADDR='xx.xxx.x.xxx/xx'
MTU=''
NAME='Ethernet Controller 10G X550T'
NETWORK=''
REMOTE_IPADDR=''
HWADDR=xx:xx:xxx:xx:xx:xx
STARTMODE='auto'


Posted by at No comments:
Labels:

Oracle Database - Log Minor Examples

alter system set utl_file_dir='D:\63_archivelog\log_minor' scope=spfile;
D:\63_archivelog\log_minor
##############################################################################################################

EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora', 'D:\63_archivelog\log_minor', DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);

 SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO01.LOG');

 SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO02.LOG');

 SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO03.LOG');

 SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO04.LOG');
################################################################################################################


EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '/tmp/group_1.259.919359545', OPTIONS => DBMS_LOGMNR.NEW);

EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/tmp/group_2.261.919359549',OPTIONS => DBMS_LOGMNR.ADDFILE);

execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_230_1005460847.arc', OPTIONS => DBMS_LOGMNR.NEW);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_231_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_232_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_233_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_234_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_235_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_236_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_237_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);


EXECUTE DBMS_LOGMNR.START_LOGMNR (DICTFILENAME => 'D:\63_archivelog\log_minor\DICTIONARY1.ORA');

SELECT scn, operation, sql_redo, sql_undo FROM v$logmnr_contents;
Posted by at No comments:
Labels: ,
Subscribe to: Posts (Atom)