Oracle10gASM控制文件多路复用
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle10gASM控制文件多路复用,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3099字,纯文字阅读大概需要5分钟。
内容图文
![Oracle10gASM控制文件多路复用](/upload/InfoBanner/zyjiaocheng/549/0e75121a088a4b92af866de976e3336b.jpg)
1gt; 检查数据库,查看控制文件存放路径 SQLgt; startup Oracle instance started. Total System Global Area 230686720 byte
1> 检查数据库,查看控制文件存放路径
SQL> startup
Oracle instance started.
Total System Global Area 230686720 bytes
Fixed Size 1218676 bytes
Variable Size 71305100 bytes
Database Buffers 155189248 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> show parameter control;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DATA/oradb/controlfile/backup
.259.762002877 //控制文件名
SQL> shutdown immediate; //关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount; //打开数据库至nomount状态
ORACLE instance started.
Total System Global Area 230686720 bytes
Fixed Size 1218676 bytes
Variable Size 71305100 bytes
Database Buffers 155189248 bytes
Redo Buffers 2973696 bytes
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@node1 ~]$ rman target / //进入RMAN
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Sep 16 16:36:09 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: oradb (not mounted)
RMAN> restore controlfile to '+data/oradb/controlfile/backup.259.762002875' from '+data/oradb/controlfile/backup.259.762002877'; //利用数据库当前的控制文件,创建一个新的控制文件
Starting restore at 16-SEP-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: copied control file copy
Finished restore at 16-SEP-11
Recovery Manager complete.
RMAN> exit
[oracle@node1 ~]$ export ORACLE_SID=+ASM
[oracle@node1 ~]$ asmcmd //进入ASM实例命令
ASMCMD> +data/oradb/controlfile
ASMCMD> ls -ltr //查看新创建的控制文件名
Type Redund Striped Time Sys Name
CONTROLFILE HIGH FINE SEP 16 16:00:00 Y backup.259.762002877
CONTROLFILE HIGH FINE SEP 16 16:00:00 Y backup.265.762021421
ASMCMD> exit
[oracle@node1 ~]$ export ORACLE_SID=oradb
[oracle@node1 ~]$ sqlplus / as sysdba //进入数据库
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 16 16:38:30 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create pfile='/u01/oracle/product/10g/dbs/oradb.ora' from spfile; //创建数据库的pfile 参数文件
File created.
SQL> shutdown immediate; //关闭数据库
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> exit
内容总结
以上是互联网集市为您收集整理的Oracle10gASM控制文件多路复用全部内容,希望文章能够帮你解决Oracle10gASM控制文件多路复用所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。