比较简单,不说明了
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;