[DATAGUARD] failover handoff of physical dg (6) 02/22 Update SLTechnology News&Howtos

[DATAGUARD] failover handoff of physical dg (6)

2025-02-22 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)06/01 Report--

[DATAGUARD] failover handoff of physical dg (6)

1.1 BLOG document structure map

1.2 introduction to part 1.2.1

Technical enthusiasts, after reading this article, you can master the following skills, and you can also learn some other knowledge that you do not know, ~ O (∩ _ ∩) Olympiad:

Failover handover drill process of ① physical dg

Some sql managed and maintained by ② physical dg

③ uses duplicate to build physical dg

four

Note: I use a yellow background and a red font to show the areas that require special attention in the code part of this BLOG. For example, in the following example, the maximum archive log number of thread 1 is 33dint thread 2, and the maximum archive log number is 43.

List of Archived Logs in backup set 11

Thrd Seq Low SCN Low Time Next SCN Next Time

1 32 1621589 2015-05-29 11:09:52 1625242 2015-05-29 11:15:48

1 33 1625242 2015-05-29 11:15:48 1625293 2015-05-29 11:15:58

2 42 1613951 2015-05-29 10:41:18 1625245 2015-05-29 11:15:49

2 43 1625245 2015-05-29 11:15:49 1625253 2015-05-29 11:15:53

If there are any mistakes or imperfections in this article, please correct them as much as you can, ITPUB or QQ. Your criticism is the biggest motivation of my writing.

1.2.2 introduction to the experimental environment

Project

Main library

Dg library

Db Typ

Single instance

Db version

11.2.0.3

Db storage

FS type

ORACLE_SID

Oradg11g

Oradgphy

Db_name

Oradg11g

Host IP address:

192.168.59.130

OS version and kernel version

RHEL6.5 64-bit, 2.6.32-504.16.2.el6.x86_64

OS hostname

Rhel6_lhr

1.2.3 links to related reference articles

[DATAGUARD] build physical backup and logical backup based on the same host (1): http://blog.itpub.net/26736162/viewspace-1448197/

[DATAGUARD] build physical backup and logical backup based on the same host (2): http://blog.itpub.net/26736162/viewspace-1448207/

[DATAGUARD] build physical backup and logical backup based on the same host (3): http://blog.itpub.net/26736162/viewspace-1481972/

[DATAGUARD] build physical backup and logical backup based on the same host (4)-- add a physical dg node: http://blog.itpub.net/26736162/viewspace-1484878/

[DATAGUARD] switchover handoff of physical dg (5): http://blog.itpub.net/26736162/viewspace-1753111/

1.2.4 introduction to this article

Follow up the previous article [DATAGUARD] switchover handover of physical dg (5): http://blog.itpub.net/26736162/viewspace-1753111/, this chapter introduces the handover of failover.

1.3 Literacy of related knowledge points

1. Role

There are two roles in the Oracle database.

User roles: defines a set of permissions that can be assigned to users or to other roles.

Database role: what role the database plays in the repository, primary or standby.

V$database.DATABASE_ROLE identifies the running role of the database.

In a repository environment, there are two types of databases: phsical standby and logical standby.

2. Role management service

A database runs in the following mutually exclusive roles.

Primary role: if a database runs on primary role, log transport services passes the redo log to the standby database.

Standby role: if a database runs on standby role, then the log apply services application archives the logs to the standby database.

Role management service allows users to dynamically switch roles between primary and standby libraries.

Users can use the role management service to switch roles in the planned master and slave libraries, which is called switchover, or unplanned role switching, called failover.

3.Switchover&Failover

Switching is a role reversal between the primary database and its standby database to ensure that data is not lost. This is a typical operation for planned maintenance of the primary system. During the switch, the primary database is converted to the standby role, and the standby database is converted to the primary role. The conversion does not require any database reconstruction.

(1) Switchover

Scenarios used: planned role conversion or maintenance of the user's operating system and hardware, etc.

(2) Failover

Failover is performed when the primary database is not available. Failover is performed only in the case of a disaster failure of the primary database, and the failover causes the standby database to be switched to the primary role. Scenarios used: unplanned role switching, usually used in emergencies. Depending on the protection mode, there may be no or little data loss.

(3) role transformation decision tree

The ultimate goal of role switching (switchover&failover) is to make the main database online as soon as possible, while minimizing data loss or achieving no data loss. Try to choose the strategy with the shortest downtime and the least data loss. In short, before failing to switch, you should consider repairing the primary database or changing roles with numerous data losses.

Even if you use a standby solution with no data loss, it may be faster to repair the primary library than to switch to the standby library. If the main library is fixed, there is no need to modify the client connection. But if the repair results in any data loss, you may need to recreate all the standby databases.

In general, the standby database that is most suitable for switching is the standby database that has applied the most archive logs.

1.4 Experimental Section 1.4.1 Experimental objectives

Failover switching between ① main Library and physical dg

② is restored to its original state

1.4.2 Experimental process

Note: after failover switching, the original main library will not be available and must be rebuilt, so please choose this experiment carefully.

1.4.2.1 simulate unexpected database downtime on the main database side

[oracle@rhel6_lhr oradg11g] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sunday July 26 21:26:20 2015

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

21:26:20 SQL >

21:26:29 SQL > select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database

NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME

ORADG11G ARCHIVELOG READ WRITE PRIMARY TO STANDBY oradg11g

Time spent: 00: 00: 00.01

21:26:37 SQL > alter system switch logfile

The system has changed.

Time spent: 00: 00: 00.01

21:27:31 SQL > create table test as select * from dba_objects

The table has been created.

Time spent: 00: 00: 00.50

21:27:38 SQL > insert into test select * from test

75250 rows were created.

Time spent: 00: 00: 00.51

21:27:56 SQL > insert into test select * from test

150500 rows were created.

Time spent: 00: 00: 02.62

21:28:00 SQL > commit

The submission is complete.

Time spent: 00: 00: 00.00

21:28:06 SQL > insert into test select * from test

301000 rows were created.

Time spent: 00: 00: 12.41

21:28:21 SQL > commit

The submission is complete.

Time spent: 00: 00: 00.00

21:28:27 SQL > insert into test select * from test

602000 rows were created.

Time spent: 00: 00: 22.63

21:29:08 SQL > commit

The submission is complete.

Time spent: 00: 00: 01.29

21:29:12 SQL > shutdown abort

The ORACLE routine has been closed.

21:29:14 SQL >

For database inquiries:

20:45:30 SQL > select count (1) from test

COUNT (1)

1204000

Time spent: 00: 00: 00.05

21:29:42 SQL > select thread#, low_sequence#, high_sequence# from v$archive_gap

No rows selected

Time spent: 00: 00: 00.02

21:31:23 SQL >

If no obvious gap phenomenon is found, it means that there will be no data loss in this failover. On the standby side, close the apply and end the application.

1.4.2.2 Direct switching of standby library

21:31:23 SQL > alter database recover managed standby database cancel

The database has changed.

Time spent: 00: 00: 01.01

21:33:46 SQL > alter database recover managed standby database finish

The database has changed.

Time spent: 00: 00: 00.31

21:33:52 SQL > select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database

NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME

ORADG11G ARCHIVELOG READ ONLY PHYSICAL STANDBY TO PRIMARY oradgphy

Time spent: 00: 00: 00.01

21:34:16 SQL > alter database commit to switchover to primary with session shutdown

The database has changed.

Time spent: 00: 00: 00.07

21:36:16 SQL >

21:36:16 SQL > select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database

NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME

ORADG11G ARCHIVELOG MOUNTED PRIMARY NOT ALLOWED oradgphy

Time spent: 00: 00: 00.01

21:38:18 SQL > alter database open

The database has changed.

Time spent: 00: 00: 00.30

21:38:42 SQL > select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database

NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME

ORADG11G ARCHIVELOG READ WRITE PRIMARY RESOLVABLE GAP oradgphy

Time spent: 00: 00: 00.00

21:38:49 SQL >

The switch was successful. After the switch, we observe the log of the process.

Alert log:

Alter database recover managed standby database cancel

Sun Jul 26 21:33:45 2015

MRP0: Background Media Recovery cancelled with status 16037

Errors in file / u01/app/oracle/diag/rdbms/oradgphy/oradgphy/trace/oradgphy_pr00_45791.trc:

ORA-16037: user requested cancel of managed recovery operation

Managed Standby Recovery not using Real Time Apply

Recovery interrupted!

Recovered data files to a consistent state at change 1874535

Sun Jul 26 21:33:46 2015

MRP0: Background Media Recovery process shutdown (oradgphy)

Managed Standby Recovery Canceled (oradgphy)

Completed: alter database recover managed standby database cancel

Alter database recover managed standby database finish

Attempt to do a Terminal Recovery (oradgphy)

Media Recovery Start: Managed Standby Recovery (oradgphy)

Started logmerger process

Sun Jul 26 21:33:52 2015

Managed Standby Recovery not using Real Time Apply

Parallel Media Recovery started with 2 slaves

Begin: Standby Redo Logfile archival

End: Standby Redo Logfile archival

Terminal Recovery timestamp is' 07Compact 26Compact 2015 21Univ 333mov 52'

Terminal Recovery: applying standby redo logs.

Terminal Recovery: thread 1 seq# 183 redo required

Terminal Recovery:

Recovery of Online Redo Log: Thread 1 Group 4 Seq 183 Reading mem 0

Mem# 0: / u01/app/oracle/oradata/oradgphy/standby_redo04.log

Identified End-Of-Redo (failover) for thread 1 sequence 183 at SCN 0xffff.ffffffff

Incomplete Recovery applied until change 1874536 time 07/26/2015 21:29:12

Media Recovery Complete (oradgphy)

Terminal Recovery: successful completion

Sun Jul 26 21:33:52 2015

ARCH: Archival stopped, error occurred. Will continue retrying

ORACLE Instance oradgphy-Archival Error

ORA-16014: log 4 sequence# 183 not archived, no available destinations

ORA-00312: online log 4 thread 1:'/ u01According to an oradata, an oradata, an oradgphyash, standbysides redo04.log'

Forcing ARSCN to IRSCN for TR 0:1874536

Attempt to set limbo arscn 0:1874536 irscn 0:1874536

Resetting standby activation ID 1413582769 (0x54418fb1)

Completed: alter database recover managed standby database finish

Sun Jul 26 21:36:16 2015

Alter database commit to switchover to primary with session shutdown

ALTER DATABASE SWITCHOVER TO PRIMARY (oradgphy)

Maximum wait for role transition is 15 minutes.

All dispatchers and shared servers shutdown

CLOSE: killing server sessions.

CLOSE: all sessions shutdown successfully.

Sun Jul 26 21:36:16 2015

SMON: disabling cache recovery

Backup controlfile written to trace file / u01/app/oracle/diag/rdbms/oradgphy/oradgphy/trace/oradgphy_ora_45673.trc

Standby terminal recovery start SCN: 1874535

RESETLOGS after incomplete recovery UNTIL CHANGE 1874536

Online log / u01/app/oracle/oradata/oradgphy/redo01.log: Thread 1 Group 1 was previously cleared

Online log / u01/app/oracle/oradata/oradgphy/redo02.log: Thread 1 Group 2 was previously cleared

Online log / u01/app/oracle/oradata/oradgphy/redo03.log: Thread 1 Group 3 was previously cleared

Standby became primary SCN: 1874534

Sun Jul 26 21:36:16 2015

Setting recovery target incarnation to 3

AUDIT_TRAIL initialization parameter is changed back to its original value as specified in the parameter file.

Switchover: Complete-Database mounted as primary

Completed: alter database commit to switchover to primary with session shutdown

Sun Jul 26 21:36:45 2015

Idle dispatcher 'D000' terminated, pid = (17,1)

Sun Jul 26 21:36:54 2015

ARC0: Becoming the'no SRL' ARCH

Sun Jul 26 21:36:55 2015

ARC1: Becoming the'no SRL' ARCH

1.4.2.3 Test after switching

21:38:49 SQL > alter system switch logfile

The system has changed.

Time spent: 00: 00: 00.01

21:40:59 SQL > delete from test where rownum commit

The submission is complete.

Time spent: 00: 00: 00.00

21:42:27 SQL > set line 9999

21:42:49 SQL > col DEST_NAME format A20

21:42:49 SQL > col DESTINATION format A20

21:42:49 SQL > col GAP_STATUS format A10

21:42:49 SQL > col DB_UNIQUE_NAME format A10

21:42:49 SQL > col error format A10

21:42:49 SQL > SELECT al.thread#

21:42:50 2 ads.dest_id

21:42:50 3 ads.DEST_NAME

21:42:50 4 (SELECT ad.TARGET

21:42:50 5 FROM v$archive_dest AD

21:42:50 6 WHERE AD.DEST_ID = ADS.DEST_ID) TARGET

21:42:50 7 ADS.DATABASE_MODE

21:42:50 8 ads.STATUS

21:42:50 9 ads.error

21:42:50 10 ads.TYPE

21:42:50 11 ads.RECOVERY_MODE

21:42:50 12 ads.DB_UNIQUE_NAME

21:42:50 13 ads.DESTINATION

21:42:50 14 ads.GAP_STATUS

21:42:50 15 (SELECT MAX (sequence#) FROM v$log na WHERE na.thread# = al.thread#) "Current Sequence"

21:42:50 16 MAX (sequence#) "Last Archived"

21:42:50 17 MAX (decode (al.APPLIED, 'YES', sequence#)) APPLIED_SEQ#

21:42:50 18 FROM (SELECT *

21:42:50 19 FROM v$archived_log V

21:42:50 20 WHERE V.resetlogs_change# =

21:42:50 21 (SELECT d.RESETLOGS_CHANGE# FROM v$database d)) al

21:42:50 22 v$archive_dest_status ads

21:42:50 23 WHERE al.dest_id (+) = ads.dest_id

21:42:50 24 AND ads.STATUS! = 'INACTIVE'

21:42:50 25 GROUP BY al.thread#

21:42:50 26 ads.dest_id

21:42:50 27 ads.DEST_NAME

21:42:50 28 ads.STATUS

21:42:50 29 ads.error

21:42:50 30 ads.TYPE

21:42:50 31 ADS.DATABASE_MODE

21:42:50 32 ads.RECOVERY_MODE

21:42:50 33 ads.DB_UNIQUE_NAME

21:42:50 34 ads.DESTINATION

21:42:50 35 ads.GAP_STATUS

21:42:50 36 ORDER BY al.thread#

21:42:50 37 ads.dest_id

THREAD# DEST_ID DEST_NAME TARGET DATABASE_MODE STATUS ERROR TYPE RECOVERY_MODE DB_UNIQUE_ DESTINATION GAP_STATUS Current Sequence Last Archived APPLIED_SEQ#

1 1 LOG_ARCHIVE_DEST_1 PRIMARY OPEN VALID LOCAL IDLE oradgphy 4 3

2 LOG_ARCHIVE_DEST_2 STANDBY UNKNOWN ERROR ORA-01034: UNKNOWN IDLE oradg11g tns_oradg11g RESOLVABLE

ORACLE GAP

Not available

Time spent: 00: 00: 00.00

21:42:50 SQL >

At this point, the failover process succeeds.

1.4.2.4 after the original main library is repaired, power on

21:52:00 SQL > startup

The ORACLE routine has been started.

Total System Global Area 208769024 bytes

Fixed Size 2226936 bytes

Variable Size 146801928 bytes

Database Buffers 54525952 bytes

Redo Buffers 5214208 bytes

The database is loaded.

The database is already open.

21:52:15 SQL > alter database commit to switchover to physical standby with session shutdown

Alter database commit to switchover to physical standby with session shutdown

An error occurred on line 1:

ORA-16416: no feasible Physical Standby handover target

Time spent: 00: 00: 02.06

21:52:24 SQL > select name, LOG_MODE, OPEN_MODE, database_role, SWITCHOVER_STATUS, db_unique_name from v$database

NAME LOG_MODE OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_NAME

ORADG11G ARCHIVELOG READ WRITE PRIMARY FAILED DESTINATION oradg11g

Time spent: 00: 00: 00.00

21:52:31 SQL >

Now after the original main library has been repaired, the entire DataGuara architecture has been destroyed, so it is necessary to delete the original main library and build a new standby library, restore the DataGuard environment, and finally adjust the environment according to whether the switchover switch is needed or not.

1.4.2.5 rebuild the physical dg on the source master database

[oracle@rhel6_lhr oradg11g] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sunday July 26 21:59:40 2015

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

21:59:40 SQL > alter database close

The database has changed.

Time spent: 00: 00: 02.17

22:00:01 SQL > alter system enable restricted session

The system has changed.

Time spent: 00: 00: 02.06

22:00:05 SQL > drop database

The database was deleted.

From Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options disconnect

Time spent: 00: 00: 08.50

22:00:31 SQL > exit

[oracle@rhel6_lhr oradg11g] $cd $ORACLE_HOME/dbs

[oracle@rhel6_lhr dbs] $rm-rf spfileoradg11g.ora

[oracle@rhel6_lhr dbs] $ll spfileoradg11g.ora

Ls: cannot access spfileoradg11g.ora: No such fileor directory

[oracle@rhel6_lhr dbs] $more initoradg

Initoradg11g.ora initoradglg.ora initoradgphy.ora initoradgss.ora

[oracle@rhel6_lhr dbs] $more initoradg11g.ora

Db_name='oradg11g'

[oracle@rhel6_lhr dbs] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sunday July 26 22:02:20 2015

Connected to an idle routine.

22:02:20 SQL > startup nomount

The ORACLE routine has been started.

Total System Global Area 250560512 bytes

Fixed Size 2227256 bytes

Variable Size 192938952 bytes

Database Buffers 50331648 bytes

Redo Buffers 5062656 bytes

22:02:25 SQL > exit

From Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options disconnect

[oracle@rhel6_lhr dbs] $

Oracle@rhel6_lhr dbs] $rman target sys/lhr@tns_oradgphy auxiliary sys/lhr@tns_oradg11g

Recovery Manager: Release 11.2.0.3.0-Production on Sunday July 26 22:04:17 2015

Connected to the target database: ORADG11G (DBID=1403587593)

Connected to secondary database: ORADG11G (not mounted)

RMAN > duplicate target database

2 > for standby nofilenamecheck

3 > from active database

4 > DORECOVER

5 > spfile

6 > set db_unique_name='oradg11g'

7 > set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for= (ALL_LOGFILES,ALL_ROLES)'

8 > set log_archive_dest_2='SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for= (ONLINE_LOGFILES,PRIMARY_ROLE)'

9 > set log_archive_dest_3='SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for= (ONLINE_LOGFILES,PRIMARY_ROLE)'

10 > set log_archive_dest_4='SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for= (ONLINE_LOGFILES,PRIMARY_ROLE)'

11 > set log_archive_dest_state_1='ENABLE'

12 > set log_archive_dest_state_2='ENABLE'

13 > set log_archive_dest_state_3='defer'

14 > set log_archive_dest_state_4='defer'

15 > set standby_file_management='AUTO'

16 > set fal_client='oradg11g'

17 > set fal_server='oradgphy'

18 > set control_files='/u01/app/oracle/oradata/oradg11g/control01.ctl','/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl'

19 > set db_file_name_convert='oradgphy','oradg11g'

20 > set log_file_name_convert='oradgphy','oradg11g'

21 > set memory_target='200M'

22 > set audit_file_dest='/u01/app/oracle/admin/oradg11g/adump'

23 >

Start Duplicate Db at 22:04:34 on 2015-07-26

Replace the recovery directory with the target database control file

Assigned channel: ORA_AUX_DISK_1

Channel ORA_AUX_DISK_1: SID=171 device type = DISK

Contents of the memory script:

{

Backup as copy reuse

Targetfile'/ u01apapworadgphy' auxiliary format

'/ u01apapworadg11g' targetfile'/ u01apapworadg11g'

'/ u01applash oracleUniverse produce auxiliary format 11.2.0Uniplex dbhomecards 1OndbsUniverse spfileoradgphy.ora'Universe

'/ u01 apprenticespact oracleUniverse productUniverse 11.2.0 Universe dbhomecards 1OndbsUniverse spfileoradg11g.ora'

Sql clone "alter system set spfile=''/ u01 apprenticespact oracleUniplicationproductUniverse 11.2.0 Universe dbhomeowners 1 anddbsUniplicationspfileoradg11g.oratrees'"

}

Executing memory script

Start backup at 22:04:34 on 2015-07-26

Assigned channel: ORA_DISK_1

Channel ORA_DISK_1: SID=145 device type = DISK

Completion of backup at 22:04:37 on 2015-07-26

The sql statement: alter system set spfile=''/ u01 apprentice. Oracle.product11.2.0; dbhomeowners 1; dbfileoradg11g.oratrees'

Contents of the memory script:

{

Sql clone "alter system set db_unique_name =

'' oradg11g'' comment=

'scope=spfile''

Sql clone "alter system set log_archive_dest_1 =

'' LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for= (ALL_LOGFILES,ALL_ROLES)''comment=

'scope=spfile''

Sql clone "alter system set log_archive_dest_2 =

'' SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for= (ONLINE_LOGFILES,PRIMARY_ROLE)''comment=

'scope=spfile''

Sql clone "alter system set log_archive_dest_3 =

'' SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for= (ONLINE_LOGFILES,PRIMARY_ROLE)''comment=

'scope=spfile''

Sql clone "alter system set log_archive_dest_4 =

'' SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for= (ONLINE_LOGFILES,PRIMARY_ROLE)''comment=

'scope=spfile''

Sql clone "alter system set log_archive_dest_state_1 =

'' ENABLE'' comment=

'scope=spfile''

Sql clone "alter system set log_archive_dest_state_2 =

'' ENABLE'' comment=

'scope=spfile''

Sql clone "alter system set log_archive_dest_state_3 =

'' defer'' comment=

'scope=spfile''

Sql clone "alter system set log_archive_dest_state_4 =

'' defer'' comment=

'scope=spfile''

Sql clone "alter system set standby_file_management =

'' AUTO'' comment=

'scope=spfile''

Sql clone "alter system set fal_client =

'' oradg11g'' comment=

'scope=spfile''

Sql clone "alter system set fal_server =

'' oradgphy'' comment=

'scope=spfile''

Sql clone "alter system set control_files =

'' / u01ApplictionoracleGreatoradata comment= oradg11g Universe control01.ctlrabbit,''/ u01ActionCharacedoracleCharactsflashrecoveryrabbit areaoradg11g control02.ctlareas' oradg11g control

'scope=spfile''

Sql clone "alter system set db_file_name_convert =

'' oradgphy'',''oradg11g'' comment=

'scope=spfile''

Sql clone "alter system set log_file_name_convert =

'' oradgphy'',''oradg11g'' comment=

'scope=spfile''

Sql clone "alter system set memory_target =

200M comment=

'scope=spfile''

Sql clone "alter system set audit_file_dest =

'' / u01qqappr comment= oradmin comment=

'scope=spfile''

Shutdown clone immediate

Startup clone nomount

}

Executing memory script

Sql statement: alter system set db_unique_name =''oradg11g'' comment=' scope=spfile

Sql statement: alter system set log_archive_dest_1 =''LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for= (ALL_LOGFILES,ALL_ROLES)' 'comment=' scope=spfile

Sql statement: alter system set log_archive_dest_2 =''SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for= (ONLINE_LOGFILES,PRIMARY_ROLE)' 'comment=' scope=spfile

Sql statement: alter system set log_archive_dest_3 =''SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for= (ONLINE_LOGFILES,PRIMARY_ROLE)' 'comment=' scope=spfile

Sql statement: alter system set log_archive_dest_4 =''SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for= (ONLINE_LOGFILES,PRIMARY_ROLE)' 'comment=' scope=spfile

Sql statement: alter system set log_archive_dest_state_1 =''ENABLE'' comment=' scope=spfile

Sql statement: alter system set log_archive_dest_state_2 =''ENABLE'' comment=' scope=spfile

Sql statement: alter system set log_archive_dest_state_3 =''defer'' comment=' scope=spfile

Sql statement: alter system set log_archive_dest_state_4 =''defer'' comment=' scope=spfile

Sql statement: alter system set standby_file_management =''AUTO'' comment=' scope=spfile

Sql statement: alter system set fal_client =''oradg11g'' comment=' scope=spfile

Sql statement: alter system set fal_server =''oradgphy'' comment=' scope=spfile

The sql statement: alter system set control_files ='/ u01According to oradago 'oradat' oradg11g /'/ u01According to 'comment=' scope=spfile'/'/ u01According to the flashworthy recovery.'

Sql statement: alter system set db_file_name_convert =''oradgphy'',' oradg11g'' comment= 'scope=spfile

Sql statement: alter system set log_file_name_convert =''oradgphy'',' oradg11g'' comment= 'scope=spfile

Sql statement: alter system set memory_target = 200m comment=''scope=spfile

Sql statement: alter system set audit_file_dest ='/ u01 comment= scope=spfile

Oracle instance is closed

Connected to the secondary database (not started)

Oracle instance has been started

The total system global area is 208769024 bytes

Fixed Size 2226936 byt

Variable Size 113247496 byt

Database Buffers 88080384 byt

Redo Buffers 5214208 byt

Contents of the memory script:

{

Backup as copy current controlfile for standby auxiliary format'/ u01qapplash oradataoradat 'oradg11g control 01.ctl'

Restore clone controlfile to'/ u01According to an oracle from flashy recovery recovery area oradg11g Control 02.ctl'

'/ u01appranumoracleandoradataplicoradg11g control 01.ctl'

}

Executing memory script

Start backup at 22:04:44 on 2015-07-26

Use channel ORA_DISK_1

Channel ORA_DISK_1: start a copy of the data file

Copy alternate control files

Output file name = / u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_oradgphy.f tag = TAG20150726T220444 RECID=11 STAMP=886111485

Channel ORA_DISK_1: data files have been copied. Time elapsed: 00:00:01

Completion of backup at 22:04:45 on 2015-07-26

Start restore at 22:04:45 on 2015-07-26

Assigned channel: ORA_AUX_DISK_1

Channel ORA_AUX_DISK_1: SID=134 device type = DISK

Channel ORA_AUX_DISK_1: a copy of the control file is copied

Completion of restore at 22:04:47 on 2015-07-26

Contents of the memory script:

{

Sql clone 'alter database mount standby database'

}

Executing memory script

Sql statement: alter database mount standby database

Contents of the memory script:

{

Set newname for tempfile 1 to

"/ u01/app/oracle/oradata/oradg11g/temp01.dbf"

Switch clone tempfile all

Set newname for datafile 1 to

"/ u01/app/oracle/oradata/oradg11g/system01.dbf"

Set newname for datafile 2 to

"/ u01/app/oracle/oradata/oradg11g/sysaux01.dbf"

Set newname for datafile 3 to

"/ u01/app/oracle/oradata/oradg11g/undotbs01.dbf"

Set newname for datafile 4 to

"/ u01/app/oracle/oradata/oradg11g/users01.dbf"

Set newname for datafile 5 to

"/ u01/app/oracle/oradata/oradg11g/example01.dbf"

Set newname for datafile 6 to

"/ u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf"

Backup as copy reuse

Datafile 1 auxiliary format

"/ u01/app/oracle/oradata/oradg11g/system01.dbf" datafile

2 auxiliary format

"/ u01/app/oracle/oradata/oradg11g/sysaux01.dbf" datafile

3 auxiliary format

"/ u01/app/oracle/oradata/oradg11g/undotbs01.dbf" datafile

4 auxiliary format

"/ u01/app/oracle/oradata/oradg11g/users01.dbf" datafile

5 auxiliary format

"/ u01/app/oracle/oradata/oradg11g/example01.dbf" datafile

6 auxiliary format

"/ u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf"

Sql 'alter system archive log current'

}

Executing memory script

Executing command: SET NEWNAME

Temporary file 1 has been renamed to / u01/app/oracle/oradata/oradg11g/temp01.dbf in the control file

Executing command: SET NEWNAME

Start backup at 22:04:52 on 2015-07-26

Use channel ORA_DISK_1

Channel ORA_DISK_1: start a copy of the data file

Input data file: file number = 00001 name = / u01/app/oracle/oradata/oradgphy/system01.dbf

Output file name = / u01/app/oracle/oradata/oradg11g/system01.dbf tag = TAG20150726T220452

Channel ORA_DISK_1: data files have been copied. Time elapsed: 00:00:25

Channel ORA_DISK_1: start a copy of the data file

Input data file: file number = 00002 name = / u01/app/oracle/oradata/oradgphy/sysaux01.dbf

Output file name = / u01/app/oracle/oradata/oradg11g/sysaux01.dbf tag = TAG20150726T220452

Channel ORA_DISK_1: data files have been copied. Time elapsed: 00:00:15

Channel ORA_DISK_1: start a copy of the data file

Input data file: file number = 00005 name = / u01/app/oracle/oradata/oradgphy/example01.dbf

Output file name = / u01/app/oracle/oradata/oradg11g/example01.dbf tag = TAG20150726T220452

Channel ORA_DISK_1: data files have been copied. Time elapsed: 00:00:07

Channel ORA_DISK_1: start a copy of the data file

Input data file: file number = 00006 name = / u01/app/oracle/oradata/oradgphy/logmnrtbs1.dbf

Output file name = / u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf tag = TAG20150726T220452

Channel ORA_DISK_1: data files have been copied. Time elapsed: 00:00:03

Channel ORA_DISK_1: start a copy of the data file

Input data file: file number = 00003 name = / u01/app/oracle/oradata/oradgphy/undotbs01.dbf

Output file name = / u01/app/oracle/oradata/oradg11g/undotbs01.dbf tag = TAG20150726T220452

Channel ORA_DISK_1: data files have been copied. Time elapsed: 00:00:03

Channel ORA_DISK_1: start a copy of the data file

Input data file: file number = 00004 name = / u01/app/oracle/oradata/oradgphy/users01.dbf

Output file name = / u01/app/oracle/oradata/oradg11g/users01.dbf tag = TAG20150726T220452

Channel ORA_DISK_1: data files have been copied. Time elapsed: 00:00:01

Completion of backup at 22:05:47 on 2015-07-26

Sql statement: alter system archive log current

Contents of the memory script:

{

Backup as copy reuse

Archivelog like "/ u01/app/oracle/flash_recovery_area/ORADGPHY/archivelog/2015_07_26/o1_mf_1_4_bv9t9vtg_.arc" auxiliary format

"/ u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_%u_.arc"

Catalog clone recovery area

Switch clone datafile all

}

Executing memory script

Start backup at 22:05:47 on 2015-07-26

Use channel ORA_DISK_1

Channel ORA_DISK_1: starting to copy archive logs

Enter archive log thread = 1 sequence = 4 RECID=205 STAMP=886111547

Output file name = / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_11qd1v9s_.arc RECID=0 STAMP=0

Channel ORA_DISK_1: replication of archive logs is complete. Time elapsed: 00:00:01

Completion of backup at 22:05:49 on 2015-07-26

Search for all files in the recovery area

List of unknown files in the database

= =

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_13/o1_mf_1_101_blphvhp6_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_94_bl9w2pcn_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_83_bl91pfk8_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_82_bl91gpm1_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_92_bl9w2htt_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_91_bl9w2cpb_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_86_bl91r2j5_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_84_bl91r03h_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_87_bl91r46j_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_89_bl944htj_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_96_bl9w7ym1_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_90_bl944mbj_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_88_bl944f8q_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_95_bl9w6x2l_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_85_bl91r1n9_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_08/o1_mf_1_93_bl9w2nqd_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_18_bkwnm191_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_8_bkwmq00d_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_7_bkwmhpjf_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_14_bkwn5m3n_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_28_bkwr591w_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_15_bkwn5onz_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_23_bkwp1926_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_6_bkwmho6g_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_10_bkwmts9r_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_29_bkwr5d1c_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_16_bkwnll4b_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_27_bkwr5820_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_12_bkwn2kg5_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_21_bkwp14lm_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_19_bkwnyrd9_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_20_bkwp12lg_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_5_bkwmhm1w_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_9_bkwms0xq_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_11_bkwn1m0k_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_22_bkwp18j4_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_25_bkwr53xb_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_24_bkwr51nw_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_26_bkwr5792_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_13_bkwn5jjr_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_03/o1_mf_1_17_bkwnltkg_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_12/o1_mf_1_100_blmt7y70_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_12/o1_mf_1_99_blmt7qw3_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_105_bm3b08sr_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_106_bm3b09br_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_108_bm46tv7x_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_18/o1_mf_1_107_bm3cr8c8_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_22/o1_mf_1_112_bmgqwv55_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_22/o1_mf_1_111_bmgqwr6x_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_52_bl6lzfrl_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_55_bl6m5bmw_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_41_bl6ksxpc_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_42_bl6kt79v_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_81_bl78wx8z_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_76_bl6zdp5q_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_59_bl6psk7g_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_78_bl70ggr3_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_38_bl6jxyv7_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_60_bl6rsyr5_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_66_bl6txphk_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_49_bl6lzbf9_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_58_bl6pphgd_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_69_bl6vsrjo_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_77_bl6zjwor_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_65_bl6tvoy4_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_67_bl6v0qpo_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_39_bl6kc33t_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_44_bl6ktcns_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_70_bl6w7xdb_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_43_bl6ktbhb_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_46_bl6lgrvk_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_51_bl6lzdv0_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_50_bl6lzcyk_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_74_bl6xszqy_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_64_bl6tq9wk_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_79_bl756jv6_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_53_bl6lzgjo_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_62_bl6s6n5b_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_73_bl6xsw3n_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_40_bl6kjq6t_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_75_bl6y75kr_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_45_bl6kzrco_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_63_bl6tg3n5_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_56_bl6m91dj_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_57_bl6pnhgz_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_68_bl6v2g09_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_72_bl6x12lr_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_80_bl75fxqq_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_47_bl6lmn9x_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_61_bl6ryph7_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_71_bl6wwf5z_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_54_bl6lzh7p_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_07/o1_mf_1_48_bl6lz8ml_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_16/o1_mf_1_102_blyzlgl4_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_10/o1_mf_1_98_blgfvnl1_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_10/o1_mf_1_97_blgfvjsq_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_33_bl1sgljq_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_34_bl1t30n7_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_37_bl1tm3wp_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_32_bl1sghl1_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_35_bl1t82c7_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_31_bl1r7lvx_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_30_bl1r2khh_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_05/o1_mf_1_36_bl1tfkwh_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_17/o1_mf_1_104_bm0sphhn_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_17/o1_mf_1_103_bm0spdc0_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_19/o1_mf_1_109_bm6c1gkg_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_04_19/o1_mf_1_110_bm6vnvn8_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_162_bv9lv9dh_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_140_bv9f7bto_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_128_bv9bx6q6_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_159_bv9lv1lc_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_150_bv9l2tf8_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_175_bv9np57g_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_174_bv9njntv_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_123_bv8tk683_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_163_bv9lvb3z_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_125_bv8tlqbg_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_149_bv9l2tg6_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_124_bv8tln9j_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_119_bv8tfqjl_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_143_bv9g0kcy_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_153_bv9l3yvc_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_126_bv9bjbtc_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_115_bv8l7zwj_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_186_bv9sjh5n_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_127_bv9bjfyx_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_176_bv9np9s1_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_182_bv9r54gy_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_139_bv9dntg5_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_152_bv9l3vjz_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_bv9d1fw8_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_183_bv9sf8gz_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_161_bv9lv8m7_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_178_bv9nsfr4_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_4_11qd1v9s_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_157_bv9lplmh_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_158_bv9lqynz_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_169_bv9mo6vz_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_173_bv9njhh7_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_167_bv9mo4gs_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_170_bv9mo7ol_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_187_bv9sjhkw_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_164_bv9lvbtq_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_141_bv9f7z0g_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_120_bv8tfqjb_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_1_bv9d1foq_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_113_bv8k3g8d_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_130_bv9cn3l6_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_122_bv8tk1hh_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_129_bv9bxd7k_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_171_bv9nfm1o_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_188_bv9sjphl_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_148_bv9l2tfo_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_166_bv9mo2o1_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_114_bv8k3l2v_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_168_bv9mo6vs_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_121_bv8tdl7m_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_160_bv9lv7l7_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_146_bv9hpfhc_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_138_bv9dnqfx_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_116_bv8ly4j0_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_180_bv9r3b5v_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_154_bv9l5ko5_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_3_bv9d1fkm_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_144_bv9g11md_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_155_bv9ldn80_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_118_bv8rwvmt_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_147_0pqd1l03_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_184_bv9sf9yd_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_156_bv9ldr9q_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_185_bv9shl4j_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_172_bv9nfnyf_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_181_bv9r4l18_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_165_bv9lvfkz_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_2_bv9cn3kt_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_151_bv9l2xfj_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_145_0hqd1kbq_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_179_bv9r1cp8_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_117_bv8rwqbv_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_177_bv9ns9rj_.arc

File name: / u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_07_26/o1_mf_1_5_bv9d3yjl_.arc

A catalogue of documents is being compiled.

The catalogue has been compiled

A list of files that have been listed in the directory