16

Just use asmcmd. For example: [oracle@oel61 ~]$ . oraenv ORACLE_SID = [+ASM] ? +ASM The Oracle base remains unchanged with value /u01/app/oracle [oracle@oel61 ~]$ asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 ...


6

This assumes that you've already partitioned the presented disk(s) (and will be using /dev/sd[whatever]N), and that you're using asmlib. There will be a kernel module loaded if you are: [root@oel61 disks]# lsmod | grep oracle oracleasm 53865 1 [root@oel61 disks]# As root, scan for candidate disks: [root@oel61 ~]# /etc/init.d/oracleasm ...


5

Start the instance in MOUNT mode, delete the logs, then open the database. $ rman target / RMAN> startup mount RMAN> delete force noprompt archivelog all; RMAN> alter database open;


4

du of asmcmd doesn't support this, just put it in a loop. $ dg=fra; for dir in $(asmcmd ls $dg); do echo $dg/$dir; asmcmd du $dg/$dir; done


3

In case one does not want to use AMM MEMORY_MAX_TARGET setting has to be not set at all: alter system reset memory_target; alter system reset memory_max_target;


3

i've found the definitive answer from the oracle docs http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC109 in the Oracle Database Standard Edition and Oracle Real Application Clusters (Oracle RAC) section, it specifies "Oracle Automatic Storage Management is required for creating and managing all Oracle database file types. Raw ...


3

The recommendation is to have log switches occur a few times an hour. If you have a 100 log switches an hour with 50MB redo logs, you need e.g 1GB redo logs for 5 log switches/hour. 100*50 MB redo/hour for a 6.5GB database is unusually much though. You can add the new logs, e.g: ALTER DATABASE ADD LOGFILE THREAD 1 SIZE 1G; ALTER DATABASE ADD LOGFILE THREAD ...


3

KISS principle: Do you have the storage that itself offers you the required availability level (i.e. disk array)? And you do have RMAN backups with a recovery catalog (you need it anyway, for DUPLICATE), don't you? If yes and yes, my version is: no secondary control file at all, one member per each redo group, as there are no secondary datafiles (quite ...


3

I have drop this diskgroup from target host and then with " oracleasm deletedisk " This was a mistake. You removed the metadata describing the content. You should have just simply detached the disks, then attach to the new host, leaving the disks intact.


3

Imagine the following. On 2019-08-19 18:00:00 you started a full online database backup that took 5 minutes. This backup included all the datafiles listed above. Backuppieces created from this operation: arch1.bkp - backup of archivelogs that existed before starting the full database backup + the last archivelog that was created as a result of the ...


2

Just make sure auto controlfile backup is turned on. If you added or dropped a datafile(s) before the controlfile was backed up, and you had a hardware failure which resulted in the single CF not be accessible, it would be a pain to restore...not impossible, just a huge pain and a time sink during a sensitive time resuming services. Cheers, JD


2

Why not just create luns on the new storage, with same size as on old storage and add them to the existing disk groups. Next drop the old disks from the disk group and when the re-balance is over, your system is migrated to the new storage, without any downtime. Works like a charm. ASM is way smarter than a filesystem.


2

Transportable tablespaces and asmcmd cp command should do the trick. Prepare transportable tablespaces metadata set. Copy expdp file to location accessible by impdp from destination database. asmcmd cp datafiles to new location. Import TT metadata set. If your ASM diskgroup uses some storage device with several disks then you should be able to improve ...


2

No need to de-install Oracle rdbms software. Just install and configure ASM. If you have enough storage available you can copy your database to ASM using rman.


2

The Oracle docs for 11.2 ASM migration are here: http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_rman.htm#OSTMG12000 These explain the process that you need to go through to migrate to ASM from filesystem storage.


2

First of all, I checked that there were no extents on DISK1. $ . oraenv ORACLE_SID = [+ASM1] ? SQL> select PXN_KFFXP, -- physical extent number XNUM_KFFXP, -- virtual extent number DISK_KFFXP, -- disk number AU_KFFXP -- allocation unit number from X$KFFXP where DISK_KFFXP=1; no rows selected I cleared the ...


2

Without knowing what kernel you're running, I can't say for sure, but my guess is that you're running a recent UEK kernel, and it has the kernel module built in.


2

Try this... col gname form a10 col dbname form a10 col file_type form a14 SELECT gname, dbname, file_type, round(SUM(space)/1024/1024) mb, round(SUM(space)/1024/1024/1024) gb, COUNT(*) "#FILES" FROM ( SELECT gname, regexp_substr(full_alias_path, '[[:alnum:]_]*',1,4) dbname, file_type, ...


2

Your permissions are incorrect. Oracle recommends role separation, which it appears you've followed by creating separate oracle and grid users. But I'm willing to wager that your ORACLE_HOME is under /u01/app/database or similar, which means that the chmod and chown commands you ran also changed permissions and ownership on the database home, too. This ...


2

You won't need downtime just to add additional redo logs to your redo groups. Take a look at this: Oracle Configuration Best Practices And then look at this: Creating Redo Log Groups and Members You will need downtime to add additional control files: Creating Additional Copies, Renaming, and Relocating Control Files


2

First of all, people often fall for this, but high log file sync waits do not necessarily mean I/O problem. Second, this could be really troublesome, if you have many physical devices in the ASM diskgroup where your redo logs are, because the extents of your files will be evenly distributed on several disks. Anyway, you need to find the ASM diskgroup ...


2

Oracle RAC requires a clustered file system: ASM comes with the database ASM provides a clustered file system ASM was built specifically to do this Anything else would be an additional cost 3rd party product that you would have to integrate and get working with your Oracle RAC.


2

ASM is not magic. Each disk has a maximum number of IOPS it can support. Each disk has a maximum throughput. The more spindles (HDDs) you have, the more I/O you can get. If one disk decides to take a permanent vacation and you don't have data on another disk.... I really hope you have viable tested backups. From my tests, partitioning a single HDD into ...


1

Cause The security limits requirements were not set according the recommended values The message [client(15674)]CRS-10001:CRS-6021: No msg for has:crs-6021 [n][65536] makes think about the value recommended for oracle hard nofile 65536 in /etc/security/limits.conf Then these messages makes think that probably the other parameters in /etc/security/limits....


1

This is how I understand how asmlib works. Lets way you have a disk /dev/sdc but the name is not persistent and it changes between reboots. So user-space asmlib tool writes a small header onto beginning of the disk. This header contains volume name like VOL1. Then the kernel part of the asmlib will create a block device named /dev/oracleasm/disks/VOL1. All ...


1

You can create pfile to set asm_diskstring. $ vi asmpfile.ora instance_type=asm asm_diskstring=path_to_asmdisks Then can start asm instance using this pfile and later can create spfile from pfile.


1

First find the disk names and paths: select name, failgroup, path, os_mb, total_mb, free_mb from v$asm_disk; After you found the ASM generated name for the disk you want to shrink, reduce it in ASM to the desired size (I will assume it is called DATA1_0002: alter diskgroup data1 resize disk DATA1_0002 size 90G; This starts a rebalance, wait until the ...


1

ORA-15041: diskgroup space exhausted Cause: At least one disk in the diskgroup is out of space. Action: If all disks are evenly balanced, add more disks to the diskgroup. According to the log provided in the question, i found that it was unable to complete the archiving operation as the asm diskgroup '+FRA_DATA' is full. The DML operation on large table ...


1

ASM metadata describes the location of the password file on the ASM disk. With that information, even you can read it directly from the disk, with the help of kfed (which is installed with the Oracle binaries) and OS specific tools for reading the disk directly, for example dd, without using ASM. Same goes for the SPFILE (since 11g). More about this topic: ...


1

Check if autostart for Oracle Restart is enabled: $ cat /etc/oracle/scls_scr/$HOSTNAME/oracle/ohasdstr enable If it is not enabled, then enable it: crsctl enable has Check if ASM autostart is enabled: crsctl stat res ora.asm If ASM is not registered in GI, add it with: srvctl add asm ... Check if used diskgroups are registered: srvctl status ...


Only top voted, non community-wiki answers of a minimum length are eligible