RAC数据库DATAGUARD手册
●操作环境:
Primary database :RACDB 两节点为racdb1,racdb2 ORACLE Enterpresie Linux 5.3;Oracle 10.2.0.4;数据文件,spfile参数,归档日志文件存储系统ASM。
Standby databse :racdg ORACLE Enterpresie Linux 5.3;Oracle 10.2.0.4;
ext3文件系统;单实例。136********
第一步:确定主库启用归档模式
SQL> archive log list
如果没有启用归档,则:
SQL>conn /as sysdba
SQL > alter system set log_archive_dest_1 = "location=<文件位置>"
SQL > alter system set log_archive_format='arch_%t_%s_%r.arc' scope=spfile;
SQL > shutdown imm ediate
SQL> alter database archivelog;
Oracle 10中已经将log_archive_start 参数废弃,
在RAC下执行ALTER SYSTEM SET LOG_ARCHIVE_DEST_1语句,可以
加scope选项吗?我执行的时候加了scope不管是=memoryspfile,还是both,都报错,在网上搜了一下说不用scope语句即可,我执行了一下,果然可以了,而且和scope=both的效果一样
第二步:设置主库日志处理(每个节点都执行)
ALTER DATABASE FORCE LOGGING;
如果rac的节点数据库使用ASM等cluster文件系统存储spfile和controlfile等数据文件,
则没有必要在每个节点都执行。
第三步:备份主库
mkdir -p /backup/databackup/
chown -R oracle.oinstall /backup
●备份spfile文件
SQL> CREATE PFILE='/backup/databackup/initracdg.ora' FROM SPFILE;
●rman到处主库的数据文件及控制文件
rm an target /
RMAN> backup device type disk format '/backup/databackup/%U' database plus archivelog;
RMAN> backup device type disk format '/backup/databackup/%U' current controlfile for standby;
●将主库的listener.ora, tnsnam es.ora文件复制到/backup/databackup/
cd $ORACLE_HOME/network/admin/*.ora /backup/databackup/
第四步:在备库下建立数据库的文件存方目录
cd $ORACLE_BASE
mkdir -p adm in/rac/bdump
mkdir -p adm in/rac/cdum p
mkdir -p adm in/rac/udump
mkdir -p adm in/rac/adump
mkdir -p adm in/rac/dpdump
mkdir -p adm in/rac/hdump
第五步:将备份的数据从主库COPY到备库
●scp -rp /backup/databackup/* oracle@ip_racbk:/backup/databackup/
●将standby上的listener.ora, tnsnames.ora 拷贝到主机
scp –rp oracle@ip_racbk:$ORACLE_HOME/network/admin/*.ora $ORACLE_BASE
第六步:在备库上执行如下步骤
1.备机上合并listener.ora, tnsnames.ora
cat /backup/databackup/listener.ora >> $ORACLE_HOME/network/admin/listener.ora
cat /backup/databackup/tnsnames.ora >> $ORACLE_HOME/network/admin/tnsnames.ora
?Listener.ora 的内容如下:
SID_LIST_LISTENER_RAC1-ZQGAME =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racdbbk)(PORT = 1521)(IP = FIRST)) )
)
LISTENER_RAC1-ZQGAME =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip_node1)(PORT = 1521)(IP = FIRST)) )
)
INBOUND_CONNECT_TIMEOUT_LISTENER=0
注:并启动Listener
Tnsnames.ora的内容如下
# tnsnames.ora Network Configuration File: /opt/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RACDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip)(PORT = 1521))
(CONNECT_DA TA =
(SERVER = DEDICA TED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb1)
)
)
RACDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racdg)(PORT = 1521))
(CONNECT_DA TA =
(SERVER = DEDICA T ED)
(SERVICE_NAME = racdg)
)
RACDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip_node1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip_node2)(PORT = 1521)) (LOAD_BALANCE = yes)
(CONNECT_DA TA =
(SERVER = DEDICA TED)
(SERVICE_NAME = racdb)
)
)
LOCAL_LISTENER_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip_node1)(PORT = 1521)) )
LISTENERS_RACDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip_node1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip_node2)(PORT = 1521)) )
EXTPROC_CONNECTION_DA TA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DA TA =
(SID = PLSExtProc)
(PRESENTA TION = RO)
)
)
RACDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip_node2)(PORT = 1521)) (CONNECT_DA TA =
(SERVER = DEDICA TED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb2)
)
2.主机上合并listener.ora, tnsnames.ora(每个节点都执行)
cat $ORACLE_BASE/listener.ora >> $ORACLE_HOME/network/admin/listener.ora
cat $ORACLE_BASE/tnsnames.ora >> $ORACLE_HOME/network/admin/tnsnames.ora
?主库Listener.ora内容:
SID_LIST_LISTENER_RAC1-ZQGAME =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER_RAC1-ZQGAME =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST =rac1vip-zqgame)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = ip_node1)(PORT = 1521)(IP = FIRST))
)
)
INBOUND_CONNECT_TIMEOUT_LISTENER=0
LISTENER_ST D =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =ip_racbk)(PORT = 1521)(IP = FIRST))
)
)
?主库tnsnames.ora内容:
[oracle@rac1-zqgam e admin]$ more tnsnam es.ora
# tnsnam es.ora Network Configuration File: /opt/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
local_listener_rac =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip_node1)(PORT = 1521))
)
RACDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip-zqgam e)(PORT = 1521)) (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb1)
)
)
RACDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip-zqgam e)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip-zqgam e)(PORT = 1521)) (LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)
LISTENERS_RACDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip_node1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip_node2)(PORT = 1521))
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
RACDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip-zqgame)(PORT = 1521)) (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb2)
)
)
RACDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip_racbk)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdg)
)
)
3.备机上建立密码文件
cd $ORACLE_HOME/dbs
orapwd file=orapw$ORACLE_SID password=XXX entries=5
4.将spfie文件复制到$ORACLE_HOME/dbs下
cp /backup/databackup/standby.ora $ORACLE_HOME/dbs/initracdg.ora 5.修改其中参数,删除有关集群的参数并添加standby设置参数
[oracle@racdbbk dbs]$ m ore initracdg.ora.bak
*.audit_file_dest='/opt/app/oracle/admin/racdg/adump'
*.background_dump_dest='/opt/app/oracle/admin/racdg/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/oradata/racdg/controlfile/current.285.693877539','/oradata2/rac dg/controlfile/current.257.693877539'
*.core_dump_dest='/opt/app/oracle/admin/racdg/cdum p'
*.db_block_size=8192
*.db_create_file_dest='/oradata'
*.db_domain=''
*.db_file_multiblock_read_count=128
*.db_name='racdb'
*.db_recovery_file_dest_size=109890764800
*.db_recovery_file_dest='/recovery_area'
*.fal_client='RACDG'
*.fal_server='RACDB1','RACDB2'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(racdb,racdg)'
*.log_archive_dest_1='LOCATION=/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racdg'
*.log_archive_dest_2='SERVICE=RACDB1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdb'
*.log_archive_format='arch_%t_%s_%r.arc'
*.nls_language='SIMPLIFIED CHINESE'
*.open_cursors=5000
*.pga_aggregate_target=1073741824
*.processes=300
*.rem ote_login_passwordfile='exclusive'
*.sessions=335
*.sga_target=2147483648
*.standby_archive_dest='/arch'
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOT BS1'
*.user_dump_dest='/opt/app/oracle/admin/racdg/udump'
*.service_nam es='RACDG'
*.instance_nam e='racdg'
log_file_name_convert=('+FGDATA/racdb/onlinelog/', '/oradata/racdg/onlinelog/', '+FGDATA2/racdb/onlinelog/', '/oradata2/racdg/onlinelog/')
db_file_name_convert=('+FGDATA/racdb/datafile/', '/oradata/racdg/datafile/', '+FGDATA2/racdb/datafile/', '/oradata2/racdg/datafile/', '+FGDATA/racdb/tem pfile/','/oradata/racdg/tem pfile/')
6.建立spfile文件
export ORACLE_SID=racdg
sqlplus /nolog
SQL>conn /as sysdba
CREA TE SPFILE FROM PFILE = '$ORACLE_HOME/dbs/initracdg.ora'
7.导入数据到备数据库
sqlplus /nolog
SQL>conn /as sysdba
SQL> STARTUP NOMOUNT
rman target sys/XXX@RAC DB1 auxiliary /
RMAN> duplicate target database for standby;
操作过程如下:
restore not done; all files readonly, offline, or already restored
Finished restore at 12-8月-09
[oracle@racdbbk dbs]$ rman target sys/xx @RACDB1 auxiliary /
Recovery Manager: Release 10.2.0.4.0 - Production on 星期三8月12 10:17:04 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: RACDB (DBID=691494306)
connected to auxiliary database: RACDB (not m ounted)
RMAN>duplicate target database for standby;
Starting Duplicate Db at 12-8月-09
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=324 devtype=DISK
contents of Mem ory Script:
{
restore clone standby controlfile;
sql clone 'alter database m ount standby database';
}
executing Memory Script
Starting restore at 12-8月-09
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece
/backup/databackup/2rkm f94r_1_1
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/backup/databackup/2rkmf94r_1_1 tag=TAG20090812T003643 channel ORA_AUX_DISK_1: restore com plete, elapsed tim e: 00:00:01
output filename=/oradata/racdg/controlfile/current.285.693877539
output filename=/oradata/racdg/controlfile/current.257.693877539
Finished restore at 12-8月-09
sql statem ent: alter database m ount standby database
released channel: ORA_AUX_DISK_1
contents of Mem ory Script:
{
set newnam e for tem pfile 1 to
"/oradata/racdg/tem pfile/temp.313.693877545";
switch clone tem pfile all;
set newnam e for datafile 1 to
"/oradata/racdg/datafile/system.286.693877495";
set newnam e for datafile 2 to
"/oradata/racdg/datafile/undotbs1.289.693877495";
set newnam e for datafile 3 to
"/oradata/racdg/datafile/sysaux.290.693877495";
set newnam e for datafile 4 to
"/oradata/racdg/datafile/users.288.693877495";
set newnam e for datafile 5 to
"/oradata/racdg/datafile/undotbs2.312.693877563";
set newnam e for datafile 6 to
set newnam e for datafile 7 to
"/oradata/racdg/datafile/lobx_data01.dbf";
set newnam e for datafile 8 to
"/oradata/racdg/datafile/addmoney_data01.dbf"; set newnam e for datafile 9 to
"/oradata/racdg/datafile/assign_data01.dbf";
set newnam e for datafile 10 to
"/oradata/racdg/datafile/base_info01.dbf";
set newnam e for datafile 11 to
"/oradata/racdg/datafile/card_data01.dbf";
set newnam e for datafile 12 to
"/oradata/racdg/datafile/diccode_data01.dbf"; set newnam e for datafile 14 to
"/oradata/racdg/datafile/log_data01.dbf";
set newnam e for datafile 15 to
"/oradata/racdg/datafile/order_data01.dbf";
set newnam e for datafile 16 to
"/oradata/racdg/datafile/pass_data01.dbf";
set newnam e for datafile 17 to
"/oradata/racdg/datafile/user_data01.dbf";
set newnam e for datafile 18 to
"/oradata/racdg/datafile/account_kz01.dbf";
set newnam e for datafile 19 to
"/oradata/racdg/datafile/account_td01.dbf";
set newnam e for datafile 20 to
"/oradata/racdg/datafile/account_lj01.dbf";
set newnam e for datafile 21 to
"/oradata/racdg/datafile/account_zg01.dbf";
set newnam e for datafile 22 to
set newnam e for datafile 23 to
"/oradata/racdg/datafile/account_sg01.dbf"; set newnam e for datafile 24 to
"/oradata/racdg/datafile/account_kz02.dbf"; set newnam e for datafile 25 to
"/oradata/racdg/datafile/account_td02.dbf"; set newnam e for datafile 26 to
"/oradata/racdg/datafile/account_lj02.dbf"; set newnam e for datafile 27 to
"/oradata/racdg/datafile/account_zg02.dbf"; set newnam e for datafile 28 to
"/oradata/racdg/datafile/account_qq02.dbf"; set newnam e for datafile 29 to
"/oradata/racdg/datafile/account_sg02.dbf"; set newnam e for datafile 30 to
"/oradata/racdg/datafile/base_info02.dbf"; set newnam e for datafile 31 to
"/oradata/racdg/datafile/base_info03.dbf"; set newnam e for datafile 32 to
"/oradata/racdg/datafile/base_info04.dbf"; set newnam e for datafile 33 to
"/oradata/racdg/datafile/base_info05.dbf"; set newnam e for datafile 34 to
"/oradata/racdg/datafile/base_info06.dbf"; set newnam e for datafile 35 to
"/oradata/racdg/datafile/base_info07.dbf"; set newnam e for datafile 36 to
"/oradata/racdg/datafile/base_info08.dbf"; set newnam e for datafile 37 to
set newnam e for datafile 38 to
"/oradata/racdg/datafile/card_data04.dbf"; set newnam e for datafile 39 to
"/oradata/racdg/datafile/card_data03.dbf"; set newnam e for datafile 40 to
"/oradata/racdg/datafile/card_data05.dbf"; set newnam e for datafile 41 to
"/oradata/racdg/datafile/account_kz04.dbf"; set newnam e for datafile 44 to
"/oradata/racdg/datafile/order_data02.dbf"; set newnam e for datafile 45 to
"/oradata/racdg/datafile/order_data03.dbf"; set newnam e for datafile 46 to
"/oradata/racdg/datafile/order_data04.dbf"; set newnam e for datafile 47 to
"/oradata/racdg/datafile/pass_data02.dbf"; set newnam e for datafile 48 to
"/oradata/racdg/datafile/pass_data03.dbf"; set newnam e for datafile 49 to
"/oradata/racdg/datafile/pass_data04.dbf"; set newnam e for datafile 50 to
"/oradata/racdg/datafile/pass_data05.dbf"; set newnam e for datafile 55 to
"/oradata/racdg/datafile/history_data01.dbf"; set newnam e for datafile 56 to
"/oradata/racdg/datafile/history_data02.dbf"; set newnam e for datafile 57 to
"/oradata/racdg/datafile/history_data03.dbf"; set newnam e for datafile 58 to
set newnam e for datafile 59 to
"/oradata/racdg/datafile/history_data05.dbf";
set newnam e for datafile 60 to
"/oradata/racdg/datafile/history_data06.dbf";
set newnam e for datafile 61 to
"/oradata/racdg/datafile/history_data07.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
renamed temporary file 1 to /oradata/racdg/tempfile/tem p.313.693877545 in control file
executing command: SET NEWNAME
…
executing command: SET NEWNAME
Starting restore at 12-8月-09
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=324 devtype=DISK
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /oradata/racdg/datafile/system.286.693877495
restoring datafile 00002 to /oradata/racdg/datafile/undotbs1.289.693877495 restoring datafile 00003 to /oradata/racdg/datafile/sysaux.290.693877495 restoring datafile 00004 to /oradata/racdg/datafile/users.288.693877495 restoring datafile 00005 to /oradata/racdg/datafile/undotbs2.312.693877563 restoring datafile 00006 to /oradata/racdg/datafile/indx_data01.dbf restoring datafile 00007 to /oradata/racdg/datafile/lobx_data01.dbf restoring datafile 00008 to /oradata/racdg/datafile/addmoney_data01.dbf restoring datafile 00009 to /oradata/racdg/datafile/assign_data01.dbf restoring datafile 00010 to /oradata/racdg/datafile/base_info01.dbf restoring datafile 00011 to /oradata/racdg/datafile/card_data01.dbf restoring datafile 00012 to /oradata/racdg/datafile/diccode_data01.dbf restoring datafile 00014 to /oradata/racdg/datafile/log_data01.dbf
restoring datafile 00015 to /oradata/racdg/datafile/order_data01.dbf restoring datafile 00016 to /oradata/racdg/datafile/pass_data01.dbf restoring datafile 00017 to /oradata/racdg/datafile/user_data01.dbf restoring datafile 00018 to /oradata/racdg/datafile/account_kz01.dbf restoring datafile 00019 to /oradata/racdg/datafile/account_td01.dbf restoring datafile 00020 to /oradata/racdg/datafile/account_lj01.dbf restoring datafile 00021 to /oradata/racdg/datafile/account_zg01.dbf restoring datafile 00022 to /oradata/racdg/datafile/account_qq01.dbf restoring datafile 00023 to /oradata/racdg/datafile/account_sg01.dbf restoring datafile 00024 to /oradata/racdg/datafile/account_kz02.dbf restoring datafile 00025 to /oradata/racdg/datafile/account_td02.dbf restoring datafile 00026 to /oradata/racdg/datafile/account_lj02.dbf restoring datafile 00027 to /oradata/racdg/datafile/account_zg02.dbf restoring datafile 00028 to /oradata/racdg/datafile/account_qq02.dbf restoring datafile 00029 to /oradata/racdg/datafile/account_sg02.dbf restoring datafile 00030 to /oradata/racdg/datafile/base_info02.dbf restoring datafile 00031 to /oradata/racdg/datafile/base_info03.dbf restoring datafile 00032 to /oradata/racdg/datafile/base_info04.dbf
restoring datafile 00033 to /oradata/racdg/datafile/base_info05.dbf restoring datafile 00034 to /oradata/racdg/datafile/base_info06.dbf restoring datafile 00035 to /oradata/racdg/datafile/base_info07.dbf restoring datafile 00036 to /oradata/racdg/datafile/base_info08.dbf restoring datafile 00037 to /oradata/racdg/datafile/card_data02.dbf restoring datafile 00038 to /oradata/racdg/datafile/c ard_data04.dbf restoring datafile 00039 to /oradata/racdg/datafile/card_data03.dbf restoring datafile 00040 to /oradata/racdg/datafile/card_data05.dbf restoring datafile 00041 to /oradata/racdg/datafile/account_kz04.dbf restoring datafile 00044 to /oradata/racdg/datafile/order_data02.dbf restoring datafile 00045 to /oradata/racdg/datafile/order_data03.dbf restoring datafile 00046 to /oradata/racdg/datafile/order_data04.dbf restoring datafile 00047 to /oradata/racdg/datafile/pass_data02.dbf restoring datafile 00048 to /oradata/racdg/datafile/pass_data03.dbf restoring datafile 00049 to /oradata/racdg/datafile/pass_data04.dbf restoring datafile 00050 to /oradata/racdg/datafile/pass_data05.dbf restoring datafile 00055 to /oradata/racdg/datafile/history_data01.dbf restoring datafile 00056 to /oradata/racdg/datafile/history_data02.dbf restoring datafile 00057 to /oradata/racdg/datafile/history_data03.dbf restoring datafile 00058 to /oradata/racdg/datafile/history_data04.dbf restoring datafile 00059 to /oradata/racdg/datafile/history_data05.dbf restoring datafile 00060 to /oradata/racdg/datafile/history_data06.dbf restoring datafile 00061 to /oradata/racdg/datafile/history_data07.dbf channel ORA_AUX_DISK_1: reading from backup piece
/backup/databackup/2okmf8v1_1_1
不小心按了Ctl +C
User interrupt received 后来发现:原来导入的数据量在减少
user interrupt received
RMAN-00571:
================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
================================================== =========
RMAN-03002: failure of Duplicate Db command at 08/12/2009 10:43:34
RMAN-03015: error occurred in stored script Mem ory Script
RMAN-03099: job cancelled at user request
[root@racdbbk databackup]# df
Filesystem1K-blocks Used Available Use% Mounted on
/dev/sda2 139034156 41314336 90543184 32% /
/dev/sdb1 123164768 384492 116422956 1% /arch
/dev/sda1 101086 20932 74935 22% /boot
tmpfs 8245844 0 8245844 0% /dev/shm
/dev/sdc1 673850308 49699148 589921468 8% /oradata
/dev/sdc2 334078716 403612 316704844 1% /recovery_area /dev/sdd1 1007930816 204364 956526496 1% /oradata2 [root@racdbbk databackup]# df
Filesystem1K-blocks Used Available Use% Mounted on
/dev/sda2 139034156 41314524 90542996 32% /
/dev/sdb1 123164768 384492 116422956 1% /arch
/dev/sda1 101086 20932 74935 22% /boot
tmpfs 8245844 0 8245844 0% /dev/shm
/dev/sdc1 673850308 22734996 616885620 4% /oradata
/dev/sdc2 334078716 403612 316704844 1% /recovery_area /dev/sdd1 1007930816 204364 956526496 1% /oradata2
需要
RMAN> exit;
Sqlplus nolog/ as sysdba
Shutdown immediate;
Startup nom ount;
RMA恢复过程中,自动mount standby database
Starting restore at 12-8月-09
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=321 devtype=DISK
skipping datafile 1; already restored to file
/oradata/racdg/datafile/system.286.693877495
skipping datafile 2; already restored to file
/oradata/racdg/datafile/undotbs1.289.693877495
skipping datafile 3; already restored to file
/oradata/racdg/datafile/sysaux.290.693877495
skipping datafile 4; already restored to file
/oradata/racdg/datafile/users.288.693877495
skipping datafile 5; already restored to file
/oradata/racdg/datafile/undotbs2.312.693877563
skipping datafile 6; already restored to file /oradata/racdg/datafile/indx_data01.dbf skipping datafile 7; already restored to file /oradata/racdg/datafile/lobx_data01.dbf skipping datafile 8; already restored to file
/oradata/racdg/datafile/addmoney_data01.dbf
skipping datafile 9; already restored to file
/oradata/racdg/datafile/assign_data01.dbf
skipping datafile 10; already restored to file
/oradata/racdg/datafile/base_info01.dbf
skipping datafile 11; already restored to file
/oradata/racdg/datafile/card_data01.dbf
/oradata/racdg/datafile/diccode_data01.dbf
skipping datafile 14; already restored to file /oradata/racdg/datafile/log_data01.dbf skipping datafile 15; already restored to file
/oradata/racdg/datafile/order_data01.dbf
skipping datafile 16; already restored to file
/oradata/racdg/datafile/pass_data01.dbf
skipping datafile 17; already restored to file
/oradata/racdg/datafile/user_data01.dbf
skipping datafile 18; already restored to file
/oradata/racdg/datafile/account_kz01.dbf
skipping datafile 19; already restored to file
/oradata/racdg/datafile/account_td01.dbf
skipping datafile 20; already restored to file
/oradata/racdg/datafile/account_lj01.dbf
skipping datafile 21; already restored to file
/oradata/racdg/datafile/account_zg01.dbf
skipping datafile 22; already restored to file
/oradata/racdg/datafile/account_qq01.dbf
skipping datafile 23; already restored to file
/oradata/racdg/datafile/account_sg01.dbf
skipping datafile 24; already restored to file
/oradata/racdg/datafile/account_kz02.dbf
skipping datafile 25; already restored to file
/oradata/racdg/datafile/account_td02.dbf
skipping datafile 26; already restored to file
/oradata/racdg/datafile/account_lj02.dbf
skipping datafile 27; already restored to file
/oradata/racdg/datafile/account_zg02.dbf
/oradata/racdg/datafile/account_qq02.dbf skipping datafile 29; already restored to file /oradata/racdg/datafile/account_sg02.dbf skipping datafile 30; already restored to file /oradata/racdg/datafile/base_info02.dbf skipping datafile 31; already restored to file /oradata/racdg/datafile/base_info03.dbf skipping datafile 32; already restored to file /oradata/racdg/datafile/base_info04.dbf skipping datafile 33; already restored to file /oradata/racdg/datafile/base_info05.dbf skipping datafile 34; already restored to file /oradata/racdg/datafile/base_info06.dbf skipping datafile 35; already restored to file /oradata/racdg/datafile/base_info07.dbf skipping datafile 36; already restored to file /oradata/racdg/datafile/base_info08.dbf skipping datafile 37; already restored to file /oradata/racdg/datafile/card_data02.dbf skipping datafile 38; already restored to file /oradata/racdg/datafile/card_data04.dbf skipping datafile 39; already restored to file /oradata/racdg/datafile/card_data03.dbf skipping datafile 40; already restored to file /oradata/racdg/datafile/card_data05.dbf skipping datafile 41; already restored to file /oradata/racdg/datafile/account_kz04.dbf skipping datafile 44; already restored to file /oradata/racdg/datafile/order_data02.dbf