oracle 迁移数据库到asm

最新推荐文章于 2024-06-13 21:12:59 发布
最新推荐文章于 2024-06-13 21:12:59 发布
阅读量158 收藏
点赞数
文章标签： 数据库 操作系统

打上对应的rpm包


安装asm lib
[root@ora10g asmpkg]# /etc/init.d/oracleasm  configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []:
Default group to own the driver interface []:
Start Oracle ASM library driver on boot (y/n) [n]:
[root@ora10g asmpkg]# /etc/init.d/oracleasm  configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: dba
Default group to own the driver interface []:
[root@ora10g asmpkg]# /etc/init.d/oracleasm  configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [  OK  ]
Scanning the system for Oracle ASMLib disks: [  OK  ]
[root@ora10g asmpkg]# lsmod |grep asm
oracleasm              48020  1


[root@ora10g asmpkg]# cat /proc/filesystems
nodev   sysfs
nodev   rootfs
nodev   bdev
nodev   proc
nodev   sockfs
nodev   binfmt_misc
nodev   usbfs
nodev   usbdevfs
nodev   futexfs
nodev   tmpfs
nodev   pipefs
nodev   eventpollfs
nodev   devpts
        ext2
nodev   ramfs
nodev   hugetlbfs
        iso9660
nodev   relayfs
nodev   mqueue
        ext3
nodev   rpc_pipefs
nodev   autofs
nodev   asmdisk
nodev   oracleasmfs


[root@ora10g ~]# fdisk /dev/sdd
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.


The number of cylinders for this disk is set to 1044.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
   (e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): m
Command action
   a   toggle a bootable flag
   b   edit bsd disklabel
   c   toggle the dos compatibility flag
   d   delete a partition
   l   list known partition types
   m   print this menu
   n   add a new partition
   o   create a new empty DOS partition table
   p   print the partition table
   q   quit without saving changes
   s   create a new empty Sun disklabel
   t   change a partition's system id
   u   change display/entry units
   v   verify the partition table
   w   write table to disk and exit
   x   extra functionality (experts only)

Command (m for help): p

Disk /dev/sdd: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1044, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-1044, default 1044):
Using default value 1044

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

上述方式格式 fdisk /dev/sdc


创建disk
[root@ora10g ~]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdd1
Marking disk "VOL2" as an ASM disk: [  OK  ]

[root@ora10g init.d]#  /etc/init.d/oracleasm createdisk VOL3 /dev/sdc1
Marking disk "VOL3" as an ASM disk: [  OK  ]

 

 

 

 

检查
[root@ora10g disks]# /etc/init.d/oracleasm listdisks
VOL2
VOL3


[root@ora10g disks]# /etc/init.d/oracleasm querydisk VOL2
Disk "VOL2" is a valid ASM disk
[root@ora10g disks]# /etc/init.d/oracleasm querydisk VOL3
Disk "VOL3" is a valid ASM disk


启动css，asm需要css服务支持
root@ora10g bin]# ./localconfig all
Usage:./localconfig [add] [delete] [ reset ]   [-silent]   [-paramfile ][root@ora10g bin]# ./localconfig add
/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
        ora10g
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)


[root@ora10g bin]# su - oracle
[oracle@ora10g ~]$ orapwd file=orapw+ASM ENTRIES=5 password=88711009
[oracle@ora10g ~]$ export ORACLE_SID=+ASM


[oracle@ora10g ~]$ cd $ORACLE_HOME/dbs
[oracle@ora10g dbs]$ pwd
/oracle/oracle/product/ora10g/database/dbs
[oracle@ora10g dbs]$ vi init+ASM.ora

 

asm  pfile defualt存储$ORACLE_HOME/dbs


instance_type=asm
large_pool_size=12M
remote_login_passwordfile=exclusive
asm_diskstring='/dev/oracleasm/disks/*'
asm_diskgroups='XHDG1'
background_dump_dest=/oracle/oracle/admin/+ASM/bdump
core_dump_dest=/oracle/oracle/admin/+ASM/cdump
user_dump_dest=/oracle/oracle/admin/+ASM/udump

#建立asm password文件
orapwd file=orapw+ASM entries=5 password=a123
export ORACLE_SID=+ASM
[oracle@ora10g +ASM]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 3 18:43:04 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area   83886080 bytes
Fixed Size                  1265912 bytes
Variable Size              57454344 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted

 


SQL> create spfile from pfile;

File created.


创建diskgroup
SQL> create diskgroup dg1 external redundancy disk '/dev/oracleasm/disks/VOL3';

Diskgroup created.

 

SQL> alter diskgroup XHDG1 add disk '/dev/oracleasm/disks/VOL2';

Diskgroup altered.

SQL> select total_mb,free_mb,USABLE_FILE_MB ,name from v$asm_diskgroup;

  TOTAL_MB    FREE_MB USABLE_FILE_MB NAME
---------- ---------- -------------- ------------------------------
     16378      16326          16326 XHDG1

SQL> select path, free_mb,total_mb,state from v$asm_disk;

PATH
--------------------------------------------------------------------------------
   FREE_MB   TOTAL_MB STATE
---------- ---------- --------
/dev/oracleasm/disks/VOL3
      7660       8189 NORMAL

/dev/oracleasm/disks/VOL2
      8163       8189 NORMAL


SQL> exit


开始迁移
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


rman 备份target
[oracle@ora10g disks]$ export ORACLE_SID=xh
[oracle@ora10g disks]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 4 14:31:51 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: XH (DBID=3103799895)

RMAN>  backup as copy database format '+xhdg1';

Starting backup at 04-MAR-10
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=145 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/oracle/oracle/oradata/xh/users01.dbf
output filename=+XHDG1/xh/datafile/users.256.712765927 tag=TAG20100304T143202 recid=23 stamp=712766289
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:06:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/oracle/oracle/oradata/xh/system01.dbf
output filename=+XHDG1/xh/datafile/system.257.712766299 tag=TAG20100304T143202 recid=24 stamp=712766317
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/oracle/oracle/oradata/xh/sysaux01.dbf
output filename=+XHDG1/xh/datafile/sysaux.258.712766323 tag=TAG20100304T143202 recid=25 stamp=712766334
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/oracle/oracle/oradata/xh/undotbs01.dbf
output filename=+XHDG1/xh/datafile/undotbs1.259.712766339 tag=TAG20100304T143202 recid=26 stamp=712766343
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=+XHDG1/xh/controlfile/backup.260.712766345 tag=TAG20100304T143202 recid=27 stamp=712766346
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 04-MAR-10
channel ORA_DISK_1: finished piece 1 at 04-MAR-10
piece handle=+XHDG1/xh/backupset/2010_03_04/nnsnf0_tag20100304t143202_0.261.712766347 tag=TAG20100304T143202 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 04-MAR-10

RMAN> exit


Recovery Manager complete.

修改target 参数（其实就是设置omf）
[oracle@ora10g disks]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 4 14:39:37 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system set db_create_file_dest='+XHDG1';

System altered.

SQL> alter system set db_create_online_log_dest_1='+XHDG1';

System altered.

SQL> alter system set db_recovery_file_dest='+XHDG1';

System altered.

SQL> select group#,member from v$logfile;

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------
         3
/oracle/oracle/oradata/xh/redo03.log

         2
/oracle/oracle/oradata/xh/redo02.log

         1
/oracle/oracle/oradata/xh/redo01.log


SQL> alter database add logfile member member '+XHDG1' tp group 1;
alter database add logfile member member '+XHDG1' tp group 1
                                  *
ERROR at line 1:
ORA-02236: invalid file name


SQL> alter database add logfile member  '+XHDG1' tp group 1;
alter database add logfile member  '+XHDG1' tp group 1
                                            *
ERROR at line 1:
ORA-00946: missing TO keyword


SQL> alter database add logfile member  '+XHDG1' tO group 1;

Database altered.

SQL> alter database add logfile member  '+XHDG1' to group 2;

Database altered.

SQL> alter database add logfile member  '+XHDG1' to group 3;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> desc v$log;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER
 THREAD#                                            NUMBER
 SEQUENCE#                                          NUMBER
 BYTES                                              NUMBER
 MEMBERS                                            NUMBER
 ARCHIVED                                           VARCHAR2(3)
 STATUS                                             VARCHAR2(16)
 FIRST_CHANGE#                                      NUMBER
 FIRST_TIME                                         DATE

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 ACTIVE
         3 CURRENT

SQL> alter database drop logfile member '/oracle/oracle/oradata/xh/redo01.log';
alter database drop logfile member '/oracle/oracle/oradata/xh/redo01.log'
*
ERROR at line 1:
ORA-00362: member is required to form. a valid logfile in group 1
ORA-01517: log member: '/oracle/oracle/oradata/xh/redo01.log'


SQL> alter system checkpoint;

System altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 INACTIVE
         3 CURRENT

SQL> alter database drop logfile member '/oracle/oracle/oradata/xh/redo01.log';
alter database drop logfile member '/oracle/oracle/oradata/xh/redo01.log'
*
ERROR at line 1:
ORA-00362: member is required to form. a valid logfile in group 1
ORA-01517: log member: '/oracle/oracle/oradata/xh/redo01.log'


SQL> alter database drop logfile member '/oracle/oracle/oradata/xh/redo02.log';
alter database drop logfile member '/oracle/oracle/oradata/xh/redo02.log'
*
ERROR at line 1:
ORA-00362: member is required to form. a valid logfile in group 2
ORA-01517: log member: '/oracle/oracle/oradata/xh/redo02.log'


SQL> alter database drop logfile member '/oracle/oracle/oradata/xh/redo03.log';
alter database drop logfile member '/oracle/oracle/oradata/xh/redo03.log'
*
ERROR at line 1:
ORA-01609: log 3 is the current log for thread 1 - cannot drop members
ORA-00312: online log 3 thread 1: '/oracle/oracle/oradata/xh/redo03.log'
ORA-00312: online log 3 thread 1: '+XHDG1/xh/onlinelog/group_3.264.712766587'


SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 INACTIVE
         3 CURRENT

SQL> alter database drop logfile member '/oracle/oracle/oradata/xh/redo01.log';
alter database drop logfile member '/oracle/oracle/oradata/xh/redo01.log'
*
ERROR at line 1:
ORA-00362: member is required to form. a valid logfile in group 1
ORA-01517: log member: '/oracle/oracle/oradata/xh/redo01.log'


SQL> desc v$logfile;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER
 STATUS                                             VARCHAR2(7)
 TYPE                                               VARCHAR2(7)
 MEMBER                                             VARCHAR2(513)
 IS_RECOVERY_DEST_FILE                              VARCHAR2(3)

SQL> col member for a30
SQL> select group#,memeber,status from v$logfie;
select group#,memeber,status from v$logfie
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select group#,memeber,status from v$logfile;
select group#,memeber,status from v$logfile
              *
ERROR at line 1:
ORA-00904: "MEMEBER": invalid identifier


SQL> select group#,member,status from v$logfile;

    GROUP# MEMBER                         STATUS
---------- ------------------------------ -------
         3 /oracle/oracle/oradata/xh/redo
           03.log

         2 /oracle/oracle/oradata/xh/redo
           02.log

         1 /oracle/oracle/oradata/xh/redo STALE
           01.log

         1 +XHDG1/xh/onlinelog/group_1.26 INVALID
           2.712766579

    GROUP# MEMBER                         STATUS
---------- ------------------------------ -------

         2 +XHDG1/xh/onlinelog/group_2.26 INVALID
           3.712766585

         3 +XHDG1/xh/onlinelog/group_3.26
           4.712766587


6 rows selected.

SQL> alter system switch logfile;

System altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 CURRENT
         2 INACTIVE
         3 ACTIVE

SQL> alter system checkpoint;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system checkpoint;

System altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 CURRENT
         3 INACTIVE

SQL> alter database drop logfile member '/oracle/oracle/oradata/xh/redo01.log';

Database altered.

SQL> alter database drop logfile member '/oracle/oracle/oradata/xh/redo03.log';

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system checkpoint;

System altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 INACTIVE
         3 CURRENT

SQL> alter database drop logfile member '/oracle/oracle/oradata/xh/redo02.log';

Database altered.

redo迁就是在原组上add member(配置了omf会建立在asm中) 然后切换删除不在asm中的member，但状态必须为inactive,若为active表示redo中对应的dirty buffer还未写入disk 手动执行alter system checkpoint触发检查点强制写入
，我遇到的问题是add后状态也为inactive，但就是删除不了 不在asm中的member，最后全切换一变 让add 的member都使用了下才可以


SQL> select group#,member,status from v$logfile;

    GROUP# MEMBER                         STATUS
---------- ------------------------------ -------
         1 +XHDG1/xh/onlinelog/group_1.26
           2.712766579

         2 +XHDG1/xh/onlinelog/group_2.26
           3.712766585

         3 +XHDG1/xh/onlinelog/group_3.26
           4.712766587


SQL> select ts#,name from v$tempfile;

       TS#
----------
NAME
--------------------------------------------------------------------------------
         3
/oracle/oracle/oradata/xh/temp01.dbf


SQL> alter tablespace temp add tempfile size 100m;

Tablespace altered.

SQL> select ts#,name from v$tempfile;

       TS#
----------
NAME
--------------------------------------------------------------------------------
         3
+XHDG1/xh/tempfile/temp.269.712767395

         3
/oracle/oracle/oradata/xh/temp01.dbf


SQL> alter database tempfile '/oracle/oracle/oradata/xh/temp01.dbf' drop;

Database altered.

SQL> select ts#,name from v$tempfile;

       TS#
----------
NAME
--------------------------------------------------------------------------------
         3
+XHDG1/xh/tempfile/temp.269.712767395


SQL> show parameter controlfile
SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /oracle/oracle/oradata/xh/cont
                                                 rol01.ctl, /oracle/oracle/orad
                                                 ata/xh/control02.ctl, /oracle/
                                                 oracle/oradata/xh/control03.ct
                                                 l

 

SQL> alter system set control_files='+XHDG1/xh/controlfile/control01','+XHDG1/xh/controlfile/control02','+XHDG1/xh/controlfile/control03' scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  268435456 bytes
Fixed Size                  1266944 bytes
Variable Size              96471808 bytes
Database Buffers          163577856 bytes
Redo Buffers                7118848 bytes
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ora10g disks]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 4 15:01:14 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: xh (not mounted)

RMAN> restore controlfile from '/oracle/oracle/oradata/xh/control01.ctl';

Starting restore at 04-MAR-10
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
output filename=+XHDG1/xh/controlfile/control01
output filename=+XHDG1/xh/controlfile/control02
output filename=+XHDG1/xh/controlfile/control03
Finished restore at 04-MAR-10

RMAN> exit


Recovery Manager complete.
[oracle@ora10g disks]$ alter database mount;
-bash: alter: command not found
[oracle@ora10g disks]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 4 15:02:33 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database mount;

Database altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ora10g disks]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 4 15:02:42 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: XH (DBID=3103799895, not open)

RMAN> switch database to copy;

using target database control file instead of recovery catalog
datafile 1 switched to datafile copy "+XHDG1/xh/datafile/system.257.712766299"
datafile 2 switched to datafile copy "+XHDG1/xh/datafile/undotbs1.259.712766339"
datafile 3 switched to datafile copy "+XHDG1/xh/datafile/sysaux.258.712766323"
datafile 4 switched to datafile copy "+XHDG1/xh/datafile/users.256.712765927"

RMAN> recover database;

Starting recover at 04-MAR-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=158 devtype=DISK

starting media recovery

archive log thread 1 sequence 50 is already on disk as file +XHDG1/xh/archivelog/2010_03_04/thread_1_seq_50.265.712766595
archive log thread 1 sequence 51 is already on disk as file +XHDG1/xh/archivelog/2010_03_04/thread_1_seq_51.266.712767261
archive log thread 1 sequence 52 is already on disk as file +XHDG1/xh/archivelog/2010_03_04/thread_1_seq_52.267.712767273
archive log thread 1 sequence 53 is already on disk as file +XHDG1/xh/archivelog/2010_03_04/thread_1_seq_53.268.712767289
archive log filename=+XHDG1/xh/archivelog/2010_03_04/thread_1_seq_50.265.712766595 thread=1 sequence=50
archive log filename=+XHDG1/xh/archivelog/2010_03_04/thread_1_seq_51.266.712767261 thread=1 sequence=51
media recovery complete, elapsed time: 00:00:07
Finished recover at 04-MAR-10

RMAN> exit


Recovery Manager complete.
[oracle@ora10g disks]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 4 15:03:36 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database open;

Database altered.

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
+XHDG1/xh/controlfile/control01
+XHDG1/xh/controlfile/control02
+XHDG1/xh/controlfile/control03

SQL> select name,status from v$datafile;

NAME
--------------------------------------------------------------------------------
STATUS
-------
+XHDG1/xh/datafile/system.257.712766299
SYSTEM

+XHDG1/xh/datafile/undotbs1.259.712766339
ONLINE

+XHDG1/xh/datafile/sysaux.258.712766323
ONLINE


NAME
--------------------------------------------------------------------------------
STATUS
-------
+XHDG1/xh/datafile/users.256.712765927
ONLINE


SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+XHDG1/xh/onlinelog/group_1.262.712766579
+XHDG1/xh/onlinelog/group_2.263.712766585
+XHDG1/xh/onlinelog/group_3.264.712766587

SQL> select name,status from v$tempfile;

NAME
--------------------------------------------------------------------------------
STATUS
-------
+XHDG1/xh/tempfile/temp.269.712767395
ONLINE


SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ora10g disks]$ export ORACLE_SID=+ASM
[oracle@ora10g disks]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  EXTERN  N      N         512   4096  1048576     16378     5546                0            5546              0  XHDG1/
ASMCMD> exit
[oracle@ora10g disks]$ export ORACLE_SID=xh
[oracle@ora10g disks]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 4 15:05:14 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: XH (DBID=3103799895)

RMAN> delete noprompt backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
9       13      1   1   AVAILABLE   DISK        +XHDG1/xh/backupset/2010_03_04/nnsnf0_tag20100304t143202_0.261.712766347
deleted backup piece
backup piece handle=+XHDG1/xh/backupset/2010_03_04/nnsnf0_tag20100304t143202_0.261.712766347 recid=9 stamp=712766347
Deleted 1 objects


RMAN> exit


Recovery Manager complete.
[oracle@ora10g disks]$ export ORACLE_SID=+ASM
[oracle@ora10g disks]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  EXTERN  N      N         512   4096  1048576     16378     5547                0            5547              0  XHDG1/

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

转载于:http://blog.itpub.net/12020513/viewspace-629074/

cuiye1492
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
ORA-02236: invalid file name -＞ 开启OMF
喝醉酒的小白
07-01 1万+
ORA-39083，ora-02236错误处理
weixin_61212661的博客
12-20 781
此时这个错误主要关注的是ora-02236，根据mos。注意:具体目录位置按照数据库实际数据文件目录设定。impdp数据泵迁移数据时会遇到大量的。修改完成后重启数据库。
oracle 整库同步报错
gs80140的专栏
09-25 1616
报错1 ORA-39083: Object type TABLESPACE failed to create with error: ORA-02236: invalid file name Failing sql is: CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 26214400,SIZE 524288000 AUTOEXTEND ON ...
Oracle Express版本的使用及 如何用SQLDeveloper连接XE
shi_ly的专栏
07-06 936
Oracle XE是Oracle的免费版，跟收费版相比，自然有些限制。 但是，在教学，自学等场合，还是很好的。 笔者在本机Windows10上装了Oracle XE 18c,然后就开始一顿折腾了。 1，DBA账户 这个就是在安装的时候，让你输入密码的，只输入一个密码，但是是3个账户公用。 就是System，Sys，PDBAdmin。 2，创建完之后使用SqlDeveloper或Sqlplus登录 --SqlDeveloper-- 连接类型：Basic 角色：Default 主机名：.
oracle数据库dmp的迁移
我的博客
04-17 648
Oracle数据库迁移的步骤 1. 登录后台 sqlplus / as sysdba; 2.创建路径 create directory expdp_dir as 'E:\app\Administrator\expdp_dmp'; 3.导出当前数据库的dmp文件 用户/密码：一般具有dba的权限，这样才能保证导出的权限完整 expdp sys/123456 directory=expdp_di...
oracle数据库迁移
搞怪的索引
07-30 3787
同版本数据库，同操作系统数据库的迁移； 迁移思路是，在目标操作系统上，按照源数据库的$ORACLE_BASE来安装一个数据库软件，然后拷贝相应的源数据库的数据文件、密码文件、spfile文件、相应dump的文件夹到迁移的库上来完成迁移； 步骤如下: 首先查看源数据的相应信息，为迁移做准备； 源数据库： SQL> select * from v$version; BANNER
迁移Oracle数据库文件到ASM_数据库技术
05-26
迁移Oracle数据库文件到ASM_数据库技术
Oracle数据库从aix裸设备到ASM存储的迁移过程.pdf
05-18
Oracle数据库从aix裸设备到ASM存储的迁移过程.pdf
Oracle数据库迁移升级详细步骤.docx
07-12
Oracle数据库迁移升级是指将现有的Oracle数据库从低版本升级到高版本，或者将数据库从一台服务器迁移到另一台服务器，以提高数据库性能、安全性和可扩展性。以下是Oracle数据库迁移升级的详细步骤： 操作系统安装及...
Oracle-11g-R2-RAC-with-ASM存储迁移-手记.docx
10-29
本文详细介绍如何讲oracle rac的数据库数据进行迁移备份，配有图文，适合做做实验在再去实践
利用RMAN将数据库从文件系统迁移到ASM
08-27
在迁移数据库文件到ASM存储系统中，我们还需要增加新的ONLINE REDOLOGS到ASM磁盘组中。ONLINE REDOLOGS是数据库中的日志文件，我们需要将其迁移到ASM磁盘组中，以便提高数据库的性能。 十一、最后删除原来的数据库...
Oracle数据库 - oracle常用命令(管理创建用户、创建表空间）
zs1972551648的博客
04-03 2541
常用命令管理Oracle数据库（使用过可视化工具不熟，都会感觉命令行更好用）
ORA-1157, cannot identify/lock data file - see DBWR trace file
兼容并蓄终宽阔，若谷虚怀鱼自游
11-11 2705
ORA-1157, "cannot identify/lock data file %s - see DBWR trace file"引起的原因：因为数据文件已经在被使用了从而导致数据库的后台进程不能找到相应的数据文件或者不能锁定相应的数据文件，这样数据库将禁止访问这些数据文件而其他的数据文件则没有影响。伴随这个错误操作系统将会提示是哪个数据文件不能被识别。ORA-01157错误一般和ORA-01
AIX ORACLE IMP异常扩表空间一例
weixin_34266504的博客
10-29 147
  AIX ORACLE IMP异常扩表空间一例   一、起因 IMP数据倒入时发生ORA-01659错误： IMP-00003: ORACLE error 1659 encountered ORA-01659: unable to allocate MINEXTENTS beyond 128 in tablespace USERS   二、分析 1、查询USERS表空间使用状况...
常见oracle错误代码ORA-xxxxx及其解决方法
热门推荐
mingo_敏
07-03 1万+
本文地址：ORA-00001: 违反唯一约束条件 主键重复。ORA-00900: 无效 SQL 语句 错误原因：错误换行，错误使用其他数据库或者windows命令 例： SQL> shutdown immediate; shutdown immediate ORA-00900: 无效 SQL 语句 ——解决方法———————————————— plsql没有此命令　应该是在sqlplus里
冷备份恢复数据库，并修改db_name（重建控制文件方式），多种错误方式演练
cobraqing7177的博客
04-29 395
以下我只给出具体步骤以及出现问题的解决方法，没有额外的文字说明（有点懒！呵呵）SQL> CREATE CONTROLFILE REUSE DATABASE "kyws" NORESETLOGS NOARCHIVELOG2 ...
oracle redo01. log,redo01.log恢复问题
weixin_39725650的博客
04-04 638
背景： 在正常oracle11g正常open状态，我操作系统mv 了redo01.log然后rman不知道该怎么恢复。可是通过下面的脚本居然重建了redo01.log我不知道哪一步能重建的.看哪个日志可以知道呢？ps：操作过程如下：SQL> select member from v$logfile;MEMBER-----------------------------------------...
【Qt实现录频】
最新发布
m0_45463480的博客
06-13 164
请注意，这只是一个简单的示例代码，实际应用中你可能需要处理更多的细节，如捕获不同视频格式、处理录制过程中的错误等。希望这个示例对你有所帮助，另外你也可以在Qt官方文档中找到更多关于Qt Multimedia模块的详细信息。在Qt中实现录制视频可以通过使用Qt Multimedia模块来实现。在上面的示例中，VideoRecorder类提供了一个简单的界面，其中包括一个用于录制视频的按钮。当按钮被点击时，toggleRecord()槽函数将会启动或停止录制。
oracle 11g rac asm安装部署手册
12-23
Oracle 11g RAC ASM是一种高可用性和性能的解决方案，它能够提供数据库的集群化和自动存储管理。在安装和部署过程中，需要按照一定的步骤进行操作，下面将详细介绍。 首先，要确保系统环境满足Oracle 11g RAC ASM的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值