Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 求教 rman 恢复

0 积分	0 好友	1 主题

发消息

[备份恢复] 求教 rman 恢复

1^#

发表于 2014-12-21 23:18:18 | 查看: 4393| 回复: 14

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

[grid@dg admin]$ 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

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2014-12-21 23:24:04

ORA-15081: failed to submit an I/O operation to a disk
给出rdbms和asm的alert.log

你确定该ASM能正常工作？

回复只看该作者道具举报

zhotmail

3^#

发表于 2014-12-21 23:26:13

Maclean Liu(刘相兵发表于 2014-12-21 23:24
ORA-15081: failed to submit an I/O operation to a disk
给出rdbms和asm的alert.log

ASMCMD> ls
DATA/
FLASH/
GRIDDG/
ASMCMD>
应该可以吧，望指教

回复只看该作者道具举报

zhotmail

4^#

发表于 2014-12-21 23:32:13

Maclean Liu(刘相兵发表于 2014-12-21 23:24
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>

回复只看该作者道具举报

zhotmail

5^#

发表于 2014-12-21 23:51:30

Maclean Liu(刘相兵发表于 2014-12-21 23:24
ORA-15081: failed to submit an I/O operation to a disk
给出rdbms和asm的alert.log

删了重新建一个，asm是按照你的那个帖子做的，

回复只看该作者道具举报

Liu Maclean(刘相兵

6^#

发表于 2014-12-22 10:18:45

如2楼

回复只看该作者道具举报

zhotmail

7^#

发表于 2014-12-22 10:30:48

Liu Maclean(刘相兵发表于 2014-12-22 10:18
如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

回复只看该作者道具举报

zhotmail

8^#

发表于 2014-12-22 11:25:29

Liu Maclean(刘相兵发表于 2014-12-22 10:18
如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

9^#

发表于 2014-12-22 11:30:38

zhotmail 发表于 2014-12-22 11:25
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
刘大是不是权限的问题的--

回复只看该作者道具举报

Liu Maclean(刘相兵

10^#

发表于 2014-12-22 11:32:53

可以确信的是 “asm是按照你的那个帖子做的，” 并不是100%按照帖子做的，所以出现了你认为的意外

回复只看该作者道具举报

zhotmail

11^#

发表于 2014-12-22 12:46:44

Liu Maclean(刘相兵发表于 2014-12-22 10:18
如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

回复只看该作者道具举报

zhotmail

12^#

发表于 2014-12-22 13:07:57

Liu Maclean(刘相兵发表于 2014-12-22 11:32
可以确信的是 “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
这个帖子的吧- - 就用的那个脚步啊

回复只看该作者道具举报