Including order number, name and contact details (email, address, telephones) of customer and date the order was placed, order including product code, quantity ordered and cost charged; and Data on each product in the catalog including product code, name, description, unit price and category.
user to input information n number of order items (where 1 ≤ n ≤ 20) as parameters
a cursor to handle the multiple orders retrieved.
I configured recovery catalog and started Full online backup using EMC Networker. In EMC Networker I set three months policy to keep Backup.I didn't change redundancy.
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
My question is, if I need to restore Backup of last 15 days then I can ?.
I've below test case
CREATE TABLE MYMERCHANT
(
SRNONUMBER(5),
PARENTSRNONUMBER(5),
LEVELNONUMBER(5),
LEVELNAMEVARCHAR2(25)
) ;
INSERT INTO MYMERCHANT(SRNO, PARENTSRNO, LEVELNO, LEVELNAME ) VALUES ( 1, NULL, 101, 'HQ1' ) ;
INSERT INTO MYMERCHANT(SRNO, PARENTSRNO, LEVELNO, LEVELNAME ) VALUES ( 2, 1, 102, 'DIV1' ) ;
INSERT INTO MYMERCHANT(SRNO, PARENTSRNO, LEVELNO, LEVELNAME ) VALUES ( 3, 1, 103, 'DIV2' ) ;
[code]........
Structure is like above. There is a Head Quarter (HQ1) under which we have different division like (DIV1 and DIV2). Under division we have different location where our shopping stores are operating and transactions are done (LOC1, LOC2 for DIV1) and (LOC3 for DIV2) respectively.
DESIRED OUTPUT
User can generate reports at two levels i.e. Head Quarter level and Division Level.
When user wants report at Head Quarter Level :
Page 1 (Should Display as below)
HQ1 DIV1 LOC1 450
HQ1 DIV1 LOC2 400
HQ1 DIV2 LOC3 600
Page 2 (Should Display as below)
HQ1 DIV1 LOC1 450
HQ1 DIV1 LOC2 400
Page 3 (Should Display as below)
HQ1 DIV2 LOC3 600
When user wants report at Division Level : eg DIV1
Page 1 (Should Display as below)
HQ1 DIV1 LOC1 450
HQ1 DIV1 LOC2 400
We have system.current_item and system.cursor_item.....
both represent the same....
like this we have few other system variables also .....
what is the main difference between current_item and cursor_item?
couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not
CPU Idle Time (%)
CPU System Time (%)
CPU User Time (%)
I delete member logfile from disk with statement: shred -fu /u01/app/oracle/redologs/activeredolog/DB1/redo0102.log
But if I check status one logfile with statement:
select status from v$logfile wheremember='/u01/app/oracle/redologs/activeredolog/DB1/redo0102.log';
Status is still null. I think status should be change.
My database is 11.2.0.1 with single instance.
Status is changed after restart instance.
Haw can I monitor status logfiles without restart instance?
how to connect oracle database through online
View 8 Replies View RelatedI am going for a presentation at my University. But the students are not very interested in Oracle or Databases. So I need a title for the Apex topic which gets the other students to visit my presentation.
The presentation should show the basics of apex and how to earn money with this.I thought of:
1) Oracle in the world of Web 2.0
2) How to get online with Oracle
3) What to show if some1 tells you Access is a Database
4) Oracle in a drag and drop environment even for developers
5) Best of Breed: Oracle SQL / PL/SQL, HTML, XML and Java in a nutshell
Is it possible to gather stats for a schema which its in use. When i try to analyze the tables of a schema it shows that the statistics for that table is locked. So is it possible that instead of analyzing a table one by one , can i go for gathering the Schema stats while the objects of that Schema is still in use ( like DML or select statements being issued on those schema objects) .
DB version : 10.2.0.4
OS version : RHEL 5.8
DB type : RAC
I developed an Point of sales software using developer 6i and database 10g XE.Now I want to use this software online. Can I do it ? If it is, then how?
View 1 Replies View RelatedI have implemented Rac One node with two machine(dbtest01,dbtest02) in 11.2.0.3 Redhat 5.3 one for online another one for offline. i have created TAF also.
dbtest01 is online and create one query
DECLARE
i number(36):=1;
begin
while(i<10000000)
loop
dbms_output.put_line(i);
i:=i+1;
end loop;
end;
i executed above query for test and i made relocate database using srvctl utility to dbtest02 machine.
session is relocated successfully with new session id...above query getting stop in 25000 itself. i want to make it continue that process..also i tried to find Omotion utility in all the path.. couldn't find it... where will it be.. i want to relocate all the session without losing work.
from application i am getting disconnect after relocation.. application server need to restart to get work again...
Version: 11.2.0.3Platform : Solaris 10
One of the Hitachi support guy has suggested to create a separate disk group for Online redo logs. His rationale was that ORLs was write only files and it would be better to put in a separate disk group.
Just want to confirm if I can run the export (command line) even if the database is up (online)? Are there any risks/impact while doing so?
View 7 Replies View RelatedI am using SQL developer 2.1 to migrate tables from Sybase 12 database to oracle 11g. I have used online data move option for moving sybase data into oracle tables, but even after data move is completed not all rows have been moved from sybase tables to corresponding oracle tables. Some rows are missing but still there is no error message being displayed, how to find out what's going wrong.
View 3 Replies View RelatedTill now i was pretty sure that standby redologs are applied to database without any delay, but everything looks that the process is different. i did on primary server table and add some records to this table.
Next i switch to standby and open redologs (with hex editor) to look for this "create table" and "insert" commands. and i succeeded. so this is prove that standby log are supplied by primary database.
Next i cancelled recovery process and open database in read only mode and there was no records in this standby db, moreover there wasn't any table on standby. so i started to be confused, because i suspected that this table and it content will be on standby database.
Next i started recover process again for standby database and do some switch log on primary server. after that i back to standby, cancel recovery process and open database in read only mode. there was table and contents for it.
so my question is:
does standby redologs should be applied online to database or they are only applied after promoting standby database to primary database?
it looks like contents only from archivelog is applied to standby database. it is correct?
database is 9i.
How can i create an oline back up of database using RMAN?
View 1 Replies View RelatedIs it possible to change the datatype of a column in a table online, using DBMS_REDEFINITION?
If Yes, then which of the options will be used with DBMS_REDEFINITION package?
I've only successfully duplicate a standby database.
from the alert log
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:ORA102CTAREDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
[code].....
when I tried to add the online and standby redo log, it error out
SYS@CTA>select logdetail.member, loggroup.group#, loggroup.sequence#, loggroup.archived, loggroup.status lg_status, logdetail.status ld_detail, logdetail.type
2 from v$log loggroup join v$logfile logdetail
3 on loggroup.group# = logdetail.group#;
MEMBER
--------------------------------------------------------------------------------
GROUP# SEQUENCE# ARC LG_STATUS LD_DETA TYPE
---------- ---------- --- ---------------- ------- -------
[code].....
based on my understanding from [URL] ....
Quote:
As part of the duplicating operation, RMAN automates the following steps:
Creates a control file for the duplicate database
Restores the target datafiles to the duplicate database and performs incomplete recovery by using all available incremental backups and archived redo logs
Shuts down and starts the auxiliary instance (refer to "Task 4: Start the Auxiliary Instance" for issues relating to client-side versus server-side initialization parameter files)
Opens the duplicate database with the RESETLOGS option after incomplete recovery to create the online redo logs (except when running DUPLICATE ... FOR STANDBY, in which case RMAN does not open the database) when duplicating for standby database it does not create online redo logs. Duplicating a standby database does not creates online redo logs.
how should I add the online and standby redo logs. If I transfer the redo logs from primary to standby, it always encountered the the following error
Dump file d:ora102ctadumpcta_arc0_3624.trc
Tue Sep 13 19:21:53 2011
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the OLAP, Data Mining and Real Application Testing options
Windows XP Version V5.1 Service Pack 2
[code].....
Although i have removed current online redo log file in linux os (Oracle Linux),when i type "commit" it says that "commit complete".
Is this fair for this princip?*:" if Only when all redo records associated with a given transaction are safely on disk in the online logs is the user process notified that the transaction has been committed."*
I think that it can lead to loss of data in some cases..I'm using Oracle 11g R2 on OEL (x64)..
P.S : I haven't multiplexed current ORL group files...
,I am new to Oracle database administration i am working on a 24*7 tool .the tool will work as a non stop.this is a standalone tool.there wont be any one who will be taking care of the database.I need to design a backup statergyNeed to take backups on timly basis.Since the database can't be go offline cold backup's can not be useenhot backup needs to implemented.what are steps needs to do for hot backup.Is there are some pre defined scripts to run the backup.
View 6 Replies View RelatedI am trying to create a clone database using hot backup of a database .
STEPS THAT I FOLLOWED
------------------------------------
LET ----- >CURRENT_DB NAME=DEV
CLONE DATABASE NAME=DEVCLONE
steps PERFORMED FORM DEV DB
-----------------------------------------------
- put the database in backup mode using 'alter database begin backup'
- copy all the data files to a different folder
- during copy i have performed some operations on the DB (creating users, tables, dmls etc...)
- in between copying i also performed log switch
- after completion of copy , "alter database end backup"
- created a backup control file in a human readable format (alter database backup controlfile to trace as ........)
steps performed for clone DB side ((DEVCLONE)
-------------------------------------------------------------------
- created a parameter file for the database .
- modified the backup control file so that it will point to the location of copied destination of datafiles
- set the ORACLE_SID
- then 'sqlplus / as sysdba
- starup nomount
- run the modified control file ( created a control file for the clone database)
- recover the database using "recover database using backup controlfile"
I have provided the archive files that it was asking for (archive logs that has been generated in DEV DB)
then i canceled the recovery by typing "cancel"
- recover database using backup controlfile until cancel;
then typed "cancel"
- then try to open the database with open resetlogs but it showed below error
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:DATA_GUARDDEVHOTSYSTEM01.DBF'
why can not we resize online redolog files instead of re-creating the same with large size and remove the older onces.2. How can we make RMAN obsolute backups as usable ?
View 8 Replies View RelatedHow after a re-catalog of an archivelog, RMAN knows that the archivelog will be needed and in the right order?
If the re-catalog and subsequent crosscheck has changed the path of the archivelog will RMAN ignore the path and just recognize the archivelog name and format?
error while creating a catalog db
error creating db
ORACLE error from recovery catalog database ORA-01552: cannot use system rollback segment for non-system tablespace 'TS'
ORACLE error from recovery catalog database:ORA-00942:table or view doesnt exist
RMAN-00571:--------------------------------------------------------------------------------------------------
RMAN-00569----------------ERROR MESSAGE STACK FOLLOWS-------------------------------------------
RMAN-00571:---------------------------------------------------------------------------------------------------
RMAN-06433:error installing recovery catalog
Is possible use the TSPITR recovery with a database not cataloged in a RC (Recovery Catalog)? ... Using only the control file? I am trying but seems not possible...
View 6 Replies View RelatedI am using oracle 10g recently i have runned two files catproc.sql and catalog files by connecting to sys
after running those files in sys when i select
select * from tab;
no rows were returned
1) these files will show any eeect on data base
2)From toad when i connect to data base in toad it is showing all the tables in sys user is there any effect of running those files
The updates occur always that a significantly change was done? (Like create, rename or drop datafiles and tablespaces)
Or the RMAN catalog owner must issue "resync catalog" frequently?
I created a catalog for rman backup. To launch a backup with the catalog I executed the following command:
1) rman catalog user/password@catalog
2) connect target /
3) backup archivelog all
I want to use rman to restore all my control files, I just did a level 0 incremental backup and ran the following script.
rman <<EOF
connect target sys/sys@GOLD_AUX
connect catalog rman/rman@GOLD_CAT
RUN
{
STARTUP FORCE NOMOUNT;
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN RESETLOGS;
}
EOF
My control files seem to be put back in the correct spot and suggest a way I can restore only my control files and have everything in sync with my datafiles.
end of out from rman script
====================
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/oracle/data/aux/control01.ctl
output filename=/oracle/data/aux/control02.ctl
output filename=/oracle/data/aux/control03.ctl
Finished restore at 29-AUG-10
[code]...
New to oracle FAQ. I'm interested in oracle, waiting to explore more Technic's in 10g with a proper guidance. Hope i'm in the right place.Here is my question.
I need steps for configuring rman cloning with catalog & without catalog.were in prod db the source is in /u01 & in auxiliary db the client want in /u05. how to do it. here i have recreate control file or not