Server Administration :: Find Or Set New Oracle Instance Name On Backup Server
Sep 22, 2010
We performed image copy of production Oracle server (OS and instances) to a backup server. After a few weeks, we try to restore a latest Oracle database backup from production server to backup server. As we know, Oracle instance must be unique on the network.
Even we log on to backup server and bring up the instance, I think that still point to production instance since all init file, TNSNAMES.ora and listener file are still same. If we restore the database, we will end up bring down the production instance and restore on top of productions. How to change instance name on backup server including TNSNAMES, sqlnet, listener files in order for us to restore Oracle database from production to backup server?
I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server. 2. I invoked "sqlplus" from another unix box to login to the database. 3. I found that the process id (ps -ef |grep sqlplus). 4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID, SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM, SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID FROM SYS.GV_$PROCESS, SYS.GV_$SESSION WHERE SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST' and SYS.GV_$SESSION.MACHINE like '%hostname%'
I want to install oracle 11.2.0.2 single instance database on AIX 6.1, does oracle recommend separate OS user for grid infrastructure and for oracle install? how many groups I need to have for these users like oinstall, dba etc?
- one ASM instance - X DB instances - each DB instance uses 2 or more dedicated diskgroups from the ASM instance - there is one diskgroup named FREEDISK that contains spare disks
On each DB instance you can see:
- the list and global parameters of all diskgroups using v$asm_diskgroup view - the list and parameters of all disks the instance is using with v$asm_disk view
So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?
We imaged production Oracle Server ( OS and Oracle and everything) to a backup server. I guess my question shall be how do we access the local instance via this backup server. When we log on to this backup server, we ran sqlplus and connected to the instance but it ended up to connect to production instance. Shall we stopped local Oracle services and change init.ora, tnsname, or listener files in order not conflict with production instance?
My production database is about 900 GB in size but the actual data in our database is only approx 600Gb it means 300GB is a deleted data and not fragmented, as per my understanding the best way to resolve fragmentation is Import/Export but we can go for this option because its a very time taking process.
We are taking full database backup using RMAN every week and also going to upgrade our production database from Oracle SE to Oracle EE edition using the same full database RMAN backup, as i know Rman is also not backup of those blocks which not containing any data , it means if we will use Rman full backup to setup our new EE database it will only 600GB of data not 900GB or there is only Export/Import to remove fragmentation.
SQL*Plus: Release 11.2.0.2.0 Production on Sun Sep 8 19:10:30 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance. -------------------------------------- SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '/home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs/' ORA-27037: unable to obtain file status Additional information: 5
What seems to be a problem here? I've been trying to fix this for few weeks.
How to create DBMS_SCHEDULER job for particular instance,we have 3 instance we want to schedule few jobs in Instance 2,how to schedule in Particular instance.
I've to install Oracle 10g on Solaris 10, Sparc. I prepared anything successfully, but, when I gone to create ASM instance, I found the Create new bow did not show any disks into. I take brief something:
I am trying to configure a new ASM instance. I am getting error " -bash: crsctl: command not found" .. where should i actually look for the error. crsctl command not found.... I am doing this as a root user .
I have a lot of shemas inside an instance... How to organize them?
What I see is a long list of schemas which could be difficult to manage if number of schemas grows up... For example, I'd like to group Schema_1, Schema_2 and Schema_3 in something like Group_1, so it could be seen more organized.
Group_1 Schema_1 Schema_2 Schema_3
Sometimes a java or .net application uses 3 or 4 schemas... these schemas are in the same instance which has other schemas for other applications.
create an ASM (Automatic Storage Management) instance using dbca. At first try I mistakenly skipped the part where I click on ASM Parameters to add /dev/raw/raw* as my asm_diskstring so it created an ASM instance. When I get to the next page ASM Disk Groups, I selected Create New and I did not have the desired display, because of the step I missed.
I went back to do some cleaning up as follows:
1) Edit the oratab file to remove the ASM entry
2) backed up these files by renaming to old-<filename> old-ab_+ASM.dat old-hc_+ASM.dat old-lk+ASM old-orapw+ASM old-spfile2+ASM.ora
Now when I try to go through the steps to create an ASM instance, at the point after I enter my ASM Parameters, I get the following prompt:
"DBCA will now create and start the ASM instance. After the ASM instance is started you can create the diskgroups to be used as storage for your database."
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 29 21:02:42 2011 Copyright (c) 1982, 2008, Oracle. All rights reserved. ERROR: ORA-12547: TNS:lost contact addbctl.sh: exiting with status 9 /d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
[code]....
BTW I have not set $ORACLE_HOME, $ORACLE_BASE, $ORACLE_SID yet.
Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.
I am having database A and database B and I am inserting into database b by selecting some records from database a using db link.Is there any way to find whether database link is being used?
We need to find when any datafile was resized ( if at all)in a tablespace. Actually, by noting the created date from v$datafile , we used to know the data growth in a tablespace. Now as the number of datafiles have increased, we want to resize them. This diagnostinc have to be done without changing/adding anything in DB.
where i can find an alert log errors so whenever they occur in my RAC so i can comprehend them very well. I am trying to know that what can be the errors when u have RAC with ASM and SAN .
