@@ Message: Other users will be warned until 2018-08-03 08:51:11 that @ you are editing this page. @@ Comment: None @@ Trivial: (x) Yes ( ) No Describe désert/Oracle/DataGuard here.

Contents

前提条件
1. 主服务器信息
2. 备服务器信息
主服务器配制
备库操作

前提条件

db_unique_name 在主备服务器不能相同。
hosts文件中定义各自的主机名

127.0.0.1           localhost
192.168.81.21       gopos
192.168.81.22       goposstb

主服务器信息

OEL/RHEL 6.6
Server name: gopos
IP: 192.168.81.21
Oracle 11.2.0.4 software with oracle instance
Oracle SID/Global_name: gopos
Oracle db_unique_name: gopos

备服务器信息

OEL/RHEL 6.6
Server name: goposstb
IP: 192.168.81.22
Oracle 11.2.0.4 software only
Oracle SID/Global_name: gopos
Oracle db_unique_name: goposstb

主服务器配制

SGA: (96*0.8)*0.6 PGA: (96*0.8)*0.4

# disable AMM
alter system reset memory_target;
SQL> alter system set sga_target=0;

#alter system reset memory_max_target;
SHUTDOWN IMMEDIATE
STARTUP

alter system set memory_max_target=77G scope=spfile;
alter system set memory_target=77G scope=spfile;

alter system set sga_target=45G scope=both;
alter system set pga_aggregate_target=20G scope=both;
SHUTDOWN IMMEDIATE
STARTUP

启用/禁用FRA

SQL> show parameter recovery_file_dest
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +GOPOS_DATA
db_recovery_file_dest_size           big integer 4182M

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '+GOPOS_ARCH' SCOPE=BOTH SID='*';

System altered.

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 100G SCOPE=BOTH SID='*';
SQL> show parameter recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +GOPOS_ARCH
db_recovery_file_dest_size           big integer 100G

# disable DB_RECOVERY
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='' SCOPE=BOTH SID='*';

启用归档

SQL> alter system set log_archive_dest_1='LOCATION=+GOPOS_ARCH' scope = both;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;
SQL> alter system switch logfile;

确认归档配制
SQL> archive log list;

启用logging

SQL> ALTER DATABASE FORCE LOGGING;

Database altered.

SQL> SELECT FORCE_LOGGING  FROM v$database;

FOR
---
YES

检查初始化参数

SQL> show parameter db_name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      gopos

SQL> show parameter db_unique_name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      gopos

配制LOG_ARCHIVE_CONFIG参数

SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(gopos,goposstb)';

确认LOG_ARCHIVE_CONFIG配制
SQL> show parameter LOG_ARCHIVE_CONFIG

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string      DG_CONFIG=(gopos,goposstb)

设置对端LOG ARCHIVE

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=goposstb NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=goposstb';

确认以上配制
SQL> show parameter LOG_ARCHIVE_DEST_2
SQL> show parameter LOG_ARCHIVE_DEST_2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string      SERVICE=goposstb NOAFFIRM ASYN
                                                 C VALID_FOR=(ONLINE_LOGFILES,P
                                                 RIMARY_ROLE) DB_UNIQUE_NAME=go
                                                 posstb
                                                                                                                                                   log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  string
log_archive_dest_24                  string
log_archive_dest_25                  string
log_archive_dest_26                  string
                                                                                                                                                   NAME                                 TYPE        VALUE
------------------------------ -----------------------------
log_archive_dest_27                  string
log_archive_dest_28                  string
log_archive_dest_29                  string


启用LOG_ARCHIVE_DEST_2
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

确认状态
SQL> show parameter LOG_ARCHIVE_DEST_STATE_2;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2             string      ENABLE
log_archive_dest_state_20            string      enable
log_archive_dest_state_21            string      enable
log_archive_dest_state_22            string      enable
log_archive_dest_state_23            string      enable
log_archive_dest_state_24            string      enable
log_archive_dest_state_25            string      enable
log_archive_dest_state_26            string      enable
log_archive_dest_state_27            string      enable
log_archive_dest_state_28            string      enable
log_archive_dest_state_29            string      enable

设置LOG ARCHIVE

ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.arc' SCOPE=SPFILE;
ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=30;
ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE SCOPE=SPFILE;

show parameter log_archive_format;
show parameter log_archive_max_processes;
show parameter remote_login_passwordfile;

SQL> show parameter log_archive_max_processes;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_max_processes            integer     30
SQL> show parameter remote_login_passwordfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

设置fal_server

ALTER SYSTEM SET FAL_SERVER=goposstb;
ALTER SYSTEM SET DB_FILE_NAME_CONVERT='goposstb','gopos' SCOPE=SPFILE;
ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='goposstb','gopos'  SCOPE=SPFILE;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;

show parameter fal_server;
show parameter standby_file_management;

SQL> show parameter fal_server;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fal_server                           string      GOPOSSTB
SQL> show parameter standby_file_management;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_file_management              string      AUTO

配制listener.ora & tnsnames.ora

SQL> select value from v$parameter where name='service_names';

   VALUE
   --------------------------------------------------------------------------------
   gopos

tnsnames.ora

GOPOS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = gopos)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = gopos)
      (UR = A)
    )
  )

GOPOSSTB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = goposstb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = gopos)
      (UR = A)
    )
  )

listener.ora

# in goposstb host!!! Login with oracle, run 'netca' command to create

/u01/app/11.2.0/grid/network/admin/listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = gopos)
(ORACLE_HOME = /u01/app/11.2.0/grid)
(SID_NAME = gopos)
)
)

SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
    (GLOBAL_DBNAME = GOPOS)
  (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
  (SID_NAME = GOPOS)
) )
  LISTENER =
   (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = GOPOS)(PORT = 1521))
   )
ADR_BASE_LISTENER = /u01/app/oracle

确认主备都能ping通

tnsping GOPOS
tnsping GOPOSSTB

为备数据库创建PFILE

SQL> CREATE PFILE='~/initgoposstb.ora' FROM SPFILE;

File created.

修改PFILE ~/initgoposstb.ora

*.audit_file_dest='/u01/app/oracle/admin/goposstb/adump'
*.control_files='+GOPOS_DATA/gopos/controlfile/current.276.917608579','+GOPOS_DATA/gopos/controlfile/current.277.917608579'
*.db_file_name_convert='+GOPOS_DATA','+GOPOS_DATA'
*.db_unique_name='goposstb'
*.fal_server='gopos'
*.log_archive_dest_2='SERVICE=gopos ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=gopos'
*.log_file_name_convert='+GOPOS_REDO','+GOPOS_REDO'

备库操作

确认listener启动正常

lsnrctl status

使用RMAN自动复制主数据库至备数据库

For duplicate listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = GOPOS)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = GOPOS)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = GOPOSSTB)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

~$ sqlplus / as sysdba
SQL> startup nomount pfile='$ORACLE_HOME/dbs/initgoposstb.ora';
ORACLE instance started.

Total System Global Area 7465926656 bytes
Fixed Size                  2267744 bytes
Variable Size            1375733152 bytes
Database Buffers         6073352192 bytes
Redo Buffers               14573568 bytes


[oracle@goposstb ~]$ rman target sys@gopos auxiliary sys@goposstb
RMAN> duplicate target database for standby from active database nofilenamecheck;

在主备创建日志文件

set echo off
set feedback off
set linesize 120
set pagesize 35
set trim on
set trims on
set lines 120
col group# format 999
col thread# format 999
col member format a70 wrap
col status format a10
col archived format a10
col fsize format 999 heading "Size (MB)"
select l.group#, l.thread#, f.member, l.archived, l.status, (bytes/1024/1024) fsize from v$log l, v$logfile f where f.group# = l.group# order by 1,2;


set linesize 300
column REDOLOG_FILE_NAME format a50
SELECT
    a.GROUP#,
    a.THREAD#,
    a.SEQUENCE#,
    a.ARCHIVED,
    a.STATUS,
    b.MEMBER    AS REDOLOG_FILE_NAME,
    (a.BYTES/1024/1024) AS SIZE_MB
FROM v$log a
JOIN v$logfile b ON a.Group#=b.Group# 
ORDER BY a.GROUP# ASC;

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1
GROUP 50 ('+LOG') SIZE 200M,
GROUP 51 ('+LOG') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2
GROUP 53 ('+LOG') SIZE 200M,
GROUP 54 ('+LOG') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1
GROUP 55 ('+LOG') SIZE 200M,
GROUP 56 ('+LOG') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2
GROUP 57 ('+LOG') SIZE 200M,
GROUP 58 ('+LOG') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1
GROUP 59 ('+LOG') SIZE 200M,
GROUP 60 ('+LOG') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2
GROUP 61 ('+LOG') SIZE 200M,
GROUP 62 ('+LOG') SIZE 200M;

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';


SELECT a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group#;

select member from v$logfile;

在主和备数据库中创建STANDBY LOGFILE( +1 redo file ) ALTER DATABASE ADD LOGFILE GROUP 6 ('+GOPOS_REDO',' /u01/app/oracle/redo_local/redo06.log') SIZE 4G;

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';
ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 ('+GOPOS_REDO','/u01/app/oracle/redo_local/redo_stb07.log') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 8 ('+GOPOS_REDO','/u01/app/oracle/redo_local/redo_stb08.log') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 9 ('+GOPOS_REDO','/u01/app/oracle/redo_local/redo_stb09.log') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 10 ('+GOPOS_REDO','/u01/app/oracle/redo_local/redo_stb10.log') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 11 ('+GOPOS_REDO','/u01/app/oracle/redo_local/redo_stb11.log') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 12 ('+GOPOS_REDO','/u01/app/oracle/redo_local/redo_stb12.log') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 13 ('+GOPOS_REDO','/u01/app/oracle/redo_local/redo_stb13.log') SIZE 4G;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 2 ('+GOPOS_REDO','+REDO_LOCAL') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 3 ('+GOPOS_REDO','+REDO_LOCAL') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('+GOPOS_REDO','+REDO_LOCAL') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ('+GOPOS_REDO','+REDO_LOCAL') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ('+GOPOS_REDO','+REDO_LOCAL') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 ('+GOPOS_REDO','+REDO_LOCAL') SIZE 4G;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';



ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';
ALTER DATABASE ADD STANDBY LOGFILE GROUP 1 ('+GOPOS_REDO','+REDO_LOCAL) SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE ('+GOPOS_REDO') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE ('+GOPOS_REDO') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE ('+GOPOS_REDO') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE ('+GOPOS_REDO') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE ('+GOPOS_REDO') SIZE 4G;
ALTER DATABASE ADD STANDBY LOGFILE ('+GOPOS_REDO') SIZE 4G;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';


select member from v$logfile where type='STANDBY';

ALTER DATABASE DROP LOGFILE GROUP 10;

/u01/app/11.2.0/grid/bin
[grid@goposstb bin]$ ./setasmgidwrap -o oracle

应用传输进程

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION;

# Foreground redo apply. Session never returns until cancel. 
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;

# Background redo apply. Control is returned to the session once the apply process is started.
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

停止传输

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

确认Dataguard保护模式

默认为 maximum performance 模式

SELECT protection_mode FROM v$database;

select name,open_mode,database_role from v$database;
select message from v$dataguard_status;
select dest_name,status,error from v$archive_dest where dest_name='LOG_ARCHIVE_DEST_2';

dgmgrl sys/oracle36#^@goposstb
DGMGRL>  show configuration;

测试主备服务器ARCHIVELOG

主:

ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

SELECT sequence#, first_time, next_time
FROM   v$archived_log
ORDER BY sequence#;

ALTER SYSTEM SWITCH LOGFILE;

备:

ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

SELECT sequence#, first_time, next_time, applied FROM v$archived_log where APPLIED = 'YES' ORDER BY sequence#;

主备数据库切换操作

Enable Data Guard Broker

http://www.juliandyke.com/Research/DataGuard/DataGuardBroker.php

Both gopos/goposstb

SQL> ALTER SYSTEM SET dg_broker_start = TRUE;

Start DGMGRL

dgmgrl

Create Data Guard Broker Configuration

dgmgrl> CONNECT sys;
 CREATE CONFIGURATION DG1 AS PRIMARY DATABASE IS 'gopos'
 CONNECT IDENTIFIER IS 'gopos';

 Configuration "DG1" created with primary database "gopos"

Add standby database(s)

 dgmgrl
 ADD DATABASE 'goposstb' AS CONNECT IDENTIFIER IS 'goposstb';

Enable the configuration

 dgmgrl
 ENABLE CONFIGURATION

Switchover to standby

 dgmgrl
DGMGRL> SWITCHOVER TO 'goposstb'

Switchback

 dgmgrl
DGMGRL> SWITCHOVER TO 'gopos'

手动从主gopos切换至备goposstb

CONNECT / AS SYSDBA
ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;

关闭主gopos数据库，挂载主数据库为“备”数据库工作

STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

备数据库(goposstb)执行接管操作

CONNECT / AS SYSDBA
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
SHUTDOWN IMMEDIATE;
STARTUP;

切换回去的话，重启执行一遍，反方向。

主数据库故障手动切换操作

在备goposstb数据库执行

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
ALTER DATABASE ACTIVATE STANDBY DATABASE;

Read-Only Standby and Active Data Guard

To switch the standby database into read-only mode, do the following.

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE OPEN READ ONLY;

select name,open_mode,database_role from v$database;

To resume managed recovery, do the following.

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

select name,open_mode,database_role from v$database;

Remove dataguard

alter database recover managed standby database disconnect from session; 
alter database recover managed standby database cancel;

dup log

[oracle@goposstb ~]$ lsnrctl start 

[oracle@goposstb ~]$ rman target sys/oracle36#^@gopos auxiliary sys/oracle36#^@goposstb

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 8 01:33:11 2016

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

connected to target database: GOPOS (DBID=1444008119)
connected to auxiliary database: GOPOS (not mounted)

RMAN> duplicate target database for standby from active database nofilenamecheck;

Starting Duplicate Db at 08-JUL-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=20 device type=DISK

contents of Memory Script:
{  
   backup as copy reuse
   targetfile  '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwgopos' auxiliary format
 '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwgopos'   ;
}
executing Memory Script

Starting backup at 08-JUL-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=68 device type=DISK
Finished backup at 08-JUL-16

contents of Memory Script:
{  
   backup as copy current controlfile for standby auxiliary format  '/mnt/sdb1/oracleData/gopos/control01.ctl';
   restore clone controlfile to  '/mnt/sdb1/oracleData/rman/control02.ctl' from
 '/mnt/sdb1/oracleData/gopos/control01.ctl';
}
executing Memory Script

Starting backup at 08-JUL-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/mnt/sdb1/oracleData/rman/snapcf_gopos.f tag=TAG20160708T013323 RECID=5 STAMP=916623203
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 08-JUL-16

Starting restore at 08-JUL-16
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 08-JUL-16

contents of Memory Script:
{  
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
   set newname for tempfile  1 to 
 "/mnt/sdb1/oracleData/gopos/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to 
 "/mnt/sdb1/oracleData/gopos/system01.dbf";
   set newname for datafile  2 to 
 "/mnt/sdb1/oracleData/gopos/sysaux01.dbf";
   set newname for datafile  3 to 
 "/mnt/sdb1/oracleData/gopos/undotbs01.dbf";
   set newname for datafile  4 to 
 "/mnt/sdb1/oracleData/gopos/users01.dbf";
   backup as copy reuse
   datafile  1 auxiliary format 
 "/mnt/sdb1/oracleData/gopos/system01.dbf"   datafile 
 2 auxiliary format 
 "/mnt/sdb1/oracleData/gopos/sysaux01.dbf"   datafile 
 3 auxiliary format 
 "/mnt/sdb1/oracleData/gopos/undotbs01.dbf"   datafile 
 4 auxiliary format 
 "/mnt/sdb1/oracleData/gopos/users01.dbf"   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /mnt/sdb1/oracleData/gopos/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 08-JUL-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/mnt/sdb1/oracleData/gopos/system01.dbf
output file name=/mnt/sdb1/oracleData/gopos/system01.dbf tag=TAG20160708T013331
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/mnt/sdb1/oracleData/gopos/sysaux01.dbf
output file name=/mnt/sdb1/oracleData/gopos/sysaux01.dbf tag=TAG20160708T013331
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/mnt/sdb1/oracleData/gopos/undotbs01.dbf
output file name=/mnt/sdb1/oracleData/gopos/undotbs01.dbf tag=TAG20160708T013331
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/mnt/sdb1/oracleData/gopos/users01.dbf
output file name=/mnt/sdb1/oracleData/gopos/users01.dbf tag=TAG20160708T013331
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 08-JUL-16

sql statement: alter system archive log current

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=916623257 file name=/mnt/sdb1/oracleData/gopos/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=916623257 file name=/mnt/sdb1/oracleData/gopos/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=916623257 file name=/mnt/sdb1/oracleData/gopos/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=916623257 file name=/mnt/sdb1/oracleData/gopos/users01.dbf
Finished Duplicate Db at 08-JUL-16

désert/Oracle/DataGuard_with_ASM (last edited 2018-08-03 10:32:12 by localhost)