Solaris 10下迁移10G RAC (六)

最新推荐文章于 2025-07-07 15:44:42 发布
转载 最新推荐文章于 2025-07-07 15:44:42 发布 · 136 阅读 · 0

本文介绍了一次RAC数据库迁移工作中数据库恢复的具体步骤，包括备份数据库、准备目录与授权、创建控制文件、重命名数据文件及在线日志文件、还原与恢复数据库等内容。

最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。
本文是这次迁移工作的第六部分：恢复数据库。


6 恢复数据库

6.1 备份数据库

首先需要从原来数据库备份，过程不说了，备份完成后将备份集传送到本地上。

6.2 准备相关目录并授权

由于源库的目录结构与当前库不一致，为了可以正常用rman恢复，需要做一个link来保持两边路径的一致性。

在其中一个节点创建如下目录和链接（pre1）：

mkdir –p /data/backup
ln -s  /backup /data/backup/tradedb

在所有节点创建相关目录并授权：

mkdir -p /oracle/app/admin/pre/{bdump,udump,adump}
6.3 在ASM中创建对应目录
bash-3.00$ export ORACLE_SID=+ASM1
bash-3.00$ asmcmd
ASMCMD> ls
DATA/
ASMCMD> cd data
ASMCMD> mkdir onlinelog
ASMCMD> mkdir archivelog
ASMCMD> mkdir datafile
ASMCMD> mkdir pfile
ASMCMD> mkdir controlfile
ASMCMD> ls
archivelog/
controlfile/
datafile/
onlinelog/
pfile/
6.4 创建密码文件
分别在两个节点创建密码文件：
pre1:
bash-3.00$ cd $ORACLE_HOME/dbs
bash-3.00$ orapwd file=orapwprerac1 password=testpass entries=10
pre2:
bash-3.00$ cd $ORACLE_HOME/dbs
bash-3.00$ orapwd file=orapwprerac2 password=testpass entries=10
两端密码保持一致。
6.5 配置tnsnames文件
在所有节点的tnsnames.ora都添加如下内容：
LISTENER_PRE2 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = vip-pre1)(PORT = 1521))
LISTENER_PRE1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = vip-pre2)(PORT = 1521))
LISTENERS_PRE =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = vip-pre1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = vip-pre2)(PORT = 1521))
  )
PRE2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = vip-pre1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pre.us.oracle.com)
      (INSTANCE_NAME = prerac2)
    )
  )
PRE1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = vip-pre2)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pre.us.oracle.com)
      (INSTANCE_NAME = prerac1)
    )
  )
6.6 创建参数文件
create pfile from spfile;
bash-3.00$ sftp 172.0.2.11
Connecting to 172.0.2.11...
Password: 
sftp> get  pfile.ora
Fetching /export/home/oracle/pfile.ora to pfile.ora
sftp> exit
*.audit_file_dest='/oracle/app/admin/pre/adump'
*.background_dump_dest='/oracle/app/admin/pre/bdump'
*.cluster_database=true
*.cluster_database_instances=2
*.compatible='10.2.0.1.0'
*.control_files='+DATA/controlfile/control1','+DATA/controlfile/control2','+DATA/controlfile/control3'
*.core_dump_dest='/opt/oracle/admin/prerac/cdump'
*.db_block_size=16384
*.db_domain='us.oracle.com'
*.db_file_multiblock_read_count=16
*.db_name='tradedb'
*.global_names=TRUE
prerac1.instance_number=1
prerac2.instance_number=2
*.job_queue_processes=50
#VIP
prerac1.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 172.0.2.2)(PORT = 1521))'
prerac2.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 172.0.2.4)(PORT = 1521))'
*.log_archive_dest_1='LOCATION=+DATA//archivelog'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=5000
*.pga_aggregate_target=495630592
*.processes=300
*.remote_listener='LISTENERS_PRE'
*.remote_login_passwordfile='EXCLUSIVE'
*.session_max_open_files=20
*.sessions=335
*.sga_target=1474836480
*.streams_pool_size=50331648
prerac1.thread=1
prerac2.thread=2
*.undo_management='AUTO'
*.undo_retention=10800
prerac1.undo_tablespace='UNDOTBS1'
prerac2.undo_tablespace='UNDOTBS2'
*.user_dump_dest='/oracle/app/admin/pre/udump'
bash-3.00$ export ORACLE_SID=prerac1
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on  9 26 23:10:35 2007
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> create spfile='+DATA/pfile/spfile.ora' from pfile='/export/home/oracle/pfile.ora';
File created.
6.7 还原数据库：
Ø         
bash-3.00$ export ORACLE_SID=prerac1
bash-3.00$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on  9 27 00:10:17 2007
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1476395008 bytes
Fixed Size                  2030200 bytes
Variable Size             385877384 bytes
Database Buffers         1073741824 bytes
Redo Buffers               14745600 bytes
SQL> exit
Ø         
bash-3.00$ export ORACLE_SID=prerac1
bash-3.00$ rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on  9 27 00:35:47 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: tradedb (not mounted)
--
RMAN> restore controlfile from '/data/backup/tradedb/62isntt2_1_1';
Starting restore at 27-9 -07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=316 instance=prerac1 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:17
output filename=+DATA/controlfile/control1
output filename=+DATA/controlfile/control2
output filename=+DATA/controlfile/control3
Finished restore at 27-9 -07
RMAN>      
--mount
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
Ø        
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo1_1_1_1g' to  '+DATA/onlinelog/redo1_1_1.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo1_1_2_1g' to  '+DATA/onlinelog/redo1_1_2.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo1_2_1_1g' to  '+DATA/onlinelog/redo1_2_1.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo1_2_2_1g' to  '+DATA/onlinelog/redo1_2_2.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo1_3_1_1g' to  '+DATA/onlinelog/redo1_3_1.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo1_3_2_1g' to  '+DATA/onlinelog/redo1_3_2.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo1_4_1_1g' to  '+DATA/onlinelog/redo1_4_1.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo1_4_2_1g' to  '+DATA/onlinelog/redo1_4_2.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo2_1_1_1g' to  '+DATA/onlinelog/redo2_1_1.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo2_1_2_1g' to  '+DATA/onlinelog/redo2_1_2.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo2_2_1_1g' to  '+DATA/onlinelog/redo2_2_1.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo2_2_2_1g' to  '+DATA/onlinelog/redo2_2_2.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo2_3_1_1g' to  '+DATA/onlinelog/redo2_3_1.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo2_3_2_1g' to  '+DATA/onlinelog/redo2_3_2.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo2_4_1_1g' to  '+DATA/onlinelog/redo2_4_1.log';
alter database rename file '/dev/vx/rdsk/datadg/tradedb_redo2_4_2_1g' to  '+DATA/onlinelog/redo2_4_2.log';
Ø         
SQL> SELECT 'set newname for datafile ''' || FILE_NAME ||
  2  ''' to ''+DATA/datafile/' ||lower(TABLESPACE_NAME)||
  3  row_number() over (partition by tablespace_name order by file_id)|| '.ora'';' sql
  4  FROM DBA_DATA_FILES;
SQL
------------------------------------------------------------------------------------------------------------------------
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_anhui_1' to '+DATA/datafile/anhui1.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_anhui_2' to '+DATA/datafile/anhui2.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_anhui_3' to '+DATA/datafile/anhui3.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_anhui_4' to '+DATA/datafile/anhui4.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_gpo_1_4g' to '+DATA/datafile/gpo1.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_gpo_2_4g' to '+DATA/datafile/gpo2.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_ndmain_1_4g' to '+DATA/datafile/ndmain1.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_ndmain_2_4g' to '+DATA/datafile/ndmain2.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_ndmain_3_4g' to '+DATA/datafile/ndmain3.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_sysaux_1_1g' to '+DATA/datafile/sysaux1.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_sysaux_2_1g' to '+DATA/datafile/sysaux2.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_system_1_4g' to '+DATA/datafile/system1.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_1_4g' to '+DATA/datafile/undotbs11.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_2_4g' to '+DATA/datafile/undotbs12.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_3_4g' to '+DATA/datafile/undotbs13.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_4_4g' to '+DATA/datafile/undotbs14.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_5_4g' to '+DATA/datafile/undotbs15.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_1_4g' to '+DATA/datafile/undotbs21.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_2_4g' to '+DATA/datafile/undotbs22.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_3_4g' to '+DATA/datafile/undotbs23.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_4_4g' to '+DATA/datafile/undotbs24.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_5_4g' to '+DATA/datafile/undotbs25.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_users_1_200m' to '+DATA/datafile/users1.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_1_4g' to '+DATA/datafile/zhejiang1.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_2_4g' to '+DATA/datafile/zhejiang2.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_3_4g' to '+DATA/datafile/zhejiang3.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_4_4g' to '+DATA/datafile/zhejiang4.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_5_4g' to '+DATA/datafile/zhejiang5.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_6_4g' to '+DATA/datafile/zhejiang6.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_7_4g' to '+DATA/datafile/zhejiang7.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_8_4g' to '+DATA/datafile/zhejiang8.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_9_4g' to '+DATA/datafile/zhejiang9.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_10_4g' to '+DATA/datafile/zhejiang10.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_11_4g' to '+DATA/datafile/zhejiang11.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_12_4g' to '+DATA/datafile/zhejiang12.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_13_4g' to '+DATA/datafile/zhejiang13.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_14_4g' to '+DATA/datafile/zhejiang14.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_15_4g' to '+DATA/datafile/zhejiang15.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_16_4g' to '+DATA/datafile/zhejiang16.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_17_4g' to '+DATA/datafile/zhejiang17.ora';
set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_18_4g' to '+DATA/datafile/zhejiang18.ora';
Ø         prerac1
10g rman
bash-3.00$ rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on  9 27 01:38:39 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: TRADEDB (DBID=4181457554, not open)
RMAN> catalog start with '/data/backup/tradedb/6*';
using target database control file instead of recovery catalog
searching for all files that match the pattern /data/backup/tradedb/6*
no files found to be unknown to the database
RMAN> catalog start with '/data/backup/tradedb/6';
searching for all files that match the pattern /data/backup/tradedb/6
List of Files Unknown to the Database
=====================================
File Name: /data/backup/tradedb/61isntt1_1_1
File Name: /data/backup/tradedb/62isntt2_1_1
File Name: /data/backup/tradedb/64isnvm0_1_1
File Name: /data/backup/tradedb/65iso00i_1_1
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /data/backup/tradedb/61isntt1_1_1
File Name: /data/backup/tradedb/62isntt2_1_1
File Name: /data/backup/tradedb/64isnvm0_1_1
File Name: /data/backup/tradedb/65iso00i_1_1
Ø         
RMAN>  run
2> {
3> ALLOCATE CHANNEL c1 TYPE DISK CONNECT sys/testpass@pre1;
4> ALLOCATE CHANNEL c2 TYPE DISK CONNECT sys/testpass@pre2;
5> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_anhui_1' to '+DATA/datafile/anhui1.ora';
6> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_anhui_2' to '+DATA/datafile/anhui2.ora';
7> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_anhui_3' to '+DATA/datafile/anhui3.ora';
8> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_anhui_4' to '+DATA/datafile/anhui4.ora';
9> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_gpo_1_4g' to '+DATA/datafile/gpo1.ora';
10> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_gpo_2_4g' to '+DATA/datafile/gpo2.ora';
11> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_ndmain_1_4g' to '+DATA/datafile/ndmain1.ora';
12> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_ndmain_2_4g' to '+DATA/datafile/ndmain2.ora';
13> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_ndmain_3_4g' to '+DATA/datafile/ndmain3.ora';
14> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_sysaux_1_1g' to '+DATA/datafile/sysaux1.ora';
15> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_sysaux_2_1g' to '+DATA/datafile/sysaux2.ora';
16> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_system_1_4g' to '+DATA/datafile/system1.ora';
17> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_1_4g' to '+DATA/datafile/undotbs11.ora';
18> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_2_4g' to '+DATA/datafile/undotbs12.ora';
19> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_3_4g' to '+DATA/datafile/undotbs13.ora';
20> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_4_4g' to '+DATA/datafile/undotbs14.ora';
21> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs1_5_4g' to '+DATA/datafile/undotbs15.ora';
22> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_1_4g' to '+DATA/datafile/undotbs21.ora';
23> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_2_4g' to '+DATA/datafile/undotbs22.ora';
24> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_3_4g' to '+DATA/datafile/undotbs23.ora';
25> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_4_4g' to '+DATA/datafile/undotbs24.ora';
26> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_undotbs2_5_4g' to '+DATA/datafile/undotbs25.ora';
27> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_users_1_200m' to '+DATA/datafile/users1.ora';
28> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_1_4g' to '+DATA/datafile/zhejiang1.ora';
29> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_2_4g' to '+DATA/datafile/zhejiang2.ora';
30> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_3_4g' to '+DATA/datafile/zhejiang3.ora';
31> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_4_4g' to '+DATA/datafile/zhejiang4.ora';
32> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_5_4g' to '+DATA/datafile/zhejiang5.ora';
33> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_6_4g' to '+DATA/datafile/zhejiang6.ora';
34> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_7_4g' to '+DATA/datafile/zhejiang7.ora';
35> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_8_4g' to '+DATA/datafile/zhejiang8.ora';
36> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_9_4g' to '+DATA/datafile/zhejiang9.ora';
37> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_10_4g' to '+DATA/datafile/zhejiang10.ora';
38> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_11_4g' to '+DATA/datafile/zhejiang11.ora';
39> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_12_4g' to '+DATA/datafile/zhejiang12.ora';
40> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_13_4g' to '+DATA/datafile/zhejiang13.ora';
41> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_14_4g' to '+DATA/datafile/zhejiang14.ora';
42> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_15_4g' to '+DATA/datafile/zhejiang15.ora';
43> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_16_4g' to '+DATA/datafile/zhejiang16.ora';
44> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_17_4g' to '+DATA/datafile/zhejiang17.ora';
45> set newname for datafile '/dev/vx/rdsk/datadg/tradedb_zhejiang_18_4g' to '+DATA/datafile/zhejiang18.ora';
46> restore database;
47> switch datafile all;
48> recover database;
49> release channel c1;
50> release channel c2;
51> }
allocated channel: c1
channel c1: sid=316 instance=prerac1 devtype=DISK
allocated channel: c2
channel c2: sid=310 instance=prerac2 devtype=DISK
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 27-9 -07
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to +DATA/datafile/undotbs11.ora
restoring datafile 00003 to +DATA/datafile/undotbs12.ora
restoring datafile 00005 to +DATA/datafile/undotbs14.ora
restoring datafile 00007 to +DATA/datafile/sysaux1.ora
restoring datafile 00008 to +DATA/datafile/undotbs21.ora
restoring datafile 00010 to +DATA/datafile/undotbs23.ora
restoring datafile 00012 to +DATA/datafile/undotbs25.ora
restoring datafile 00013 to +DATA/datafile/users1.ora
restoring datafile 00015 to +DATA/datafile/ndmain2.ora
restoring datafile 00017 to +DATA/datafile/anhui1.ora
restoring datafile 00019 to +DATA/datafile/anhui3.ora
restoring datafile 00021 to +DATA/datafile/zhejiang1.ora
restoring datafile 00023 to +DATA/datafile/zhejiang3.ora
restoring datafile 00025 to +DATA/datafile/zhejiang5.ora
restoring datafile 00027 to +DATA/datafile/zhejiang7.ora
restoring datafile 00029 to +DATA/datafile/zhejiang9.ora
restoring datafile 00031 to +DATA/datafile/zhejiang11.ora
restoring datafile 00033 to +DATA/datafile/zhejiang13.ora
restoring datafile 00035 to +DATA/datafile/zhejiang15.ora
restoring datafile 00037 to +DATA/datafile/zhejiang17.ora
restoring datafile 00040 to +DATA/datafile/gpo1.ora
channel c1: reading from backup piece /data/backup/tradedb/61isntt1_1_1
                                                                   channel c1: restored backup piece 1
piece handle=/data/backup/tradedb/61isntt1_1_1 tag=TAG20070924T093632
channel c1: restore complete, elapsed time: 02:15:44
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +DATA/datafile/system1.ora
restoring datafile 00004 to +DATA/datafile/undotbs13.ora
restoring datafile 00006 to +DATA/datafile/undotbs15.ora
restoring datafile 00009 to +DATA/datafile/undotbs22.ora
restoring datafile 00011 to +DATA/datafile/undotbs24.ora
restoring datafile 00014 to +DATA/datafile/ndmain1.ora
restoring datafile 00016 to +DATA/datafile/ndmain3.ora
restoring datafile 00018 to +DATA/datafile/anhui2.ora
restoring datafile 00020 to +DATA/datafile/anhui4.ora
restoring datafile 00022 to +DATA/datafile/zhejiang2.ora
restoring datafile 00024 to +DATA/datafile/zhejiang4.ora
restoring datafile 00026 to +DATA/datafile/zhejiang6.ora
restoring datafile 00028 to +DATA/datafile/zhejiang8.ora
restoring datafile 00030 to +DATA/datafile/zhejiang10.ora
restoring datafile 00032 to +DATA/datafile/zhejiang12.ora
restoring datafile 00034 to +DATA/datafile/zhejiang14.ora
restoring datafile 00036 to +DATA/datafile/zhejiang16.ora
restoring datafile 00038 to +DATA/datafile/zhejiang18.ora
restoring datafile 00039 to +DATA/datafile/sysaux2.ora
restoring datafile 00041 to +DATA/datafile/gpo2.ora
channel c1: reading from backup piece /data/backup/tradedb/62isntt2_1_1
                                                           channel c1: restored backup piece 1
piece handle=/data/backup/tradedb/62isntt2_1_1 tag=TAG20070924T093632
channel c1: restore complete, elapsed time: 01:57:55
Finished restore at 27-9 -07
datafile 17 switched to datafile copy
input datafile copy recid=42 stamp=634370267 filename=+DATA/datafile/anhui1.ora
datafile 18 switched to datafile copy
input datafile copy recid=43 stamp=634370267 filename=+DATA/datafile/anhui2.ora
datafile 19 switched to datafile copy
input datafile copy recid=44 stamp=634370268 filename=+DATA/datafile/anhui3.ora
datafile 20 switched to datafile copy
input datafile copy recid=45 stamp=634370268 filename=+DATA/datafile/anhui4.ora
datafile 40 switched to datafile copy
input datafile copy recid=46 stamp=634370268 filename=+DATA/datafile/gpo1.ora
datafile 41 switched to datafile copy
input datafile copy recid=47 stamp=634370269 filename=+DATA/datafile/gpo2.ora
datafile 14 switched to datafile copy
input datafile copy recid=48 stamp=634370269 filename=+DATA/datafile/ndmain1.ora
datafile 15 switched to datafile copy
input datafile copy recid=49 stamp=634370269 filename=+DATA/datafile/ndmain2.ora
datafile 16 switched to datafile copy
input datafile copy recid=50 stamp=634370269 filename=+DATA/datafile/ndmain3.ora
da
                                                            

                    

                                                    来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/231499/viewspace-63867/，如需转载，请注明出处，否则将追究法律责任。
                                            


                


转载于:http://blog.itpub.net/231499/viewspace-63867/

                

        




    



  



    

      

        

            

              
                
                  cuilin2183
                
              
            

            

                关注
              
            

        

        

          
      

      










                



	

		

			

				
					
10G 的RAC基本安装步骤

				
			

			

				

					03-12
				

			

		

		

			
				
在10g版本中，Oracle引入了Cluster Ready Services (CRS)，这是一个集成的高可用性框架，它在各种操作系统平台上提供支持，包括AIX、Solaris和HP-UX。  **1. 操作系统安装** 首先，你需要在支持的Windows平台上安装...

			
		

	



                

            
              



	

		

			

				
					
Solaris 10下迁移10G RAC (一)

				
			

			

				

					cuilin2183的博客
				

				

					07-21
					
					201
					
				

			

		

		

			
				
最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。本文是这次迁移工作的第一部分：相关环境的说明。1 综述目标：把一个rac数据库迁移到另一个rac数据库。两个数据库...

			
		

	



              


  
              

                


	

		

			

				
					
Solaris 10下迁移10G RAC (二)

				
			

			

				

					cuilin2183的博客
				

				

					07-21
					
					276
					
				

			

		

		

			
				
最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。本文是这次迁移工作的第二部分：安装rac的准备工作。2 准备工作2.1 添加用户组和用户在所有节点添加相同的用户组...

			
		

	





	

		

			

				
					
Solaris 10下迁移10G RAC (三)

				
			

			

				

					cuilin2183的博客
				

				

					07-21
					
					158
					
				

			

		

		

			
				
最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。本文是这次迁移工作的第三部分：安装oracle clusterware。3 安装clusterware3.1检验系...

			
		

	



		

			
		



	

		

			

				
					
Solaris 10下迁移10G RAC (四)

				
			

			

				

					cuilin2183的博客
				

				

					12-13
					
					159
					
				

			

		

		

			
				
最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。本文是这次迁移工作的第四部分：安装数据库软件。4 安装数据库软件安装完clusterware后，就可以进行安装数据...

			
		

	





	

		

			

				
					
Solaris 10下迁移10G RAC (七)

				
			

			

				

					cuilin2183的博客
				

				

					07-20
					
					163
					
				

			

		

		

			
				
最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。本文是这次迁移工作的第七部分：后续工作。7 后续工作7.1修改db_name为了与正式系统区分，需要修改还原过来的...

			
		

	





	

		

			

				
					
Solaris 10下迁移10G RAC (五)

				
			

			

				

					cuilin2183的博客
				

				

					06-25
					
					115
					
				

			

		

		

			
				
最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。本文是这次迁移工作的第五部分：升级数据库。5升级ORACLE到10203由于目前还没有创建数据库，所以升级步骤相对...

			
		

	





	

		

			

				
					
Solaris 10下迁移10G RAC (八)

				
			

			

				

					cuilin2183的博客
				

				

					02-25
					
					101
					
				

			

		

		

			
				
最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。本文是这次迁移工作的第八部分：迁移过程中遇到的错误。8 遇到的错误8.1 错误Crs我安装了3遍，在其中一次重装c...

			
		

	





	

		

			

				
					
1、Oracle 10g RAC：Grid、服务与集群技术解析

				
			

			

				

					day7的博客
				

				

					07-07
					
					144
					
				

			

		

		

			
				
本文深入解析了Oracle 10g RAC（Real Application Clusters）的核心技术，包括网格计算、服务管理、集群架构、存储管理、故障转移、负载均衡以及性能调优等内容。文章详细介绍了RAC的组件、工作机制及实际应用场景，并提供了安装配置、备份恢复、最佳实践等方面的指导，为企业数据库的高可用性、可扩展性和性能优化提供了全面的技术支持。

			
		

	





	

		

			

				
					
Solaris 10 Oracle 10G RAC在油田生产环境中的应用.pdf

				
			

			

				

					10-10
				

			

		

		

			
				
《Solaris 10 Oracle 10G RAC在油田生产环境中的应用》这篇文档讲述了在油田生产环境中，如何利用先进的IT技术实现数据库系统的升级和扩容，以满足数字油田目标的需求。以下是文档涉及的主要知识点：  1. **Oracle ...

			
		

	





	

		

			

				
					
Solaris平台Oracle 10g RAC+ASM安装配置指南

				
			

			

				

					
				

			

		

		

			
				
资源摘要信息:"《ORACLE-10gRAC-ASM-FOR-SOLARIS-安装指南.doc》是一份详细的技术文档，主要面向在Sun Solaris操作系统环境下部署Oracle 10g RAC（Real Application Clusters）并结合ASM（Automatic Storage ...

			
		

	





	

		

			

				
					
基于四元数的EKF进行姿态估计.zip

				
			

			

				

					01-09
				

			

		

		

			
				
1.版本：matlab2014a/2019b/2024b

2.附赠案例数据可直接运行。

3.代码特点：参数化编程、参数可方便更改、代码编程思路清晰、注释明细。

4.适用对象：计算机，电子信息工程、数学等专业的大学生课程设计、期末大作业和毕业设计。

			
		

	





	

		

			

				
					
使用锁相环实现同步、稳定电流控制和单位功率因数的单相并网逆变器Simulink闭环模型.rar

				
			

			

				

					01-09
				

			

		

		

			
				
1.版本：matlab2014/2019a/2024a

2.附赠案例数据可直接运行。

3.代码特点：参数化编程、参数可方便更改、代码编程思路清晰、注释明细。

4.适用对象：计算机，电子信息工程、数学等专业的大学生课程设计、期末大作业和毕业设计。

			
		

	





	

		

			

				
					
地级市用电量统计数据（2004-2022年）.xlsx

					
最新发布

				
			

			

				

					01-09
				

			

		

		

			
				
详细介绍及样例数据：https://blog.youkuaiyun.com/m0_65541699/article/details/156773492

			
		

	





	

		

			

				
					
【激光质量检测】利用丝杆与步进电机的组合装置带动光源的移动，完成对光源使用切片法测量其光束质量的目的研究（Matlab代码实现）

				
			

			

				

					01-09
				

			

		

		

			
				
【激光质量检测】利用丝杆与步进电机的组合装置带动光源的移动，完成对光源使用切片法测量其光束质量的目的研究（Matlab代码实现）内容概要：本文研究了利用丝杆与步进电机的组合装置带动光源移动，结合切片法实现对激光光源光束质量的精确测量方法，并提供了基于Matlab的代码实现方案。该系统通过机械装置精确控制光源位置，采集不同截面的光强分布数据，进而分析光束的聚焦特性、发散角、光斑尺寸等关键质量参数，适用于高精度光学检测场景。研究重点在于硬件控制与图像处理算法的协同设计，实现了自动化、高重复性的光束质量评估流程。;  
适合人群：具备一定光学基础知识和Matlab编程能力的科研人员或工程技术人员，尤其适合从事激光应用、光电检测、精密仪器开发等相关领域的研究生及研发工程师。;  
使用场景及目标：①实现对连续或脉冲激光器输出光束的质量评估；②为激光加工、医疗激光、通信激光等应用场景提供可靠的光束分析手段；③通过Matlab仿真与实际控制对接，验证切片法测量方案的有效性与精度。;  
阅读建议：建议读者结合机械控制原理与光学测量理论同步理解文档内容，重点关注步进电机控制逻辑与切片数据处理算法的衔接部分，实际应用时需校准装置并优化采样间距以提高测量精度。

			
		

	





	

		

			

				
					
【毕业设计】STM32智能家居语音系统MF-毕业源码案例设计.zip

				
			

			

				

					01-09
				

			

		

		

			
				
【毕业设计】STM32智能家居语音系统MF-毕业源码案例设计.zip

			
		

	





	

		

			

				
					
matlab混合电动汽车模型开发

				
			

			

				

					01-09
				

			

		

		

			
				
下载前必看：https://pan.quark.cn/s/a4b39357ea24
 FMOT（Field and Matrix Operator Tool） FMOT的matlab基础开发版本，目前主要功能是simple和piso算法的实现。
可以新建立一个untitled.m，然后把test中的.mlx内容复制到新的untitled.m中，调试更方便。
方程构建和组装的风格是参考OpenFOAM的方式，希望能对OF的初学者有一定的帮助。
算子离散的实现是采用全向量化的方式进行组装，需要一定的基础来理解。
当前大部分封装函数具有帮助说明，可右键点击查看。
注意： 对流项的边界条件目前存在一定问题，对所有第一类和第二类边界条件不完全通用； SIMPLE的残差输出colorbar存在问题； PISO的残差类的实现是不完整的，请不要使用。
test文件中的LidDriven(p)存在一点问题，先不要使用。
FMOT目前代码存在很多细节问题，并且没有对应的使用教程，只能通过自己阅读源码来学习，预计年底前会更新一次。
有问题可以联系：fmot_2024@163.com

			
		

	





	

		

			

				
					
【毕业设计】STM32F1智能门禁锁系统MF-毕业源码案例设计.zip

				
			

			

				

					01-09
				

			

		

		

			
				
【毕业设计】STM32F1智能门禁锁系统MF-毕业源码案例设计.zip

			
		

	





	

		

			

				
					
基于改进多目标灰狼优化算法的考虑V2G技术的风、光、荷、储微网多目标日前优化调度研究（Matlab代码实现）

				
			

			

				

					01-09
				

			

		

		

			
				
基于改进多目标灰狼优化算法的考虑V2G技术的风、光、荷、储微网多目标日前优化调度研究（Matlab代码实现）内容概要：本文研究了基于改进多目标灰狼优化算法的风、光、荷、储微网多目标日前优化调度，重点考虑了电动汽车接入电网的V2G（Vehicle-to-Grid）技术。通过建立包含风电、光伏、负荷及储能系统的微电网模型，综合考虑经济性、环保性和系统稳定性等多个优化目标，采用改进的多目标灰狼优化算法进行求解，并利用Matlab实现仿真代码。文中详细阐述了模型构建、算法改进策略及优化调度结果分析，验证了所提方法在降低运行成本、减少碳排放和提升可再生能源消纳能力方面的有效性。;  
适合人群：具备一定电力系统基础知识和Matlab编程能力的研究生、科研人员及从事新能源微电网优化调度相关工作的工程技术人员。;  
使用场景及目标：①用于微电网能量管理系统的多目标优化调度研究；②为含高比例可再生能源和电动汽车的电力系统提供日前调度决策支持；③作为智能优化算法在电力系统应用的教学与科研案例。;  
阅读建议：建议读者结合Matlab代码深入理解算法实现细节，关注V2G技术对微网调度的影响机制，并可通过调整参数或引入其他智能算法进行对比实验，进一步拓展研究深度。

			
		

	



              




          




        



    





    



      

      

        
      

      





	

		评论	
	

  

	
    

      

      

      

        
        

          
          

            

              成就一亿技术人!
            

            

              拼手气红包6.0元
            

          

        

        

          

            还能输入1000个字符
             | 博主筛选后可见
          

          

             
          

          

            

              红包
              添加红包
            

            

              表情包
              插入表情
              

                

              

            

            

              表情包
              代码片
              

                
              

            

            

              
              
              
              
              
              
              
            

          

        

      

    

		

			

			

			

					 条评论被折叠 查看
			

			

				
			

		

	

	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

                
 1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
 2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

              

            

          

      

      余额充值