Note all file# numbers that are returned. Then, while in sqlplus connected to the database as sys/password as sysdba. Type the following SQL (examples use file# 12 and 15): Alter database datafile 12 online; Alter database datafile 15 online; After all files are back online, continue to...
In above output is easy identify what SNAP_ID to use without keep trying and getting ORA-20200 or by reading a huge list of snaps. The above query is NOT valid to get SNAP_ID to generate AWR Global RAC Report. Soon as possible I will post a Query to generate same output to easy ou...
Example – For achieving high availability in goldenate for Oracle RAC, we can use ACFS for goldengate relate files. In this article, we will show how to create a ACFS file system in oracle RAC using command line. ENVIRONMENT DETAILS: ORACLE GRID VERSION – 12.1.0.2 NODES – NODE1 , NOD...
Change %systemdrive% path from C:\Windows to D:\Windows in windows server 2008 during OS installation ? change AD security group name change client dns remotely by cmd change date format for domain user change dns port Change format of phone numbers in AD using powershell Change From Roaming...
We are only specifying the name of the diskgroup, so Oracle will create an OMF (Oracle Managed File). Use ASMCMD or sqlplus to identify the name assigned to the controlfile 4. On the ASM instance, identify the name of the controlfile: ...
You may not know that but you are not allowed to delete recovery partition in Windows Disk Management but you can use DISKPART command to delete partitions from command prompt (of course, you are doing this on your own risk): 1. Run Command Prompt (CMD) as administrator. 2. In CMD run...
Provide input in sqlplus script Hi guys. I m creating scripts which input multiple value , inside sqlplus script when it prompt/accept do anybody know how to provide multiple value inside sqlplus script when it prompt. like, enter value for first: enter value for second: enter value "save ...
The steps involved in moving a datafile from a diskgroup to another is as given below. 1) Identify the data file to be moved. 2) Identify the diskgroup on to which the file has to be moved. 3) Take the file offline. 4) Copy the file to new diskgroup using Either RMAN or DBMS_FIL...
transport_datafilesis used to specify the data files that make you the tablespace you are transporting. Specify the parameter multiple times to specify more data files. You can useasmcmdto get the data file paths and names. Data Pump Ignorable Errors ...
Now with all records returned, Export will use the data in the grid instead of re-querying the database. Clear as mud? But WHY does SQL Developer force the 2nd query execution? Good question. If you do force all of the rows back into the grid, you are going to be cons...