Exadata和普通的pc server的dataguard配置（VM）
来源：互联网 发布：淘宝兼职视频 编辑：程序博客网 时间：2024/05/01 03:56
比较简单，不说明了
alter database force logging;
*.audit_file_dest='/u01/app/oracle/admin/xdbvm/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='+DATA/xdbvm/controlfile/current.256.800956065','+RECO/xdbvm/controlfile/current.256.800956073'
*.db_block_size=8192
*.db_cache_size=104857600
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='xdbvm'
*.db_recovery_file_dest='+RECO'
*.db_recovery_file_dest_size=964689920
*.diagnostic_dest='/u01/app/oracle'
*.java_pool_size=10485760
*.large_pool_size=10485760
*.open_cursors=300
*.pga_aggregate_target=52428800
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=314572800
*.undo_tablespace='UNDOTBS1'
修改主库（xd）参数：
--alter system set db_unique_name ='xdbvm';
alter system set log_archive_config='DG_CONFIG=(xdbvm,xdbvms)';
alter system set log_archive_dest_1='location=+RECO/xdbvm/archive/arch1 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=xdbvm';
alter system set log_archive_dest_2='SERVICE=xdbvms LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=xdbvms';
alter system set log_archive_dest_state_1= enable;
alter system set log_archive_dest_state_2= enable;
alter system set fal_server=xdbvms;
alter system set fal_client=xdbvmp;
alter system set standby_file_management=auto;
在xd上asmcmd中创建：
ASMCMD> ls
CONTROLFILE/
ONLINELOG/
ASMCMD> pwd
+reco/XDBVM
ASMCMD> mkdir +RECO/xdbvm/archive
ASMCMD> mkdir +RECO/xdbvm/archive/arch1
alter system set log_archive_dest_1='location=+RECO/xdbvm/archive/arch1/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=xdbvm';
导致归档hang。。。。。
改为下面的解决问题：
alter system set log_archive_dest_1='location=+RECO/xdbvm/archive/arch1 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=xdbvm';
在主库添加standby redo log：
select group#,bytes/1024/1024 mb from v$log;
alter database add standby logfile group 4 size 50m;
alter database add standby logfile group 5 size 50m;
alter database add standby logfile group 6 size 50m;
alter database add standby logfile group 7 size 50m;
select group#,bytes/1024/1024 mb from v$standby_log;
--ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/u01/oradata/orcl/redo04.log') size 50M;
--ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ('/u01/oradata/orcl/redo05.log') SIZE 50M;
--ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ('/u01/oradata/orcl/redo06.log') SIZE 50M;
--ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 ('/u01/oradata/orcl/redo07.log') SIZE 50M;
测试主库连接：
[oracle@db1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
XDBVM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xdbvm)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
xdbvms=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.199)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xdbvms)
)
)
[oracle@db1 admin]$
[oracle@db1 admin]$ pwd
/u01/app/oracle/product/11.2.0/grid/network/admin
[oracle@db1 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
[oracle@db1 admin]$
[oracle@db1 admin]$ tnsping xdbvm
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 11-DEC-2012 05:16:25
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xdbvm)))
OK (10 msec)
[oracle@db1 admin]$
[oracle@db1 admin]$ tnsping xdbvms
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 11-DEC-2012 05:16:27
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.199)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xdbvm1)))
OK (0 msec)
[oracle@db1 admin]$
测试备库连接：
[oracle@ff admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.199)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
# (GLOBAL_DBNAME = ff.example.com) 这个如果不注释，会报错，sys用户无法登录
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = xdbvms)
)
)
[oracle@ff admin]$
[oracle@ff admin]$
[oracle@ff admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ff.example.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.example.com)
)
)
orclstb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lunar.example.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclstb.example.com)
)
)
XDBVM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.30)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xdbvm)
)
)
XDBVMS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.199)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xdbvms)
)
)
[oracle@ff admin]$
[oracle@ff admin]$ tnsping xdbvm
TNS Ping Utility for Linux: Version 11.2.0.0.2 - Beta on 11-DEC-2012 05:21:45
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.30)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xdbvm)))
OK (0 msec)
[oracle@ff admin]$
[oracle@ff admin]$ tnsping xdbvms
TNS Ping Utility for Linux: Version 11.2.0.0.2 - Beta on 11-DEC-2012 05:21:47
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.199)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xdbvms)))
OK (0 msec)
[oracle@ff admin]$
修改备库参数：
*.audit_file_dest='/u01/app/oracle/admin/xdbvms/adump'
*.audit_trail='none'
*.compatible='11.2.0.0.0'
*.control_files='/home/oracle/dgtest/datafile/currentfile01.ctl'
*.db_block_size=8192
*.db_cache_size=104857600
*.db_create_file_dest='/home/oracle/dgtest/datafile/'
*.db_domain=''
*.db_name='xdbvm'
*.db_recovery_file_dest='/home/oracle/dgtest/recovery_file_dest/'
*.db_recovery_file_dest_size=964689920
*.diagnostic_dest='/u01/app/oracle'
*.fal_client='XDBVMS'
*.fal_server='XDBVMP'
*.java_pool_size=10485760
*.large_pool_size=10485760
*.log_archive_config='DG_CONFIG=(xdbvms,xdbvm)'
*.log_archive_dest_1='location=/home/oracle/dgtest/archive/arch1 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=xdbvms'
*.log_archive_dest_2='SERVICE=xdbvms LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=xdbvms'
*.log_archive_dest_state_1='ENABLE'
*.open_cursors=300
*.pga_aggregate_target=52428800
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=314572800
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.DB_UNIQUE_NAME=xdbvms
*.db_file_name_convert ='+DATA/xdbvm/','/home/oracle/dgtest/datafile/'
*.log_file_name_convert ='+DATA/xdbvm/','/home/oracle/dgtest/datafile/'
在备库建立文件系统：
mkdir -p /u01/app/oracle/admin/xdbvms/adump
mkdir -p /home/oracle/dgtest/datafile
mkdir -p /home/oracle/dgtest/recovery_file_dest
mkdir -p /u01/app/oracle/diag/rdbms/xdbvms/xdbvms
mkdir -p /u01/app/oracle/diag/tnslsnr/xdbvms/listener
将主库的口令文件复制到备库：
[oracle@db1 dbs]$ scp orapwxdbvm 192.168.30.199:/tmp/orapwxdbvms
The authenticity of host '192.168.30.199 (192.168.30.199)' can't be established.
RSA key fingerprint is f0:06:34:85:6d:c9:ee:d7:77:9c:29:dc:c0:bf:c1:cd.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.30.199' (RSA) to the list of known hosts.
oracle@192.168.30.199's password:
orapwxdbvm 100% 1536 1.5KB/s 00:00
[oracle@db1 dbs]$
[oracle@ff ~]$ cp /tmp/orapwxdbvms $ORACLE_HOME/dbs/.
[oracle@ff ~]$
启动备库到nomount状态：
SQL> startup nomount pfile=/home/oracle/dgtest/initxdbvms.ora
ORACLE instance started.
Total System Global Area 451981312 bytes
Fixed Size 1343940 bytes
Variable Size 339742268 bytes
Database Buffers 104857600 bytes
Redo Buffers 6037504 bytes
SQL>
启动监听：
在主库：
rman
connect target sys/oracle@xdbvm
connect auxiliary sys/oracle@xdbvms
或者
rman target sys/oracle@xdbvm auxiliary sys/oracle@xdbvms
[oracle@db1 admin]$ rman target sys/oracle@xdbvm auxiliary sys/oracle@xdbvms
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Dec 11 08:19:53 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XDBVM (DBID=3426000219)
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.00 in AUXILIARY database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.00 in AUXILIARY database is not current
connected to auxiliary database: XDBVM (not mounted)
RMAN>
run{
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby from active database nofilenamecheck;
}
duplicate target database for standby from active database
spfile
parameter_value_convert 'xdbvm','xdbvms'
set db_unique_name='xdbvms'
set log_archive_max_processes='3'
set fal_client='xdbvms'
set fal_server='xdbvm'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(xdbvm,xdbvms)'
set log_archive_dest_2='service=xdbvm ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=xdbvm'
;
}
ls -lrt $ORACLE_HOME/rdbms/admin/dbmsrman.sql
ls -lrt $ORACLE_HOME/rdbms/admin/prvtrmns.plb
ls -lrt $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
ls -lrt $ORACLE_HOME/rdbms/admin/prvtbkrs.plb
[oracle@db1 admin]$ ls -lrt $ORACLE_HOME/rdbms/admin/dbmsrman.sql
ls -lrt $ORACLE_HOME/rdbms/admin/prvtrmns.plb
ls -lrt $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
ls -lrt $ORACLE_HOME/rdbms/admin/prvtbkrs.plb
-rw-r--r-- 1 oracle oinstall 148282 Aug 13 2009 /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/dbmsrman.sql
[oracle@db1 admin]$ ls -lrt $ORACLE_HOME/rdbms/admin/prvtrmns.plb
-rw-r--r-- 1 oracle oinstall 135310 Aug 13 2009 /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/prvtrmns.plb
[oracle@db1 admin]$ ls -lrt $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
-rw-r--r-- 1 oracle oinstall 333868 Aug 13 2009 /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/dbmsbkrs.sql
[oracle@db1 admin]$ ls -lrt $ORACLE_HOME/rdbms/admin/prvtbkrs.plb
-rw-r--r-- 1 oracle oinstall 36422 Aug 13 2009 /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/prvtbkrs.plb
[oracle@db1 admin]$
[oracle@db1 admin]$
[oracle@ff ~]$ ls -lrt $ORACLE_HOME/rdbms/admin/dbmsrman.sql
ls -lrt $ORACLE_HOME/rdbms/admin/prvtrmns.plb
ls -lrt $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
ls -lrt $ORACLE_HOME/rdbms/admin/prvtbkrs.plb
-rw-r--r-- 1 oracle oinstall 148259 Apr 24 2009 /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/dbmsrman.sql
[oracle@ff ~]$ ls -lrt $ORACLE_HOME/rdbms/admin/prvtrmns.plb
-rw-r--r-- 1 oracle oinstall 134990 Apr 24 2009 /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/prvtrmns.plb
[oracle@ff ~]$ ls -lrt $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
-rw-r--r-- 1 oracle oinstall 333986 Apr 24 2009 /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/dbmsbkrs.sql
[oracle@ff ~]$ ls -lrt $ORACLE_HOME/rdbms/admin/prvtbkrs.plb
-rw-r--r-- 1 oracle oinstall 36459 Apr 24 2009 /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/prvtbkrs.plb
[oracle@ff ~]$
[oracle@ff ~]$
mv $ORACLE_HOME/rdbms/admin/dbmsrman.sql.bak $ORACLE_HOME/rdbms/admin/dbmsrman.sql
mv $ORACLE_HOME/rdbms/admin/prvtrmns.plb.bak $ORACLE_HOME/rdbms/admin/prvtrmns.plb
mv $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql.bak $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
mv $ORACLE_HOME/rdbms/admin/prvtbkrs.plb.bak $ORACLE_HOME/rdbms/admin/prvtbkrs.plb
scp $ORACLE_HOME/rdbms/admin/dbmsrman.sql.bak 192.168.30.30:/u01/app/oracle/product/11.2.0/dbhome_1/dbmsrman.sql
scp $ORACLE_HOME/rdbms/admin/prvtrmns.plb.bak 192.168.30.30:/u01/app/oracle/product/11.2.0/dbhome_1/prvtrmns.plb
scp $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql.bak 192.168.30.30:/u01/app/oracle/product/11.2.0/dbhome_1/dbmsbkrs.sql
scp $ORACLE_HOME/rdbms/admin/prvtbkrs.plb.bak 192.168.30.30:/u01/app/oracle/product/11.2.0/dbhome_1/prvtbkrs.plb
mv /u01/app/oracle/product/11.2.0/dbhome_1/dbmsrman.sql $ORACLE_HOME/rdbms/admin/dbmsrman.sql
mv /u01/app/oracle/product/11.2.0/dbhome_1/prvtrmns.plb $ORACLE_HOME/rdbms/admin/prvtrmns.plb
mv /u01/app/oracle/product/11.2.0/dbhome_1/dbmsbkrs.sql $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
mv /u01/app/oracle/product/11.2.0/dbhome_1/prvtbkrs.plb $ORACLE_HOME/rdbms/admin/prvtbkrs.plb
ls -lrt $ORACLE_HOME/rdbms/admin/dbmsrman.sql
ls -lrt $ORACLE_HOME/rdbms/admin/prvtrmns.plb
ls -lrt $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
ls -lrt $ORACLE_HOME/rdbms/admin/prvtbkrs.plb
SQL> @$ORACLE_HOME/rdbms/admin/dbmsrman.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtrmns.plb
SQL> @$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtbkrs.plb
@$ORACLE_HOME/rdbms/admin/utlrp.sql
[oracle@db1 ~]$ rman target sys/oracle@xdbvm auxiliary sys/oracle@xdbvms
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Dec 11 08:53:37 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.00 in TARGET database is not current
connected to target database: XDBVM (DBID=3426000219)
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.00 in AUXILIARY database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.00 in AUXILIARY database is not current
connected to auxiliary database: XDBVM (not mounted)
RMAN>
[oracle@db1 ~]$ rman target sys/oracle@xdbvm auxiliary sys/oracle@xdbvms
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Dec 11 08:55:53 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XDBVM (DBID=3426000219)
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.00 in AUXILIARY database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.00 in AUXILIARY database is not current
connected to auxiliary database: XDBVM (not mounted)
RMAN>
BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT '/tmp/currentfile01.ctl';
scp /tmp/currentfile01.ctl 192.168.30.199:/home/oracle/dgtest/datafile/currentfile01.ctl
SQL> select 'alter tablespace '||name||' begin backup ;' from v$tablespace;
'ALTERTABLESPACE'||NAME||'BEGINBACKUP;'
--------------------------------------------------------------
alter tablespace SYSTEM begin backup ;
alter tablespace SYSAUX begin backup ;
alter tablespace UNDOTBS1 begin backup ;
alter tablespace TEMP begin backup ;
alter tablespace USERS begin backup ;
SQL>
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA/xdbvm/datafile/system.260.800956087
+DATA/xdbvm/datafile/sysaux.261.800956107
+DATA/xdbvm/datafile/undotbs1.262.800956125
+DATA/xdbvm/datafile/users.264.800956165
SQL>
cp +DATA/xdbvm/datafile/system.260.800956087 /tmp/system.dbf
cp +DATA/xdbvm/datafile/sysaux.261.800956107 /tmp/sysaux.dbf
cp +DATA/xdbvm/datafile/undotbs1.262.800956125 /tmp/undotbs1.dbf
cp +DATA/xdbvm/datafile/users.264.800956165 /tmp/users.dbf
scp /tmp/system.dbf 192.168.30.199:/home/oracle/dgtest/datafile/system.dbf
scp /tmp/sysaux.dbf 192.168.30.199:/home/oracle/dgtest/datafile/sysaux.dbf
scp /tmp/undotbs1.dbf 192.168.30.199:/home/oracle/dgtest/datafile/undotbs1.dbf
scp /tmp/users.dbf 192.168.30.199:/home/oracle/dgtest/datafile/users.dbf
SQL> select 'alter tablespace '||name||' end backup ;' from v$tablespace;
'ALTERTABLESPACE'||NAME||'ENDBACKUP;'
------------------------------------------------------------
alter tablespace SYSTEM end backup ;
alter tablespace SYSAUX end backup ;
alter tablespace UNDOTBS1 end backup ;
alter tablespace TEMP end backup ;
alter tablespace USERS end backup ;
SQL>
mv /home/oracle/dgtest/datafile/currentfile01.ctl /tmp/currentfile01.ctl
restore standby controlfile from '/tmp/currentfile01.ctl';
alter database mount;
- Exadata和普通的pc server的dataguard配置（VM）
- 服务器和普通PC的区别
- Java HotSpot Client VM 和 Java HotSpot Server VM的配置
- Java HotSpot Client VM 和 Java HotSpot Server VM的配置
- Java HotSpot Client VM 和 Java HotSpot Server VM的配置.
- Oracle 的dataguard配置
- 它是和Oracle Exadata PK的吗？
- dataguard windows下的配置
- Oracle Dataguard 的配置安装
- Dataguard配置参数的解释
- 虚拟机vm下ubuntu server 14.04的网络配置和SSH连接问题
- 关于Oracle Exadata Storage Server的Exafusion协议
- 我的Oracle Dataguard 和 RMAN duplicate 配置总结
- vm(vps)的普通应用方案
- Exadata的独门武器--卸载（Offloading）
- Exadata管理IO的方法（IORM）
- 最新的Exadata版本
- Exadata的onecommand
- 纯券过户(free of payment)
- Java私塾中级视频——Eclipse快捷键总结
- Linux /etc/profile文件详解
- 防止进程在内存耗尽时被OS选择性杀掉
- VS2010中使用AnkhSvn
- Exadata和普通的pc server的dataguard配置（VM）
- 初识onContentChanged()
- linux虚拟机(dos)
- Linux下的金山词霸 ----stardict（星际译王）
- gdb关于调试
- 明天的工作安排
- $.getJSON方法不调用回调函数
- phpv5 类参数说明
- 关于UIScrollViewDelegate协议中每个回调函数的意义及执行顺序的理解
