we are having physical standby database and production database..we have create a soft link for a datafile in production to another mount point
ex- /disk1/data1 to /disk2/data1
now we want to keep the datafile in /disk2/data1 and remove the softlink..As we are having physical standby database . i need to know what are step to be taken. my action plan is as follows:
In production.
1. synchronise both standby(apply archive logs) and production. 2.shut down the standby 3.create controlfile in production in ascii format and edit the path (/disk1/data1 to /disk2/data1) 4. run the @control.sql that i have created 4.create a standby control file in production .
In standby:
1. take the backup of controlfile. 2.place the newly create controlfile(from production) to the location of controlfile 3. remove soft link. 4.startup mount. 5. then we can apply logs as usual to make the standby sync.
whether my action plan is 100% correct or any changes to be done.
I'm in 11203, and generation of ASH report is very slow.AWR and ADDM reports are generated quickly.To understand what happen, I check the wait event on the session that is executing ASH report, and I found that this session is waiting 99% with "controlfile sequential read". Is there any way to make the generation of ASH report quick ?Why the generation need to access to the controlfile?.
I have 3 controlfile in those i lost 2 controlfiles as dba what we do? Is the following process is right?
shut the instance abnormally as shut abort restore the backup startup nomount alter database recover automatic using backup controlfile until cancel; recover cancel; alter database open resetlogs;
and one more thing is thatwhat we need to restore? the backup of controlfiles which are lost/all the controlfiles/all the database files
I need to create PROCEDURE to create user in oracle
CREATE OR REPLACE PROCEDURE "CREATE_USER_ORACLE8" ( USER_ID in VARCHAR2, PASSWORD in VARCHAR2, ROLES in VARCHAR2, nReturnCode OUT NUMBER ) BEGIN [code].......
Compilation errors for PROCEDURE NOG.CREATE_USER_ORACLE8
Error: PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following:
; is with authid deterministic parallel_enable as Line: 9 Text: BEGIN
i want that the customer execute PROCEDURE (user_id,password,PROCEDURE )
ORA-06502...I have database on oracle 9i on Solaris 9. I create a generate procedure that create dynamic procedure through DBMS_SQL. On this database I got the ORA-06502 error. When I tried to run the same procedure on the same database on oracle 8i on NT this work fine.
ORA-06550: line 1, column 93: PLS-00201: identifier 'PKG_MAINTENANCE.MAINTENANCE_PURGE' must be declared ORA-06550: line 1, column 93: PL/SQL: Statement ignored ORA-06512: at "SYS.DBMS_JOB", line 82 ORA-06512: at "SYS.DBMS_JOB", line 139 ORA-06512: at line 4
I have oracle 11.2.0.2 on Linux. I have question regarding that i have last week (1/26/2013) hot backup of database and cold backup from (dec 9 2012). and user needs data from the database but needs to create new db.
how can i do that to create new db with Hot backup of last week?
As per project requirement, we need to create tab seeprated file for a table. This table contain around 1000000 records.I have written below sql
set pagesize 10000 set feedback OFF set serveroutput on set heading OFF spool D:OfficeworkDatabase_maintainceMATRIX.txt
[code]...
This query is taking more than 6 hours.if there any other way how can we create tab separated file. Or we can export the entire table in tab separated file format.
I want to create a new table 'b' from table 'a'.I know the query will be " create table b as select * from a;" But there is some twist in my question. I do not know how many table are there in table 'a' all I know is that there is one column named "timestamp" in table 'a'.
Now I want to create table 'b' with the difference that the column "timestamp" should contain the value "sysdate" instead of the earlier values which were there in table 'a';
Note: I have to do this in single query. I can not first create table 'b' from 'a' and then update the values of column "timestamp" to sysdate.
how to create the trigger that count the last 7 day about from sale table if the last 7 day amount is greater then 10000 then update the commission 2% other wise do nothing
I want to create one dummy job using dbms_jobs and execute it under BALA user.This is just for testing purpose.My goal is to test Whether the job executes successfully under the new user i created BALA. All these should happen under BALA user.
I cant create a trigger for the following problem "write a trigger to change the "hiredate"(in emp tale) in the default format even if the user enters it in some other format, say year/mon/date..."
I'm trying to create a ASM disk using oracleasm.I created list the disk (using oracleasm), but the view V$ASM_DISK and ASMCMD (lsdsk command) can't see it..Look:
I am trying to create a table that will increment my ID by one using the following commands:
/*Creates the log needed to increment ID*/ create sequence seq_log; CREATE TABLE MESSAGE_LOG_TABLE ( IDNUMBER(10)NOT NULLPRIMARY KEY,
[code]...
When I run the above my create sequence completes successfully but I get a ORA-00955: name is already used by an existing object error message on the create table. I have dropped all tables and sequences before running my command but I still get the same error message.
After it bombs out it appears that SQL+ want's more information for it begins to give me line numbers as if it is looking for a ";" to end the above command. I have to exit SQL+ and log back in to continue working.
if there is a way to create a custom log files or if there is way to utilize the built in log function of Oracle. Here is the code with what I am trying to do:
IF (_CONDITION IS NOT NULL) THEN IF (V_CONDITION <> 'NS' OR V_CONDITION <> 'NE' OR V_CONDITION <> 'AR' OR V_CONDITION <> 'OH' OR V_CONDITION <> 'SV') THEN
[Code]....
Ok, so where you see V_CONDITION := 'XX'; I would like to have the value of V_CONDITION be input into a log file as apposed to changing the value to XX. So I would have something like:
RAISE BAD_CONDITION_CODE;
The problem is that I am not sure how to create the actual log file that the value of V_CONDITION will be stored in.
How do I create a trigger for the age. I want an alert to appear when the date of birth field is less than the age of 17. The formula is age=sysdate-dateofbirth