Database Script Take Backup On Daily Basis

Sep 30, 2012

DB 10.2.0.2
OS Window Server

I need to create a script to take the oracle database backup on daily basis for windows. Which method will be good exp imp, rman or coldbackup?

In our case mostly chance system will crash and we need to OS install first and then restore the oracle home and full database.

View 8 Replies


ADVERTISEMENT

Replication :: Update Database On Daily Basis?

Feb 7, 2013

There are 2 databases, database A and database B. Database A is Oracle 11.2.0.2 which runs on linux and Database B is Oracle 11.2.0.2 which runs on windows xp machine. In database A, there are 100's of tables which are being updated every 10 minutes or 15 minutes. For reporting purpose, the developer wants to run report for the tables. But since database A is being updated every now and then, generating reports takes almost 15 to 20 minutes. So the reports can be generated in Database B. Once in a day the database B should have the updated data from database A so that the reports can be generated in database B with less time. What could be the best solution for the database B to have the updated data on daily basis from database A in oracle?

View 3 Replies View Related

Run Three Scripts One After Another Automatically For Daily Basis?

Mar 22, 2013

How do i run three scripts one after another automatically for daily basis. Say i have three scripts A,B,C and i want to run the three scripts A followed by B followed by C.

View 7 Replies View Related

How To Find Tablespace Growth On Daily Basis

Feb 15, 2013

How can we find a tablespace growth on a daily basis for a 11.2.0.2 database?

OS: AIX 6.1

View 8 Replies View Related

RAC11g Private Connection Disconnected On Daily Basis

Sep 18, 2012

We have a 2-Node RAC11g R2.0.3 installed on Linux 5.5.

My problem to have a private connection disconnected on daily bases at 12:00 PM and 3:00 PM ONLY,and come back life within 2 minuets,I am using cross-over cable to connect those private interface , So in the ocssd.log Stating :-

2012-09-18 15:06:43.735: [ CSSD][1096161600]clssnmPollingThread: node racmain1 (1) at 50% heartbeat fatal, removal in 14.340 seconds
2012-09-18 15:06:50.752: [ CSSD][1096161600]clssnmPollingThread: node racmain1 (1) at 75% heartbeat fatal, removal in 7.330 seconds
2012-09-18 15:07:19.821: [ CSSD][1096161600]clssnmPollingThread: node racmain1 (1) at 90% heartbeat fatal, removal in 2.480 seconds, seedhbimpd 1

And the instance is restarted accordingly.

View 5 Replies View Related

Forms :: Data Copy Into Other Location On Daily Basis

May 22, 2010

I need any good suggestion basically I have two different location

1- Factory
2- Head office

I have developed PRODUCTION module in factory and it is working fine and now I want to send data on daily basis to head office therefore I develop a form which will create backup in export format (.dmp) then user will send via email to head office.

Backup file should be save in pre-defined location then user will use a form which I developed for loading data into head office there are two different buttons in this form;

First is used to load data, actually first I load data in a temporary user which creates whenever user will press this button. Second is used to copy data in application user but first it checks if data exists then update otherwise insert.

View 1 Replies View Related

Data Guard :: Take RMAN Full Backup Of Standby Database On Regular Basis?

Jun 8, 2012

I use windows 2003 server, oracle 10.2.0.4.0.My question is related to maintaing a standby database

1. Do we need to take RMAN full backup of standby database on a regular basis? At the moment I dont take backups of standby database.

2. I have FRA on standby database. The archivelogs from primary go to FRA on standby. I delete my archivelogs as follows:

DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';

Though the archivelogs are delete there are still empty folders of archivelogs that are not deleted. How to get rid of them automatically.

View 2 Replies View Related

Server Utilities :: Daily Base Backup File

Apr 11, 2012

I made small Inventory software for Medical store. Now I want daily base data in DMP file. How to make current date in DMP file don't need all.

I mean I have 30 tables in oracle sql . They are daily update with new entry and some table has date column and some not. Actually I want to send daily Data via mail.

View 13 Replies View Related

Forms :: Form Where User Can Search Database On Basis Of Language And Name?

Jul 2, 2013

There is a table called cd_details. It has fields like id, name, language, type etc.I need a form where the user can search the database on basis of language and name and then display the other details. I used a data block wizard and given a push_buttonwith (execute_query). But it's very clumsy. For eg, if the user presses next the next button then all the records are being displayed. Is there any way to do this thing in a better way?

View 13 Replies View Related

Recovery Manager (RMAN) :: Script / Daily Incremental Backups With Configure Commands For Oracle 11g Database

Aug 29, 2012

the rman backup script for weekly full backup and daily incremental backups with configure commands for oracle 11g database.

View 10 Replies View Related

Backup & Recovery :: Restore RMAN Backup Of Database To A New Database

Jan 25, 2011

I have oracle 10g installed on my system and name of the database is "ORCL" for which I have schedule the incremental backup everyday. Mentioned below are the steps followed

*************PARAMETERS TO BE CHANGED******************
configure channel 1 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
configure channel 2 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalcntrl_%U';
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
*******************************************************

*******COMMAND FOR THE CONNECTING TO RMAN**************
rman LOG = \192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incremental
rmanlog_%date:~4,2%-%date:~7,2%-%date:~10%.txt APPEND
CONNECT TARGET SYS/ORACLE@ORCL
*******************************************************

********INCREMENTAL BACKUP COMMAND*********************
RUN
{
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_backup' DATABASE;
BACKUP ARCHIVELOG ALL DELETE INPUT;
}
********************************************************************

Now I want to restore this backup to some other system with new database. How to do this recovery to some other database on new system.

View 2 Replies View Related

Backup & Recovery :: Error While Backup On Windows 7 Client Of Oracle 11gR2 Database

May 2, 2011

I have facing problem while taking backup on Windows 7 client of Oracle 11g R2 database. I have installed oracle 11gR2 for windows on windows 7 machine. I have created a directory like below in database.

On Database Server

SQL> create directory win_expdp_dir as 'd:expimp';

Directory created.

SQL> grant read, write on directory win_expdp_dir to lab;

Grant succeeded.

On Windows 7 machine (client machine)

D:appproduct11.2.0client_1BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 12:51:44 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.

I have give all sharing rights on d:expimp directory. My main question is why i'm getting this error. Is there any thing missing in setup. how to take export on windows 7 client.

View 6 Replies View Related

Backup & Recovery :: ORA-19870 / Error Reading Backup Piece During Database Cloning

Mar 15, 2011

I am trying to clone a database on another server with different direcory structure. So that path on the source db server are /u04 whereas on on target db server it would be /u03.

Since this I am testing it on small database initially I have kept all datafiles, backup and archivelogs at /u04 and /u03 on the source and target db servers respectively Now I have copied the backups from source db server to target and since path is changed, I cataloged it

However during restore I am getting

Quote:ORA-19870: error reading backup

Here are the session details

RMAN> catalog start with '/u03/oradata/db7fra';
searching for all files that match the pattern /u03/oradata/db7fra
List of Files Unknown to the Database
=====================================
File Name: /u03/oradata/db7fra/DB7/archivelog/2011_03_15/o1_mf_1_16_6qyvpb3w_.arc
File Name: /u03/oradata/db7fra/DB7/backupset/2011_03_15/o1_mf_annnn_TAG20110315T123018_6qypyv5v_.bkp

[code].....

I have altered permissions on the backup files as well but of no use

oracle@dev-biz:/u03/oradata/db7fra/DB7/backupset/2011_03_15 $ls -ltr
total 545260
-rwxrwxrwx 1 oracle dba 12419072 Mar 15 13:52 o1_mf_ncsnf_TAG20110315T123008_6qypyrz2_.bkp
-rwxrwxrwx 1 oracle dba 3072 Mar 15 13:52 o1_mf_annnn_TAG20110315T125043_6qyr54to_.bkp
-rwxrwxrwx 1 oracle dba 426496 Mar 15 13:52 o1_mf_annnn_TAG20110315T125006_6qyr3zk4_.bkp
-rwxrwxrwx 1 oracle dba 14336 Mar 15 13:52 o1_mf_annnn_TAG20110315T123018_6qypyv5v_.bkp

[code].....

View 13 Replies View Related

Backup & Recovery :: Backing Up / Restoring Oracle Database Via Entire Backup Of Server

Aug 7, 2012

I've read a lot about the different types of backup available with Oracle (hot and cold backup). However, I was thinking of a different way of performing this task. I'm currently using Windows Server 2008 R2 and Oracle 11g Standard Edition. I'd like to schedule an entire backup of my server via the utility "Windows Server Backup" (available for free).That way, I could recover my entire server with all the programs and files in case the latter crashes.I'm wondering if this solution could be used as a way of backing up (and recovering) the Oracle database. Should I still set up a regular hot backup with the Archivelog mode enabled in case some operations/transactions were being done at the time of the crash (for the data integrity)?

View 2 Replies View Related

Backup & Recovery :: Database Size Is 30GB Is It Recommended For RMAN Backup

May 22, 2012

database size is 30GB is it recommended for RMAN backup

View 2 Replies View Related

Backup & Recovery :: Restore Database From Obsolete Backup Using RMAN

Dec 13, 2011

can we restore database from obsolete backup using rman

View 2 Replies View Related

Backup & Recovery :: Backup Full Database Throws Error?

May 13, 2012

SQL> SELECT * FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

after i backup my database,i check the alert log ,i found the following errror:

Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:

[code]....

the trace number 26967 :

[oracle@shenzhengair archivelog]$ cat /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc
/u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1

[code]....

what does the error mean?

View 6 Replies View Related

Backup & Recovery :: Taking Online Backup Of Full Database

Jan 29, 2011

online backup done thru RMAN.Suppose i am taking online backup of full database. During the backup, user's are inserting/deleting/modifying data. This data is getting stored as online archives. Once the database backup is finished, how these archives are applied to the database to make the database up to date.

View 1 Replies View Related

Backup & Recovery :: How To Setup Database For Automated RMAN Backup

Mar 14, 2012

How to setup the database for automated RMAN backup. like if we want to have a backup exactly at 8:00 PM IST. So how to configure it.

View 6 Replies View Related

Backup & Recovery :: Backup Entire Database / Without Archived Logs

May 13, 2011

Backup entire database, without archived logs, while the database is open for user activity and also This backup should be the base for an incremental backup strategy.

View 10 Replies View Related

SQL & PL/SQL :: Creating View On Basis Of Time Interval?

Apr 27, 2010

how to create a view from table which containes rows from every minutes. In view I want to select only rows at 15 or 30 minutes interval.

eg. my base table has 60 rows for 1 hour. The created view must contain 4 rows on 15 minutes interval basis at the boundary of that interval.

O/P of view should be like this.

Value Time
100 00:00:00
200 00:15:00
300 00:30:00
400 00:45:00
500 01:00:00

View 6 Replies View Related

SQL & PL/SQL :: Fetch Record On The Basis Of Month In Where Clause

Jan 6, 2011

i want to fetch records of emp whose hiredate between 1 sep to 30 sep of any year. i am using the below query but it show me wrong results.

select * from tran where to_char(timestamp,'DD-MM') between '01-SEP' and '30-SEP'

View 2 Replies View Related

PL/SQL :: Extract Data From Table On Hourly Basis?

Oct 23, 2012

I have a table which have two columns date on hourly basis and response time. I want to pull the previous date's data on hourly basis with the corresponding response time. The data will be loaded to the table every midnight.

eg: Today's date 23/10/2012
I want to pull data from 22/10/12 00 to 22/10/12 23

The below query is pulling the date as required but I am not able to pull the response time.

with a as
(select min(trunc(lhour)) as mindate, max(trunc(lhour)) as maxdate from AVG_HR)
SELECT to_char(maxdate + (level/25), 'dd/mm/yyyy hh24') as dates FROM a CONNECT BY LEVEL <= (1)*24 ;

View 4 Replies View Related

Backup & Recovery :: Apply The Backup Command To Each Database?

Feb 14, 2012

I am admin of my actual server and I want to backup all databases for later use. For that this is my approach.

1 - List all databases on the system

2 - Apply the backup command to each database

View 2 Replies View Related

Backup & Recovery :: RMAN Backup On DataGaurd Database?

Mar 4, 2011

We are running a 5Tb database backup which takes really a long time to backup and impacts the performance in general during the backup. We got a DataGaurd database in place which we want to utilize to run the RMAN backup on to avoid performance impacts and just use DG database for backup and DR purposes. My Question is if we run the backups on DataGaurd Database, How would a RMAN DG database backup would clear the archive logs from Primary production and from DataGaurd Database during the backup process?

View 7 Replies View Related

Forms :: Search Data On Basis Of Date Range?

Sep 13, 2010

i create form on which 3 window, 3 Canvas, 3 blocks are there.

1)first block contain 3 items from_date and to_date(nondatabase)and find button

2)second block contains 3 items segment1, quantity and payment_terms

when i enter 2 dates and click on find button 2nd window open. segment1 and quantity between this 2 dates comes from base table like

select segment1,quantity
from po_lines_all pll, mtl_system_items mts
where pll.ITEM_ID=mts.INVENTORY_ITEM_ID
and creation_date between :FROM_DATE and :TO_DATE

and payment_terms should enter manually

3)2nd block contains summary button when i click on it, it save segment1, quantity, payment_terms and open new window which contain segment1 ,qty, payment_terms and when i click on summary button data comes from custom table which group clause means

suppose

item qty terms
a 2 2days
a 3 2days
b 3 3days

then on third form i shows like this
a 5 2days
b 3 3days

i done all this things but problem is that

suppose once data between 21-aug-2010 and 24-aug-2010 comes on second form , i enter payment_terms and save it. sumaary form also run properly but if another user enter date between 22-aug-2010 and 30-aug-2010 then it will shows data between 21-aug-2010 to 24-aug-2010 from custom table i.e with payment terms as earlier it save and from 25-aug-2010 to 30-aug-2010 it shows data from base table

like

item qty terms date
a 2 2days 21aug
a 3 2days 22aug
b 3 3days 24aug
b 4 NULL(ENTER MANUALLY) 26aug
c 5 NULL 27aug

View 1 Replies View Related

SQL & PL/SQL :: Adjust 2900 Against Certain Amount From Table On FIFO Basis?

Jun 16, 2010

I want to adjust 2900 against certain amount from table on fifo basis.

DROP TABLE ABC
CREATE TABLE ABC(ID NUMBER PRIMARY KEY,AMT NUMBER);
INSERT INTO ABC VALUES(1,1000);
INSERT INTO ABC VALUES(2,2000);
INSERT INTO ABC VALUES(3,3000);

Can i do it using SQL. I know that it can be done using PL/SQL but i just wanted to confirm if its possible using SQL.

View 9 Replies View Related

Backup & Recovery :: Restore Backup Of Database A From Into B

Jun 16, 2013

I need to restore a backup of database A from into Database B. Both have the same names. Database B is already up and running.

I have a full rman backup of Database A ( it was taken with a recovery catalog which I don't have access to now as it was deleted ). I just have the full backup pieces including the control files. Is it possible to recover this database into Database B from this stand point.

I was thinking

2. Shutdown database B
3. Mount database B. It has same name as Database A.
4. With RMAN restore controlfile. Will a new controlfile be created from the backup directory I have the rman pieces for the full backup in ?

View 9 Replies View Related

Backup & Recovery :: Crosscheck Backup Of Database Vs Crosscheck Backup Command?

Feb 19, 2013

crosscheck backup of database vs crosscheck backup command

RMAN> crosscheck backup;

it shows all backup pieces.

RMAN> crosscheck backup of database;

it shows 2 backup piece of each backupset.

when should be use: crosscheck backup of database;

and when should be use: crosscheck backup;

View 8 Replies View Related

How To Get Daily Max (Value) Query

Dec 18, 2012

I am looking to get the maximum value for every 24 hour period for a month. So for example my date range can be defined by...

select to_date('&date','mm yyyy')-1 + level as DateRange
from dual
connect by level <= '&days'

...where I can provide the first date of the month and number of days in the month or a lesser value if less time is required. So, the results of the above query plus 24 for the range. I thought a some Googling would provide me what I needed, but my search came up empty.

I was hoping to do something like this...

select utctime, max(value) from table where utctime between.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved