Data Guard :: Db-file Name Convert And Log-file?
May 25, 2012How to understand the two parameters db_file_name_convert and log_file_name_convert,if there are missing in the parameter file of standdy database,how does oracle will do?
View 3 Replies
ADVERTISEMENT
Data Guard :: How To Convert Primary Control File For Standby
Dec 29, 2009I try to recover standby db from a primary db backup set,but the standby control file is different.
to create primary controlfile by rman:
backup control file format '/home/cur_control';
to create standby controlfile:
backup control file for standby format '/home/std_control';
I want to know if there is method to convert cur_control to std_control.
Data Guard :: Changing Dbname / Sid / Data / Control File Locations?
Nov 5, 2010I want to change dbname,sid,data/control file locations in operational dataguard setup i plan to follow as below
1)shutdown primary and standby (stop managed recovery)
2)change db name in init.ora of primary and standby change database name control file location
3)create control file for primary from trace(script) make changes for db name and file locations
4)mount and open primary database
5)create standby control file
6) transfer standby control file to standby
7) mount stand by database and start manage recovery
If this steps will error free do i need to follow any thing additional to this or what is other best way for this or its not possible at all
Data Guard :: ORA-01157 / Cannot Identify / Lock Data File 1
Jul 23, 2010i did everything writen but when i do *SQL>alter database recover managed standby database disconnect from session;*
i go and look in the standby database AlertLog file ,and thats whats writen
*ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:ORACLEPRODUCT10.2.0ORADATADBSYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
O/S-Error: (OS 3) The system cannot find the path specified.
[code]....
strange thing that it realises the primary database in drive F and it goes to it but i dont understand what could be the reason of this ,although im doing this command while primary database is shutdown!
Data Guard :: Copying Archived Log File From Primary To DR
Sep 21, 20111) How to copy the ARCHIVED LOG FILE from Primary to DR location. Where if the DR is having the file already, how to SKIP that Particular Archived log file?
2) I have Checked with the FILE_TRANSFER DBMS package, but it gives the error if any file existing already.
Data Guard :: Migrate From File Based To ASM Storage
May 15, 2012I have an 11gR2 data base with Local Extent Management and Manual Segment Management. Can Data Guard be used to replicate this instance into ASM storage? [I have multiple long fields (BLOBs and CLOBs) in various tables.]
View 3 Replies View RelatedData Guard :: Confirm Particular Archive Log File Applied Or Not?
Aug 5, 2011I need a clarification on the below query.
I am having a Dataguard setup as Logical.
I am copying all the archive log files generated in the live server into the local server in order to apply into the Data Guard.
I am running a script for this process.
Question:How i can verify whether particular archive log file was applied into the data guard or not.
Data Guard :: Finding Unapplied Archived Log File In DR?
Sep 21, 2011I wanted to make a script for applying the Archived log File in to DR by certain interval.
1) I will use the below view for finding the SEQUENCE so far applied.select sequence# from v$log_archive.
2) But how i can compare with the archive log files available in physical location with the above mentioned view.
eg:- the above view shows, the till the sequence 46789 is applied.And in the DR physical Location available sequences are 46795. which means 6 more archived log files are more, which are not applied into the DR so far.
Data Guard :: Clarification Regarding File Growth In Physical Standby
Feb 3, 2011I am in need of a clarification regarding the file size growth in Physical Standby Database.Say we have 150 GB size of LIVE DB and we have created the same as in STDBY(150 GB).Will there be a growth in STDBY DB datafiles with respect to the LIVE DBOR only the logs are applied currently to the STDBY and the changes will only be reflecting when there is a switchover or failure scenario??
View 4 Replies View RelatedData Guard :: Ora 09925 - Unable To Create Audit Trail File
Aug 19, 2012[oracle@RSASPGERP02 ~]$ cd /
[oracle@RSASPGERP02 ~]$ . .bash_profile
[oracle@RSASPGERP02 ~]$ sqlplus / as sysdba
sql*plus:Release 10.2.0.4.0 - production
Error:
ORA-09925:Unable to create audit trail file
[code]....
its standby archieving problem ,the problem appears when try to connect directly or through telenet and we try to login directly using oracle user we receving following message and login fail, "GDM could not write to your authorization file,this could mean that you are out of disk space or that your home directory could not be opened for writting"
Data Guard :: Unable To Transfer Archivelog Wrong Pass File
Aug 2, 2010I am creating physical standby database through Rman duplicate command from 2 node rac cluster. rman do all its work. now am try to start the mrp process on physical standby database. I am getting following errors
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
ORA-16191: Primary log shipping client not logged on standby
------------------------------------------------------------
I copied the same pass file from primary to standby and many times verify the same but i got the same error.
Data Guard :: Create Control File With Standby Keyword On Primary Database
Jul 4, 2012What is difference when you issue a create controlfile with "standby" keyword on the primary database
ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/path/db_stby.ctl';
vs. creating a control using
ALTER DATABASE BACKUP CONTROLFILE to '/path/db_control.ctl';
what does ORACLE put into the standby control that is "extra"? ie. what is the difference between a standby control file and a normal control file?
Server Administration :: ORA-01111 / Name For Data File 636 Is Unknown - Rename To Correct File
Nov 3, 2012i have two tablespaces dictionary managed (SYSTEM,APPLSYSX) i tried to change to locally cause it will cause problem in future when trying to run OATM migration.i did it successfully on APPLSYSX,when i did it on system upon oracle procedure.i have to change all tablespaces to read only when i did that with tablespace APPLSYSD(alter tablespace APPLSYSD read only) i received errors
SQL> alter tablespace APPLSYSD READ ONLY;
alter tablespace APPLSYSD READ ONLY
*
ERROR at line 1:
ORA-01230: cannot make read only - file 636 is offline
ORA-01111: name for data file 636 is unknown - rename to correct file
ORA-01110: data file 636: '/vol5u/oracle/prddb/9.2.0/dbs/MISSING00636'
i have not this file on the OS
SQL & PL/SQL :: Combining Rows In Data File Based On Values In Control File?
Aug 29, 2013I have to load data file into a table. And the requirement is as below:
Input Data:
1234|20130815|20130822|This is a test, this is the the part
3456|20130823|20130809|This is a test
3456|20130823|20130809|This is a test
3456|20130823|20130809|This is a test
3456|20130823|20130809|Siva 1234
The data should be inserted only in two rows as below:
When Value in first 3 fields is same, 4th field should be appended to the existing value in table.
1234|20130815|20130822|This is a test, this is the the part
3456|20130823|20130809|This is a testThis is a testThis is a testSiva 1234
Data Guard :: Convert Logical To Physical Standby?
Oct 9, 2012Can we convert a logical standby to physical standby? Yes or No, if yes how ..
View 7 Replies View RelatedSQL & PL/SQL :: Convert PLB To Text File?
Feb 11, 2011is there anyway to convert plb file to sql file or text file
View 20 Replies View RelatedData Guard :: Convert Snapshot Database (standby) Directly To Primary?
Dec 16, 2012(Oracle 11gR1 OEL 5)Is there any possibility to convert snapshot database (standby) directly to Primary. Instead of manual switchover I want to do this
I have checked that snapshot creates a guaranteed restoration point which reverts back changes in Standby.
How To Convert PDF To Office Word File
May 26, 2012I download a pdf file,but I want to use it in the office word,who knows how to convert it?
View 11 Replies View RelatedSQL & PL/SQL :: Convert Excel File Into Text?
Aug 2, 2010i want to convert an excel file into text and then into oracle table.
View 6 Replies View RelatedSQL & PL/SQL :: Procedure To Convert Excel File To XML?
Mar 21, 2012I need a PL/SQL code to convert an excel file to xml file.
View 3 Replies View RelatedPrecompilers, OCI & OCCI :: Convert C To PC File?
Dec 11, 2010Can i convert a .c file to .pc file?The .c file is generated by compiling .pc file. I mistakenly deleted the .pc file. I need the original .pc file.
View 2 Replies View RelatedReports & Discoverer :: Convert Report To Excel File
Sep 23, 2006How can i convert reports to excel file,in DELIMITED Format ,the report headings also coming in rows .
View 25 Replies View RelatedReports & Discoverer :: Possible To Convert Small Application To EXE File
Mar 15, 2011I have a small application with 5 forms and a small database. Is it possible to convert it into an exe file?
View 4 Replies View RelatedJDeveloper, Java & XML :: Convert Complete Oracle Database In Single XML File
Dec 14, 2010Inspiration of a java program that converts a oracle database to one single XML document?
View 1 Replies View RelatedData Guard :: Switch (convert) Primary Database To Standby Database?
Jan 30, 2013I have installed oracle 11g standard edition one and created both primary and standby database. now i want to know how to switch(convert) primary database to standby database.
View 8 Replies View RelatedData Guard :: Possible To Convert Logical Standby To Physical Standby
Aug 30, 2013My steps for testing as below:
1.create a primary database
2.duplicate a physical standby database;
3.turn on flashback on both databases.
4.record SCN xxx on physical standby database.
5.convert physical standby to logical standby (using keep identity statement)
6.flashback to logical standby to xxx
7.convert logical standby to physical standby
8.using real time apply I got errors: Fast Parallel Media Recovery enabledManaged Standby Recovery starting Real Time ApplyMRP0:
Background Media Recovery waiting for new incarnation during transient logical upgrade procedure
Errors in file /home ora/ app/ oracle/ diag/ rdbms/ ora11gr1dg/ora11gr1dg/trace/ora11gr1dg_mrp0_10120.trc:ORA-19906: recovery target incarnation changed during recoveryManaged Standby Recovery not using Real Time ApplyErrors in file /home/ ora/app/ oracle/diag/ rdbms/ ora11gr1dg/ ora11gr1dg/ trace/ora11gr 1dg_mrp0_ 10120.trc:ORA-19906: recovery target incarnation changed during recovery
Errors appears every 10 seconds. Seems MPR0 is waiting for new incarnation for a long time. So am I.Standby database incarnation:
List of Database IncarnationsDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time-------1 1 ORA11GR1 3853851354 CURRENT 1 08/09/2013 01:02:182 2 ORA11GR1 3853851354 ORPHAN 2127877 08/28/2013 19:22:01 BGV
Forms :: Export Text File With Same File As Imported Text File?
May 30, 2011Is it possible to get the same name of file name from imported text file?
What i've is, I import the text file then I exported it.
can I get the same name of the imported text file?
Spatial :: Convert Shape File To Oracle Spatial
Jul 31, 2012I have a road network which is shape file format and i want to export it to oracle spatial format using any free tool, I am using arcgis 9.3.1 and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bi,
View 2 Replies View RelatedPrecompilers, OCI & OCCI :: Compile PC File With Created Make File - No Explicit Type Given
Jan 22, 2008I am trying to compile a .pc file with the make file which I created. But when I try to give make command I am getting following error
>make testfile
cc -o testfile testfile.c
"testfile.c", line 117: warning: no explicit type given
"testfile.c", line 119: warning: no explicit type given
"testfile.c", line 121: warning: no explicit type given
"testfile.c", line 122: warning: no explicit type given
"testfile.c", line 123: warning: no explicit type given
Undefined first referenced
symbol in file
sqlcxt testfile.o
ld: fatal: Symbol referencing errors. No output written to testfile
*** Error code 1
make: Fatal error: Command failed for target `testfile'
Forms :: Getting Error When Cancel File Selection In File Open Dialogue
Mar 18, 2010I have created the below stored procedure and calling the procedure in when-button-pressed trigger. Problem here is that when I cancel the file selection in file open dialogue box its raising exception.
PROCEDURE TEST
IS
buffer_lines client_text_io.file_type;
v_outputstr VARCHAR2 (32767);
p_delimiter VARCHAR2 (10) := '","';
v_transaction_no VARCHAR2 (10);
BEGIN
[code].......