求教 rman 恢复
RMAN> restore standby controlfile from '/rman_backup/standby_0tpqobfk_1_1.ctl';
Starting restore at 21-DEC-14
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/21/2014 21:13:09
ORA-19870: error while restoring backup piece /rman_backup/standby_0tpqobfk_1_1.ctl
ORA-19504: failed to create file "+DATA/phydb/controlfile/cont.ctl"
ORA-15012: ASM file 'phydb/controlfile/cont.ctl' does not exist
ORA-17502: ksfdcre:5 Failed to create file +DATA/phydb/controlfile/cont.ctl
ORA-15081: failed to submit an I/O operation to a disk
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE dg
ora.FLASH.dg ora....up.type ONLINE ONLINE dg
ora.GRIDDG.dg ora....up.type ONLINE ONLINE dg
ora....ER.lsnr ora....er.type ONLINE ONLINE dg
ora.asm ora.asm.type ONLINE ONLINE dg
ora.cssd ora.cssd.type ONLINE ONLINE dg
ora.diskmon ora....on.type ONLINE ONLINE dg ORA-15081: failed to submit an I/O operation to a disk
给出rdbms和asm的alert.log
你确定该ASM能正常工作？ Maclean Liu(刘相兵 发表于 2014-12-21 23:24 static/image/common/back.gif
ORA-15081: failed to submit an I/O operation to a disk
给出rdbms和asm的alert.log
ASMCMD> ls
DATA/
FLASH/
GRIDDG/
ASMCMD>
应该可以吧， 望指教 Maclean Liu(刘相兵 发表于 2014-12-21 23:24 static/image/common/back.gif
ORA-15081: failed to submit an I/O operation to a disk
给出rdbms和asm的alert.log
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
FLASH
GRIDDG
SQL>
Maclean Liu(刘相兵 发表于 2014-12-21 23:24 static/image/common/back.gif
ORA-15081: failed to submit an I/O operation to a disk
给出rdbms和asm的alert.log
删了重新建一个，asm是按照你的那个帖子做的， 如2楼 Liu Maclean(刘相兵 发表于 2014-12-22 10:18 static/image/common/back.gif
如2楼
在重装- -
ohasd is starting
ADVM/ACFS is not supported on centos-release-6-6.el6.centos.12.2.x86_64
原来还没注意，还有这条报错
dg 2014/12/22 10:15:50 /u01/app/11.2.0/grid/cdata/dg/backup_20141222_101550.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
Updating inventory properties for clusterware
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 19986 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successfu
Liu Maclean(刘相兵 发表于 2014-12-22 10:18 static/image/common/back.gif
如2楼
on Dec 22 11:19:40 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilephydb.ora
System parameters with non-default values:
processes = 150
memory_target = 804M
control_files = "+DATA/phydb/controlfile/cont.ctl"
db_file_name_convert = "+DATA/rac/"
db_file_name_convert = "+DATA/phydb/"
log_file_name_convert = "+DATA/rac/"
log_file_name_convert = "+DATA/phydb/"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "location=USE_DB_RECOVERY_FILE_DEST
valid_for=(all_logfiles,all_roles) db_unique_name=phydb"
log_archive_dest_2 = "service=rac1
valid_for=(online_logfiles,primary_role) db_unique_name=rac"
fal_client = "phydb"
fal_server = "rac1"
fal_server = "rac2"
log_archive_config = "dg_config=(rac,phydb)"
log_archive_format = "ARC_%t_%S_%r.arc"
cluster_database = FALSE
db_create_file_dest = "+DATA"
db_recovery_file_dest = "+FLASH"
db_recovery_file_dest_size= 3882M
standby_file_management = "auto"thread = 1
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
service_names = "phydb"
dispatchers = "(PROTOCOL=TCP) (SERVICE=phydbXDB)"
core_dump_dest = "/u01/app/oracle/diag/rdbms/phydb/cdump"
audit_file_dest = "/u01/app/oracle/admin/phydb/adump"
audit_trail = "DB"
db_name = "rac"
db_unique_name = "phydb"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Mon Dec 22 11:19:41 2014
PMON started with pid=2, OS id=2888
Mon Dec 22 11:19:41 2014
VKTM started with pid=3, OS id=2890 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Dec 22 11:19:41 2014
GEN0 started with pid=4, OS id=2894
Mon Dec 22 11:19:41 2014
DIAG started with pid=5, OS id=2896
Mon Dec 22 11:19:41 2014
DBRM started with pid=6, OS id=2898
Mon Dec 22 11:19:41 2014
PSP0 started with pid=7, OS id=2900
Mon Dec 22 11:19:41 2014
DIA0 started with pid=8, OS id=2902
Mon Dec 22 11:19:41 2014
MMAN started with pid=9, OS id=2904
Mon Dec 22 11:19:41 2014
DBW0 started with pid=10, OS id=2906
‘Mon Dec 22 11:19:41 2014
RECO started with pid=14, OS id=2914
Mon Dec 22 11:19:41 2014
RBAL started with pid=15, OS id=2916
Mon Dec 22 11:19:41 2014
ASMB started with pid=16, OS id=2918
Mon Dec 22 11:19:41 2014
MMON started with pid=17, OS id=2920
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Dec 22 11:19:41 2014
MMNL started with pid=18, OS id=2922
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
NOTE: initiating MARK startup
Starting background process MARK
Mon Dec 22 11:19:42 2014
MARK started with pid=22, OS id=3013
NOTE: MARK has subscribed
Spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilephydb.ora is in old pre-11 format and compatible >= 11.0.0; converting to new H.A.R.D. compliant format.
Mon Dec 22 11:22:15 2014
NOTE: Loaded library: System
ORA-15025: could not open disk '/dev/asm-diskd'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
Mon Dec 22 11:22:15 2014
SUCCESS: diskgroup DATA was mounted
zhotmail 发表于 2014-12-22 11:25 static/image/common/back.gif
on Dec 22 11:19:40 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
NOTE: Loaded library: System
ORA-15025: could not open disk '/dev/asm-diskd'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
Mon Dec 22 11:22:15 2014
SUCCESS: diskgroup DATA was mounted
刘大是不是权限的问题的-- 可以确信 的是 “asm是按照你的那个帖子做的，” 并不是100%按照帖子做的， 所以出现了你认为的意外 Liu Maclean(刘相兵 发表于 2014-12-22 10:18 static/image/common/back.gif
如2楼
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Dec 22 12:40:10 2014
MMNL started with pid=18, OS id=3358
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Errors in file /u01/app/oracle/diag/rdbms/phydb/phydb/trace/phydb_asmb_3354.trc:
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
Mon Dec 22 12:41:02 2014
Starting background process ASMB
Mon Dec 22 12:41:02 2014
ASMB started with pid=23, OS id=3459
Liu Maclean(刘相兵 发表于 2014-12-22 11:32 static/image/common/back.gif
可以确信 的是 “asm是按照你的那个帖子做的，” 并不是100%按照帖子做的， 所以出现了你认为的意外 ...
http://www.oracledatabase12g.com/archives/%E5%9C%A8linux-6%E4%B8%8A%E4%BD%BF%E7%94%A8udev%E8%A7%A3%E5%86%B3rac-asm%E5%AD%98%E5%82%A8%E8%AE%BE%E5%A4%87%E5%90%8D%E9%97%AE%E9%A2%98.html
这个帖子的吧- - 就用的那个脚步啊 Liu Maclean(刘相兵 发表于 2014-12-22 11:32 static/image/common/back.gif
可以确信 的是 “asm是按照你的那个帖子做的，” 并不是100%按照帖子做的， 所以出现了你认为的意外 ...
对了那些磁盘没分区- - ，就直接用了，不会是这原因吧 肯定是遗漏了细节 Liu Maclean(刘相兵 发表于 2014-12-22 13:37 static/image/common/back.gif
肯定是遗漏了细节
不知道什么原因- -
页:
[1]