Contents
- 前提条件
- RAC环境配制
- 备数据库服务器操作
-
Troubleshooting
- ora 01666
- copy controlfile from localdisk to asm
- ORA 01624
- ORA 01378
- TNS-01189: The listener could not authenticate the user
- ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
- auxiliary duplicate error
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.
- ORA-01665: control file is not a standby control file
- ORA 16139
- ORA-00328
- alert failed to establish dependency between database and diskgroup
- ERROR: failed to establish dependency between database mcnet_dg and diskgroup resource ora.GOPOS_ARCH.dg
- ORA-01153: an incompatible media recovery is active
- NOTE: ASM client mcnet:mcnet disconnected unexpectedly.
- drop database
- TEST
- Rebuild standby REDO
前提条件
- db_unique_name 在主备服务器不能相同。
- hosts文件中定义各自的主机名
127.0.0.1 localhost 192.168.80.165 MINISO-HDNET-DB01 192.168.80.115 hdnet-cluster-scan
RAC环境信息
OEL/RHEL 6.4 Server name: hdnet1&hdnet2 IP: 192.168.80.116&117 Oracle 11.2.0.4 software with oracle instance Oracle SID/Global_name: mcnet1&mcnet2 Oracle db_unique_name: mcnet ASM disk groups: BACKUP,CRS,DATA,REDO [oracle@ ~]$ ulimit -u 2047 [oracle@ ~]$ lsof -u `id -u oracle` | wc -l 694
备服务器信息
OEL/RHEL 6.4 Server name: mcnet_dg IP: 192.168.80.165 Oracle 11.2.0.4 software only Oracle SID/Global_name: mcnet Oracle db_unique_name: mcnet_dg ASM disk groups: ARCH,CRS,DATA,REDO
RAC环境配制
确认归档是否开启
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 mcnet SQL> show parameter db_unique_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_unique_name string mcnet select * from gv$logfile; select * from gv$log;
配制LOG_ARCHIVE_CONFIG参数
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(mcnet,mcnet_dg)'; 确认LOG_ARCHIVE_CONFIG配制 SQL> show parameter LOG_ARCHIVE_CONFIG NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_config string DG_CONFIG=(mcnet,mcnet_dg)
设置LOG ARCHIVE
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+BACKUP/archlog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=mcnet' SID='*';
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=mcnet_dg NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=mcnet_dg' SID='*';
确认以上配制
SQL> show parameter LOG_ARCHIVE_DEST_1
SQL> show parameter LOG_ARCHIVE_DEST_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=mcnet_dg 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_1
启用LOG_ARCHIVE_DEST_2
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE SID='*';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SID='*';
确认状态
SQL> show parameter LOG_ARCHIVE_DEST_STATE_1;
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 SID='*'; ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE SCOPE=SPFILE SID='*'; 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=mcnet_dg SID='*'; #ALTER SYSTEM SET DB_FILE_NAME_CONVERT='+DATA/mcnet_dg','+DATA/mcnet' SCOPE=SPFILE SID='*'; #ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='+LOG/mcnet_dg','+REDO/mcnet' SCOPE=SPFILE SID='*'; ALTER SYSTEM SET DB_FILE_NAME_CONVERT='+DATA/MCNET_DG','+DATA/MCNET' SCOPE=SPFILE SID='*'; ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='+LOG/MCNET_DG','+REDO/MCNET' SCOPE=SPFILE SID='*'; #ALTER SYSTEM SET DB_FILE_NAME_CONVERT='+DATA','+DATA' SCOPE=SPFILE SID='*'; #ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='+LOG','+REDO' SCOPE=SPFILE SID='*'; ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SID='*'; 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 -------------------------------------------------------------------------------- mcnet
tnsnames.ora
GOPOS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mcnet)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mcnet)
(UR = A)
)
)
GOPOSSTB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mcnet_dg)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mcnet)
(UR = A)
)
)listener.ora
# in mcnet_dg host!!! Login with oracle, run 'netca' command to create
#1
/u01/app/11.2.0/grid/network/admin/listener.ora
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = mcnet) (ORACLE_HOME = /u01/app/11.2.0/grid) (SID_NAME = mcnet) ) )
#2
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
备份主数据库
$ rman target /
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/mnt/sdb1/rman/full_%u_%s_%p'; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; # 默认将备份到Flash Recovery Area.
为备数据库创建控制文件和PFILE
ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/home/oracle/mcnet_dg.ctl'; CREATE PFILE='/home/oracle/initmcnet_dg.ora' FROM SPFILE; SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '~/mcnet_dg.ctl'; Database altered. SQL> CREATE PFILE='~/initmcnet_dg.ora' FROM SPFILE; File created.
修改PFILE ~/initmcnet_dg.ora
*.fal_server='MCNET' *.log_archive_dest_1='LOCATION=+LOG/archlog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=mcnet_dg' *.log_archive_dest_2='SERVICE=mcnet NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=mcnet' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='ENABLE' *.db_file_name_convert='+DATA','+DATA' *.log_file_name_convert='+REDO','+LOG' *.db_unique_name='mcnet_dg' *.control_files='+LOG/mcnet/controlfile/controlfile01.ctl','+DATA/mcnet/controlfile/controlfile02.ctl'
首先登录备数据库创建以下目录
asmcmd mkdir +DATA/MCNET/CONTROLFILE asmcmd mkdir +LOG/MCNET/CONTROLFILE asmcmd mkdir +LOG/MCNET/ONELINELOG asmcmd mkdir +DATA/MCNET/DATAFILE asmcmd mkdir +DATA/MCNET/TEMPFILE asmcmd mkdir +DATA/MCNET/PARAMETERFILE
备数据库服务器操作
注：可选？！首先更改db_unique_name为对应的名称。
alter system set db_unique_name='mcnet_dg' SCOPE=SPFILE; select db_unique_name from v$database; # OR: show parameter unique;
确认listener启动正常
lsnrctl status
从备份中恢复数据库(可选方法）
恢复控制文件
export ORACLE_SID=mcnet sqlplus / as sysdba SQL> CREATE SPFILE FROM PFILE='~/initmcnet_dg.ora';
恢复数据库
export ORACLE_SID=mcnet rman target / RMAN> STARTUP MOUNT; RMAN> list backup of database summary; RMAN> RESTORE DATABASE;
Note: Recovery of database would be failed with RMAN-06054 error, We can ignore it because RMAN will ask for unknown archive log ( i.e. next archive log sequence, i.e. 10 ) who is not also available on Primary database.
Error log: RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 10 and starting SCN of 1009554
使用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;
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@mcnet_dg ~]$ rman target sys@mcnet auxiliary sys@mcnet_dg
RMAN> duplicate target database for standby from active database nofilenamecheck;
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
#duplicate target database for standby from active database nofilenamecheck dorecover;
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=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 )*2
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1
GROUP 50 ('+REDO') SIZE 200M,
GROUP 51 ('+REDO') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2
GROUP 53 ('+REDO') SIZE 200M,
GROUP 54 ('+REDO') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1
GROUP 55 ('+REDO') SIZE 200M,
GROUP 56 ('+REDO') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2
GROUP 57 ('+REDO') SIZE 200M,
GROUP 58 ('+REDO') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1
GROUP 59 ('+REDO') SIZE 200M,
GROUP 60 ('+REDO') SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2
GROUP 61 ('+REDO') SIZE 200M,
GROUP 62 ('+REDO') SIZE 200M;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';
ALTER DATABASE DROP LOGFILE GROUP 70;
SELECT a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group#;
select member from v$logfile where type='STANDBY';ALTER DATABASE DROP LOGFILE GROUP 10; /u01/app/11.2.0/grid/bin [grid@mcnet_dg 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; # Real time ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
停止传输
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
确认Dataguard保护模式
默认为 maximum performance 模式
SELECT protection_mode FROM v$database;
select message from v$dataguard_status; select name, db_unique_name, database_role, open_mode,switchover_status from v$database; select dest_name,status,error from v$archive_dest where dest_name='LOG_ARCHIVE_DEST_2'; SELECT protection_mode FROM v$database; dgmgrl sys/oracle36#^@mcnet_dg 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 mcnet/mcnet_dg
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 'mcnet' CONNECT IDENTIFIER IS 'mcnet'; Configuration "DG1" created with primary database "mcnet"
- Add standby database(s)
dgmgrl ADD DATABASE 'mcnet_dg' AS CONNECT IDENTIFIER IS 'mcnet_dg';
- Enable the configuration
dgmgrl ENABLE CONFIGURATION
- Switchover to standby
dgmgrl DGMGRL> SWITCHOVER TO 'mcnet_dg'
- Switchback
dgmgrl DGMGRL> SWITCHOVER TO 'mcnet'
手动从主mcnet切换至备mcnet_dg
CONNECT / AS SYSDBA ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;
关闭主mcnet数据库，挂载主数据库为“备”数据库工作
STARTUP NOMOUNT; ALTER DATABASE MOUNT STANDBY DATABASE; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
备数据库(mcnet_dg)执行接管操作
CONNECT / AS SYSDBA ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; SHUTDOWN IMMEDIATE; STARTUP;
切换回去的话，重启执行一遍，反方向。
主数据库故障手动切换操作
在备mcnet_dg数据库执行
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@mcnet_dg ~]$ lsnrctl start
[oracle@mcnet_dg ~]$ rman target sys/oracle36#^@mcnet auxiliary sys/oracle36#^@mcnet_dg
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/orapwmcnet' auxiliary format
'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwmcnet' ;
}
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/mcnet/control01.ctl';
restore clone controlfile to '/mnt/sdb1/oracleData/rman/control02.ctl' from
'/mnt/sdb1/oracleData/mcnet/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_mcnet.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/mcnet/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/mnt/sdb1/oracleData/mcnet/system01.dbf";
set newname for datafile 2 to
"/mnt/sdb1/oracleData/mcnet/sysaux01.dbf";
set newname for datafile 3 to
"/mnt/sdb1/oracleData/mcnet/undotbs01.dbf";
set newname for datafile 4 to
"/mnt/sdb1/oracleData/mcnet/users01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/mnt/sdb1/oracleData/mcnet/system01.dbf" datafile
2 auxiliary format
"/mnt/sdb1/oracleData/mcnet/sysaux01.dbf" datafile
3 auxiliary format
"/mnt/sdb1/oracleData/mcnet/undotbs01.dbf" datafile
4 auxiliary format
"/mnt/sdb1/oracleData/mcnet/users01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /mnt/sdb1/oracleData/mcnet/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/mcnet/system01.dbf
output file name=/mnt/sdb1/oracleData/mcnet/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/mcnet/sysaux01.dbf
output file name=/mnt/sdb1/oracleData/mcnet/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/mcnet/undotbs01.dbf
output file name=/mnt/sdb1/oracleData/mcnet/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/mcnet/users01.dbf
output file name=/mnt/sdb1/oracleData/mcnet/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/mcnet/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=916623257 file name=/mnt/sdb1/oracleData/mcnet/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=916623257 file name=/mnt/sdb1/oracleData/mcnet/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=916623257 file name=/mnt/sdb1/oracleData/mcnet/users01.dbf
Finished Duplicate Db at 08-JUL-16
Troubleshooting
ora 01666
control file is for a standby database - failover over standby as primary
http://facedba.blogspot.com/2015/06/ora-01666-control-file-is-for-standby.html
http://oracleinaction.com/recover-standby-datafile-primary/
copy controlfile from localdisk to asm
asmcmd cp /tmp/file +GOPOS_DATA/test
ORA 01624
SQL> alter database clear logfile group 2; alter database clear logfile group 2 * ERROR at line 1: ORA-01624: ��־ 2 �ǽï¿ï¿½Ö¸ï¿½Êµï¿½ï¿½ mcnet (�߳� 1) ������ ORA-00312: �����־ 2 �߳� 1: '+GOPOS_REDO/mcnet/onlinelog/group_2.268.918342065' SQL> alter system checkpoint; SQL> alter database clear logfile group 2;
ORA 01378
ORA-01378: The logical block size (4096) of file +GOPOS_REDO is not compatible with the disk sector size (media sector size is 512 and host sector size is 512) # The Resolve is: SQL> alter system set "_disk_sector_size_override"=TRUE scope=both;
TNS-01189: The listener could not authenticate the user
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
auxiliary duplicate error
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ORA-00600: internal error code, arguments: [kfdskAlloc0], [], [], [], [], [], [], [], [], [], [], []
/u01/app/11.2.0/grid/bin [grid@mcnet_dg bin]$ ./setasmgidwrap -o oracle
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.
- Note that the FAL_CLIENT parameter is deprecated in 11g and not needed.
ORA-01665: control file is not a standby control file
SQL> STARTUP MOUNT ORACLE instance started. … Database mounted. SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; ERROR at line 1: ORA-01665: control file is not a standby control file SQL> SELECT database_role FROM v$database; DATABASE_ROLE —————- PRIMARY SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY; Database altered. SQL> STARTUP MOUNT ORACLE instance started. … Database mounted. SQL> SELECT database_role FROM v$database; DATABASE_ROLE —————- PHYSICAL STANDBY SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; Database altered.
ORA 16139
1:alter database recover managed standby database finish; 2:alter database commit to switchover to physical primary; 3:shutdown 4:startup 5:stop listener to point to crashed db primary and point it to standby and restart. 6:try to connect as user@to_primary
https://community.oracle.com/thread/315787?start=0&tstart=0
ORA-00328
ORA-00283: recovery session canceled due to errors ORA-00328: archived log ends at change 1019342, need later change 1050270 ORA-00334: archived log: '+GOPOS_ARCH/mcnet_dg/archivelog/2016_07_21/thread_1_seq_18.263.917821673'
Metalink ID: 864364.1
1-Run the following query to determine the needed logfile SQL> select name, thread#, sequence#, archived, applied, status from v$archived_log \ where 1050270 between FIRST_CHANGE# and NEXT_CHANGE#; 2-Recopy the logfile from the primary to the standby server 3-Register the logfile SQL> alter database register or replace logfile '</absolute path/archive log file name>'; 4-start media recovery SQL> alter database recover automatic managed standby database disconnect from session;
alert failed to establish dependency between database and diskgroup
ALTER DISKGROUP "GOWSM_ARCH" CHECK ALL;
select instance_name,db_name,status from v$asm_client;
tail -f alert+ASM.log
ERROR: failed to establish dependency between database mcnet_dg and diskgroup resource ora.GOPOS_ARCH.dg
This error is harmless.
It is documented in the internal Bug 8304720 "ERROR: FAILED TO ESTABLISH DEPENDENCY BETWEEN DB & DISKGROUP"
"The db-dg dependency will be created later on if the diskgroup is used by the db again; the dependency can also be created manually through cmdline tool. Automatically it will resolve itself later on when the db tries to use the diskgroup. Or we can manually establish the dependancy through any command line utility."
Doc ID 1474954.1
ORA-01153: an incompatible media recovery is active
This indicates that currently running media recovery process i.e. standby active SQL> alter database recover managed standby database cancel; --- Cancel first Database altered. SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; Database altered.
NOTE: ASM client mcnet:mcnet disconnected unexpectedly.
just note
drop database
1- Export database SID if not yet Already defined export ORACLE_SID=database 2- Connect as sysdba [oracle@Oracle11 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 1 17:38:02 2014 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. 3- Start The database SQL> startup ORACLE instance started. Total System Global Area 3340451840 bytes Fixed Size 2217952 bytes Variable Size 1828718624 bytes Database Buffers 1493172224 bytes Redo Buffers 16343040 bytes Database mounted. Database opened. 4- Shutdown the database SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. 5- Start in Exclusive mode SQL> startup mount exclusive restrict ORACLE instance started. Total System Global Area 3340451840 bytes Fixed Size 2217952 bytes Variable Size 1828718624 bytes Database Buffers 1493172224 bytes Redo Buffers 16343040 bytes Database mounted. 6- Drop the database SQL> drop database; Database dropped.
Database mount ID mismatch
tabopen RFS[5]: Assigned to RFS process 22536 RFS[5]: Database mount ID mismatch [0x9c16d303:0x9c16a0a9] (2618741507:2618728617) RFS[5]: Not using real application clusters Fri Jul 22 22:32:38 2016 PING[ARC2]: Heartbeat failed to connect to standby 'mcnet_dg'. Err
col DESTINATION format a35 col ERROR format a65 set lines 130 set pages 100 SELECT DESTINATION, ERROR FROM V$ARCHIVE_DEST;
ORA-01665: control file is not a standby control file
https://odenysenko.wordpress.com/2012/07/02/quick-solution-for-ora-01665/
TEST
mcnet_dg
SQL> STARTUP; ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 4.9840E+10 bytes Fixed Size 2264776 bytes Variable Size 2.5770E+10 bytes Database Buffers 2.4025E+10 bytes Redo Buffers 42663936 bytes Database mounted. Database opened. SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE --------- -------------------- ---------------- GOPOS READ ONLY PHYSICAL STANDBY SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION; Database altered. SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE --------- -------------------- ---------------- GOPOS READ ONLY WITH APPLY PHYSICAL STANDBY SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE --------- -------------------- ---------------- GOPOS READ ONLY WITH APPLY PHYSICAL STANDBY SQL> select message from v$dataguard_status; MESSAGE -------------------------------------------------------------------------------- ARC0: Archival started ARC1: Archival started ARC2: Archival started ARC3: Archival started ARC4: Archival started ARC5: Archival started ARC6: Archival started ARC7: Archival started ARC8: Archival started ARC9: Archival started ARCa: Archival started MESSAGE -------------------------------------------------------------------------------- ARCb: Archival started ARCc: Archival started ARCd: Archival started ARCe: Archival started ARCf: Archival started ARCg: Archival started ARCh: Archival started ARCi: Archival started ARCj: Archival started ARCk: Archival started ARCl: Archival started MESSAGE -------------------------------------------------------------------------------- ARCm: Archival started ARCn: Archival started ARCo: Archival started ARCp: Archival started ARCq: Archival started ARCr: Archival started ARCs: Archival started ARC1: Becoming the 'no FAL' ARCH ARC2: Becoming the heartbeat ARCH ARC2: Becoming the active heartbeat ARCH ARCt: Archival started MESSAGE -------------------------------------------------------------------------------- Attempt to start background Managed Standby Recovery process MRP0: Background Managed Standby Recovery process started Managed Standby Recovery not using Real Time Apply Media Recovery Waiting for thread 1 sequence 22 RFS[1]: Assigned to RFS process 30784 RFS[2]: Assigned to RFS process 30787 RFS[3]: Assigned to RFS process 30789 ARC1: Beginning to archive thread 1 sequence 24 (1384796-1385180) Primary database is in MAXIMUM PERFORMANCE mode Re-archiving standby log 10 thread 1 sequence 24 RFS[4]: Assigned to RFS process 30791 MESSAGE -------------------------------------------------------------------------------- ARC1: Completed archiving thread 1 sequence 24 (0-0) ARC4: Beginning to archive thread 1 sequence 22 (1015024-1384520) ARC4: Completed archiving thread 1 sequence 22 (0-0) Media Recovery Log +GOPOS_ARCH/mcnet_dg/archivelog/2016_07_26/thread_1_seq_22.29 6.918240807 Media Recovery Log +GOPOS_ARCH/mcnet_dg/archivelog/2016_07_26/thread_1_seq_23.29 4.918240803 Media Recovery Log +GOPOS_ARCH/mcnet_dg/archivelog/2016_07_26/thread_1_seq_24.29 5.918240807 MESSAGE -------------------------------------------------------------------------------- Media Recovery Waiting for thread 1 sequence 25 (in transit) 51 rows selected.
mcnet
SQL> select message from v$dataguard_status; MESSAGE -------------------------------------------------------------------------------- ARC0: Archival started ARC1: Archival started ARC2: Archival started ARC3: Archival started ARC4: Archival started ARC5: Archival started ARC6: Archival started ARC7: Archival started ARC8: Archival started ARC9: Archival started ARCa: Archival started MESSAGE -------------------------------------------------------------------------------- ARCb: Archival started ARCc: Archival started ARCd: Archival started ARCe: Archival started ARCf: Archival started ARCg: Archival started ARCh: Archival started ARCi: Archival started ARCj: Archival started ARCk: Archival started ARCl: Archival started MESSAGE -------------------------------------------------------------------------------- ARCm: Archival started ARCn: Archival started ARCo: Archival started ARCp: Archival started ARCq: Archival started ARCr: Archival started ARCs: Archival started ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH ARC2: Becoming the heartbeat ARCH Error 1034 received logging on to the standby MESSAGE -------------------------------------------------------------------------------- PING[ARC2]: Heartbeat failed to connect to standby 'mcnet_dg'. Error is 1034. ARCl: Beginning to archive thread 1 sequence 22 (1015024-1384520) ARCl: Completed archiving thread 1 sequence 22 (1015024-1384520) ARCt: Archival started Error 1034 received logging on to the standby FAL[server, ARC3]: Error 1034 creating remote archivelog file 'mcnet_dg' ARC4: Beginning to archive thread 1 sequence 23 (1384520-1384796) ARC4: Completed archiving thread 1 sequence 23 (1384520-1384796) ARC6: Standby redo logfile selected for thread 1 sequence 22 for destination LOG _ARCHIVE_DEST_2 MESSAGE -------------------------------------------------------------------------------- ARC9: Beginning to archive thread 1 sequence 24 (1384796-1385180) ARC9: Completed archiving thread 1 sequence 24 (1384796-1385180) ARCa: Standby redo logfile selected for thread 1 sequence 24 for destination LOG _ARCHIVE_DEST_2 LNS: Standby redo logfile selected for thread 1 sequence 25 for destination LOG_ ARCHIVE_DEST_2 LNS: Beginning to archive log 7 thread 1 sequence 25 47 rows selected. SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE --------- -------------------- ---------------- GOPOS READ WRITE PRIMARY
Rebuild standby REDO
SELECT GROUP#, BYTES, 'ONLINE' AS TYPE FROM V$LOG UNION SELECT GROUP#, BYTES, 'STANDBY' AS TYPE FROM V$STANDBY_LOG ORDER BY 1;
1. Stop the log transport from the primary.
SQL> alter system set log_archive_dest_state_2 = defer scope = memory;
System altered.
2. Stop the recover from the standby databas.
SQL> alter database recover managed standby database cancel;
Database altered.
3. Verify that you are not getting the data in standby by doing the logswitch in primry.
SQL> select thread#,max(sequence#) from v$archived_log group by thread#;
4. Drop the standby redologs in the standby and primary (for the switchover purpose).
SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 4;
Database altered.
SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 5;
Database altered.
SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 6;
Database altered.
SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 7;
Database altered.
same in primary.
5. Recreate the stnadby redologs.
SQL> alter database add standby logfile THREAD 1 group 4 ('/opt/app/oracle/11.2.0.2/A13db/oradata/dg1/dg1_standby_redo01.log') size 100m;
Database altered.
SQL> alter database add standby logfile THREAD 1 group 5 ('/opt/app/oracle/11.2.0.2/A13db/oradata/dg1/dg1_standby_redo02.log') size 100m;
Database altered.
SQL> alter database add standby logfile THREAD 1 group 6 ('/opt/app/oracle/11.2.0.2/A13db/oradata/dg1/dg1_standby_redo03.log') size 100m;
Database altered.
SQL> alter database add standby logfile THREAD 1 group 7
2 ('/opt/app/oracle/11.2.0.2/A13db/oradata/dg1/dg1_standby_redo04.log') size 100m;
6. Enable the log transport from the primary database.
SQL> alter system set log_archive_dest_state_2 = enable scope = both;
System altered.
7. Start the managed recovery from the standby database.
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
8. Check the status of the standby redologs
SQL> select GROUP#,BYTES/1024/1024/1024 , STATUS, FIRST_TIME,NEXT_TIME from v$standby_log;
GROUP# BYTES/1024/1024/1024 STATUS FIRST_TIME NEXT_TIME
---------- -------------------- ---------- -------------------- --------------------
4 .09765625 ACTIVE 03-OCT-2012 02:45:11 03-OCT-2012 02:45:49
5 .09765625 UNASSIGNED
6 .09765625 UNASSIGNED
7 .09765625 UNASSIGNED
SQL> /
GROUP# BYTES/1024/1024/1024 STATUS FIRST_TIME NEXT_TIME
---------- -------------------- ---------- -------------------- --------------------
4 .09765625 ACTIVE 03-OCT-2012 02:45:11 03-OCT-2012 02:49:09
5 .09765625 UNASSIGNED
6 .09765625 UNASSIGNED
7 .09765625 UNASSIGNED
Its active , so RFS attached the standby redologs now. Let's verify the verbose once again to see if the gap has been resolved-
DGMGRL> show database verbose dg1_b
Database - dg1_b
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: OFF
Instance(s):
dg1
Properties:
DGConnectIdentifier = 'dg1_b'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '10'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '30'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = 'dg1_b, dg1_a'
LogFileNameConvert = 'dg1_b, dg1_a'
FastStartFailoverTarget = 'dg1_a'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'dg1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg2.amazon.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dg1_b_DGMGRL.amazon.com)(INSTANCE_NAME=dg1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
NFS unix
DBserverB#[/]mount -F nfs -o vers=4 192.168.1.246:/mnt/nfs /expdp DBserverB#[/]nfsstat -m /expdp from 192.168.1.246:/mnt/nfs Flags: vers=4,proto=tcp,sec=sys,hard,intr,link,symlink,acl,devs,rsize=32768,wsize=32768,retrans=5,timeo=600 Attr cache: acregmin=3,acregmax=60,acdirmin=30,acdirmax=60
windows expdp issue
C:\Users\Administrator>expdp hd40/ayyhouse9219pos tables=goods directory=dumpdi dumpfile=expdp_tables_goods.dmp logfile=expdp_goods.log Export: Release 10.2.0.5.0 - 64bit Production on 星期四, 05 7月, 2018 15:53:00 Copyright (c) 2003, 2007, Oracle. All rights reserved. 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Produ tion With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39002: 操作无效 ORA-39070: 无法打开日志文件。 ORA-29283: 文件操作无效 ORA-06512: 在 "SYS.UTL_FILE", line 536 ORA-29283: 文件操作无效 SQL> create or replace directory dumpdir as '\\192.168.1.240\ayyhousedb\expdp\expdp'; C:\Users\Administrator>expdp hd40/ayyhouse9219pos tables=goods directory=dumpdi dumpfile=expdp_tables_goods.dmp logfile=expdp_goods.log Export: Release 10.2.0.5.0 - 64bit Production on 星期四, 05 7月, 2018 15:57:00 Copyright (c) 2003, 2007, Oracle. All rights reserved. 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Produ tion With the Partitioning, OLAP, Data Mining and Real Application Testing options 启动 "HD40"."SYS_EXPORT_TABLE_01": hd40/******** tables=goods directory=dumpdi dumpfile=expdp_tables_goods.dmp logfile=expdp_goods.log 正在使用 BLOCKS 方法进行估计... 处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA 使用 BLOCKS 方法的总估计: 29 MB 处理对象类型 TABLE_EXPORT/TABLE/TABLE 处理对象类型 TABLE_EXPORT/TABLE/INDEX/INDEX 处理对象类型 TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT 处理对象类型 TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS 处理对象类型 TABLE_EXPORT/TABLE/COMMENT 处理对象类型 TABLE_EXPORT/TABLE/TRIGGER 处理对象类型 TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS . . 导出了 "HD40"."GOODS" 14.59 MB 21441 行 已成功加载/卸载了主表 "HD40"."SYS_EXPORT_TABLE_01" ****************************************************************************** HD40.SYS_EXPORT_TABLE_01 的转储文件集为: \\192.168.1.240\AYYHOUSEDB\EXPDP\EXPDP\EXPDP_TABLES_GOODS.DMP 作业 "HD40"."SYS_EXPORT_TABLE_01" 已于 15:57:19 成功完成 C:\Users\Administrator>
AYYHOUSEDB rman backup script
spool log to c:\rman_backup-2018-07-05.log;
set echo on;
RUN{
ALLOCATE CHANNEL C1 TYPE DISK;
ALLOCATE CHANNEL C2 TYPE DISK;
ALLOCATE CHANNEL C3 TYPE DISK;
ALLOCATE CHANNEL C4 TYPE DISK;
ALLOCATE CHANNEL C5 TYPE DISK;
ALLOCATE CHANNEL C6 TYPE DISK;
ALLOCATE CHANNEL C7 TYPE DISK;
ALLOCATE CHANNEL C8 TYPE DISK;
backup as compressed backupset filesperset 2 database format '\\192.168.1.240\ayyhousedb\expdp\expdp\%d_set%s_piece%p_%T_%U';
backup as compressed backupset current controlfile format '\\192.168.1.240\ayyhousedb\expdp\expdp\controlfile_%d_set%s_piece%p_%T_%U';
RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
RELEASE CHANNEL C3;
RELEASE CHANNEL C4;
RELEASE CHANNEL C5;
RELEASE CHANNEL C6;
RELEASE CHANNEL C7;
RELEASE CHANNEL C8;
}
spool log off;
AYYHOUSEDB rman delete expired script
allocate channel for maintenance device TYPE "SBT_TAPE"; report obsolete; crosscheck backup; delete noprompt obsolete; delete noprompt expired backup; list backup summary; release channel;
FILE# NAME
--------- ------------------------------------------------------------
1 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\SYSTEM01.DBF
2 E:\AYYHOUSEDB\HDAPP41.DBF
3 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\SYSAUX01.DBF
4 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\USERS01.DBF
5 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP01.DBF
6 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP02.DBF
7 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP03.DBF
8 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP04.DBF
9 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP05.DBF
10 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP06.DBF
11 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPPSETTLE01.DB
FILE# NAME
--------- ------------------------------------------------------------
F
12 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPPQRY01.DBF
13 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP07.DBF
14 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP08.DBF
15 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP09.DBF
16 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP10.DBF
17 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP11.DBF
18 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP12.DBF
19 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP13.DBF
20 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP14.DBF
FILE# NAME
--------- ------------------------------------------------------------
21 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP15.DBF
22 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP16.DBF
23 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP17.DBF
24 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP18.DBF
25 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP19.DBF
26 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP20.DBF
27 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP21.DBF
28 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP22.DBF
29 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\HDAPP23.DBF
30 E:\AYYHOUSEDB\HDAPP24.DBF
31 E:\AYYHOUSEDB\HDAPP25.DBF
FILE# NAME
--------- ------------------------------------------------------------
32 E:\AYYHOUSEDB\HDAPP26.DBF
33 E:\AYYHOUSEDB\HDAPP27.DBF
34 E:\AYYHOUSEDB\HDAPP28.DBF
35 E:\AYYHOUSEDB\HDAPP29.DBF
36 E:\AYYHOUSEDB\HDAPP30.DBF
37 E:\AYYHOUSEDB\HDAPP31.DBF
38 E:\AYYHOUSEDB\HDAPP32.DBF
39 E:\AYYHOUSEDB\HDAPP33.DBF
40 E:\AYYHOUSEDB\HDAPP34.DBF
41 E:\AYYHOUSEDB\HDAPP35.DBF
42 E:\AYYHOUSEDB\HDAPP36.DBF
FILE# NAME
--------- ------------------------------------------------------------
43 E:\AYYHOUSEDB\HDAPP37.DBF
44 E:\AYYHOUSEDB\HDAPP38.DBF
45 E:\AYYHOUSEDB\HDAPP39.DBF
46 E:\AYYHOUSEDB\UNDOTBS201.DBF
47 E:\AYYHOUSEDB\HDAPP40.DBF
48 E:\AYYHOUSEDB\HDAPP42.DBF
49 E:\AYYHOUSEDB\HDAPP43.DBF
50 E:\AYYHOUSEDB\HDAPP44.DBF
51 E:\AYYHOUSEDB\HDAPP45.DBF
52 E:\AYYHOUSEDB\HDAPP46.DBF
53 E:\AYYHOUSEDB\HDAPP47.DBF
FILE# NAME
--------- ------------------------------------------------------------
54 E:\AYYHOUSEDB\HDAPP48.DBF
55 E:\AYYHOUSEDB\HDAPP49.DBF
56 E:\AYYHOUSEDB\HDAPP50.DBF
57 E:\AYYHOUSEDB\HDAPP51.DBF
58 E:\AYYHOUSEDB\HDAPP52.DBF
59 E:\AYYHOUSEDB\HDAPP53.DBF
60 E:\AYYHOUSEDB\HDAPP54.DBF
61 E:\AYYHOUSEDB\HDAPP55.DBF
62 E:\AYYHOUSEDB\HDAPP56.DBF
63 E:\AYYHOUSEDB\HDAPP57.DBF
64 E:\AYYHOUSEDB\HDAPP58.DBF
FILE# NAME
--------- ------------------------------------------------------------
65 E:\AYYHOUSEDB\HDAPP59.DBF
66 E:\AYYHOUSEDB\HDAPP60.DBF
67 E:\AYYHOUSEDB\HDAPP61.DBF
68 E:\AYYHOUSEDB\HDAPP62.DBF
69 E:\AYYHOUSEDB\HDAPP63.DBF
70 E:\AYYHOUSEDB\HDAPP64.DBF
71 E:\AYYHOUSEDB\HDAPP65.DBF
72 D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\AYYHOUSEPOS
73 E:\AYYHOUSEDB\UNDOTBS202.DBF
74 E:\AYYHOUSEDB\UNDOTBS203.DBF
75 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\UNDOTBS204.DBF
FILE# NAME
--------- ------------------------------------------------------------
76 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\UNDOTBS205.DBF
77 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\UNDOTBS207.DBF
78 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\UNDOTBS206.DBF
79 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\UNDOTBS208.DBF
80 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\UNDOTBS209.DBF
81 D:\ORACLE\PRODUCT\10.2.0\ORADATA\AYYHOUSEDB\UNDOTBS210.DBF
已选择81行。
SQL> select job_name,state from dba_datapump_jobs;
JOB_NAME STATE
------------------------------ ------------------------------
SYS_IMPORT_SCHEMA_01 EXECUTING
SYS_EXPORT_SCHEMA_01 NOT RUNNING
SQL> select job_name,state from dba_datapump_jobs;
JOB_NAME STATE
------------------------------ ------------------------------
SYS_EXPORT_SCHEMA_01 NOT RUNNING