不完全恢复试验（11.2g 64位win2003数据库恢复到32位linux服务器）
作者 佚名技术
来源 Linux系统
浏览
发布时间 2012-04-04
| gs at init.ora *.processes=150 *.query_rewrite_enabled=''TRUE'' *.remote_login_passwordfile=''EXCLUSIVE'' *.result_cache_max_size=640K *.skip_unusable_indexes=TRUE *.streams_pool_size=12M *.undo_retention=3600 *.undo_management=''manual'' *.undo_tablespace=''undotbs2'' *.utl_file_dir=''*'' ~ ~~ "initkmed11.ora" [New] 33L, 1141C written 6.建立kmed11相关的目录： [oracle@kmed dbs]$ mkdir -p /u02/archive/kmed11 [oracle@kmed dbs]$ mkdir -p /u02/app/diag/rdbms/kmed11/kmed11/cdump [oracle@kmed dbs]$ ll /u02/oradata/kmed11 total 0 7.建立密码文件： [oracle@kmed dbs]$ orapwd file=orapwkmed11 password=oracle entries=10 8.设置sid,启动到nomount目录下： [oracle@kmed dbs]$ export ORACLE_SID=kmed11 [oracle@kmed dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 11 09:56:07 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORACLE instance started. Total System Global Area 255270912 bytes Fixed Size 1335836 bytes Variable Size 197135844 bytes Database Buffers 54525952 bytes Redo Buffers 2273280 bytes 9.启动rman,restore控制文件. [oracle@kmed dbs]$ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Sat Dec 11 09:56:45 2010 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: KMED11 (not mounted) RMAN> restore controlfile from ''/rmanbk/kmed11/CTL_C-682820449-20101210-00''; Starting restore at 11-DEC-10 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=19 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 output file name=/u02/oradata/kmed11/control01.ctl output file name=/u02/oradata/kmed11/control02.ctl output file name=/u02/oradata/kmed11/control03.ctl Finished restore at 11-DEC-10 10.启动到mount 状态. RMAN> alter database mount; database mounted released channel: ORA_DISK_1 SQL> col name format a40; SQL> select file#,name,status from v$datafile; FILE# NAME STATUS ---------- ---------------------------------------- ------- 1 DG/kmed11/system01.dbf SYSTEM 2 DG/kmed11/sysaux01.dbf ONLINE 3 DG/kmed11/undotbs01.dbf ONLINE 4 DG/kmed11/users01.dbf ONLINE 5 DG/kmed11/example01.dbf ONLINE 6 DG/kmed11/test01.dbf ONLINE 7 DG/kmed11/test02.dbf ONLINE 8 DG/kmed11/test03.dbf ONLINE 11.在rman中指定备份文件的路径: RMAN> catalog backuppiece ''/rmanbk/kmed11/DB_KMED11_2_1_1_737400323.DBF''; cataloged backup piece backup piece handle=/rmanbk/kmed11/DB_KMED11_2_1_1_737400323.DBF RECID=4 STAMP=737460328 RMAN> catalog backuppie |
凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢! |
你可能对下面的文章感兴趣
上一篇: linux SWAP的创建，两种方式下一篇: linux dhcp server
关于不完全恢复试验（11.2g 64位win2003数据库恢复到32位linux服务器）的所有评论
