Backup API For Oracle?
Sep 24, 2009
I am currently reading some articles/documents to backup and restore Oracle databases. I found that Oracle databases can be backed either up by RMAN('Recovery Manager' tool supplied by oracle) or doing a "Hot Backup" (bring the database to backup mode and then copying the Physical datafile by issuing operating system "copy" command). The above methods do not meet my needs. I want to backup Orcale databases via my own application and I use C++. Hence, I am searching for an API that can be used with C++ to backup the Oracle databases.
Is there any API to backup the Oracle database that we can integrate with our own application program? [Like , To backup SQL Server Database , we can use VDI(virtual Device Interface) API to backup the SQL server database]
View 1 Replies
ADVERTISEMENT
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
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
Nov 11, 2011
I set 'maxopenfiles 4' when allocating channel to sbt in my products env, I got 2 backup pieces in one backup set because that tablespace has 7 datafiles. Other configuration is kept as default, such as no maxsize, no MAXPIECESIZE, and etc setting.
I read document from Oracle. It says:"By default a backup set contains one backup piece. To restrict the size of each backup piece, specify the MAXPIECESIZE option of the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands. " And also, maxopenfiles configure does not force another backup piece generated. So, why do I get another backup piece?
BTW, I tried this on another testing environment. I only get one backup piece even there are more than 2 times maxopnefiles datafiles.
View 7 Replies
View Related
Jul 31, 2012
I have the RMAN full database backup of oracle 10g (10.2.0.3) on Sun Solaris OS which i want to restore on oracle 11g (11.2.0.3) on Linux OS. The backup pieces was transferred to oracle 11g server manually in binary mode.
-rwxrwxr-x 1 mepc dba 36356096 Jul 16 14:49 snapcf_MEPC.f
-rwxrwxr-x 1 mepc dba 166028800 Jul 16 15:29 MEPC_full_backup_MEPC_nnnbkn9f_1_1
-rwxrwxr-x 1 mepc dba 169567744 Jul 16 15:29 MEPC_full_backup_MEPC_nmnbkn9f_1_1
-rwxrwxr-x 1 mepc dba 164813824 Jul 16 15:39 MEPC_full_backup_MEPC_nonbkn9f_1_1
-rwxrwxr-x 1 mepc dba 144025600 Jul 16 16:06 MEPC_full_backup_MEPC_nqnbkn9f_1_1
-rwxrwxr-x 1 mepc dba 168576512 Jul 16 16:09 MEPC_full_backup_MEPC_npnbkn9f_1_1
-rwxrwxr-x 1 mepc dba 168649216 Jul 16 17:33 MEPC_full_backup_MEPC_o5nbkpvv_1_1
[code]....
the backup is taken in above format. I know the ORACLE_SID and dbid of the database from which the backup has been taken. whenever i tried the following command
mepc@tcstctmatson:/mepc_backup/May22fullbkp$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 31 12:14:54 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: MEPC (DBID=1595278680)
RMAN> shutdown;
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
RMAN> startup nomount;
connected to target database (not started) Oracle instance started
Total System Global Area 1071333376 bytes
Fixed Size 1349732 bytes
Variable Size 620758940 bytes
Database Buffers 444596224 bytes
Redo Buffers 4628480 bytes
[code]....
the file is not corrupted as i checked the checksum on both the servers and it is same.how can i restore the RMAN oracle 10g backup in Oracle 11g.
View 5 Replies
View Related
Nov 7, 2011
When you create a backup in SQL Server, whether the backup is on disk or on tape, SQL Server writes the letters TAPE to the first four bytes of the backup. Does Oracle write any specify value to the front of every backup, and if so, what are the first four bytes?
View 2 Replies
View Related
May 23, 2012
what is %N determines in Oracle RMAN HOT Backup. In some documentation it says it gives you backup with respect to tablespace. Is it a version specific ..bcos when tried in above version it failed....
View 4 Replies
View Related
May 24, 2012
I have a scenario like while taking the hot backup i forgot put end backup mode,at the same time one of user u1 updating some lacks of recordsinto the T1 table.at some time he wants rollback.and my redolog file size is very less.is it possible to rollback? if yes how?
View 3 Replies
View Related
Oct 18, 2012
understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???
View 1 Replies
View Related
Jan 24, 2011
I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am
other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm...if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)
if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)
I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)
View 17 Replies
View Related
Jul 18, 2011
way to backup Oracle Apps R12 in Linux.
for Oracle DB tier I use RMAN.
View 2 Replies
View Related
Jul 12, 2011
My boss gave me a 1GB Oracle .dmp file, and I told him that I could handle it easily (ie, install Oracle on a machine, import the .dmp file, and export / move it onto a MS SQL server).
Oracle has turned out to be far more difficult to learn than I originally thought, however. Even after a week of reading search results and watching YouTube videos, I still feel completely in the dark.
Restoring an Oracle backup? (Once the backup is restored, that should be it - I have an ETL tool (Scribe Insight) for reading an Oracle database and moving it to SQL. I can use GoToMeeting for screen sharing.)
View 2 Replies
View Related
Mar 22, 2011
I try this for backup:
$ exp scott/tiger FULL=y FILE='d:\demo.dmp';
and this for restore:
$ imp scott/tiger FULL=y FILE='d:\demo.dmp';
and after restore i can't see the data in my tables. (i work on Oracle 11.2.0 64bit)
View 2 Replies
View Related
Mar 22, 2013
if you are using ShadowProtect to backup your Oracle databases. What are your experiences and the pros and cons in using ShadowProtect as the one and only backup/recovery tools for Oracle databases? Can the potential of ShadowProtect replaces the commonly use Oracle backup/recovery tools?
The reason why I raise this question is because my boss has the idea that ShadowProtect is THE best backup/recovery tools. Personally I don't think so, because there can be cases where we only need to recover the database and not the whole OS.
View 6 Replies
View Related
Oct 20, 2011
Is there any Oracle query I can run to determine the "number of days since the last backup"? SQL Server provides this data but I cant seem to find the equivalent for Oracle. Looks like there may be some information like this via RMAN tables and if so I want to create the simplest query possible to obtain that information.
View 3 Replies
View Related
Feb 13, 2012
I'm going to backup this un-maintained Oracle 11g server in my office. I'm being told it's never been backed up and extremely critical to our success so tomorrow I'll be performing my 1st backup of the database using RMAN. My question is if I connect to the Oracle 11g database and run the:
[oracle@db1 ~]$ rman target=/
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 13 13:18:05 2012
connected to target database: CQDB (DBID=1854033249)
RMAN> shutdown immediate
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
BACKUP DATABASET FORMAT �/oracle/u01/app/oracle/backup/%d-%T-%s-%P�;
My question is the above sufficient for a safe full backup? We only have the one single target database called 'cqdb' which houses several schemas. Can you tell me if this is correct? I've shut the database down so it's in a cold state so I don't think I need to configure the FRA (Flash / Fast Recovery Area) but I honestly don't know. This is my 2nd time on a Oracle DBMS.
What about the 'archivelog' files? Do I back those up? Do I need them in case a recovery? Also what about the 'controlfile'? Do I need to back those up as well as the mentioned above?
View 2 Replies
View Related
May 21, 2012
I installed 11g on linux rhel 5.2 by manually. now databse is ok . But some Schema HR , Scott , Oe are not come. but database fully work. ok.
Now i am trying to connect Rman.
export ORACLE_SID=ORCL
rman target /
then I have a error that SYS.DBMS_BACKUP_RESTORE is not found.
but sql> desc sys.dbms_backup_restore package is available.
which script are run to solve it , because only catalog.sql and cataproc.sql script are run in installing of oracle 11g manually instalation.
View 3 Replies
View Related
Feb 12, 2012
I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?
View 1 Replies
View Related
May 10, 2012
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.
View 2 Replies
View Related
Dec 10, 2011
what is the process of creating log file in database, Suppose if we have two user ,and both are logon through id & password,at that condition i want all log file from users who done at the database like any events.
View 1 Replies
View Related
May 25, 2012
how to migrate oracle database from 10g to 11g
View 1 Replies
View Related
Oct 20, 2011
we have a running Oracle 8i in NT 2000 since year 2004, now we have a new Machine onto which we install a fresh copy of OS and also fresh Installation of Oracle. but..i want to have all those settings, users, database as it is running. i am creating regular dumps of the current database running.
View 4 Replies
View Related
Nov 19, 2012
I have Backup File created in Oracle 11 g . How To restore it in Oracle 10g ?
View 12 Replies
View Related
Dec 29, 2011
how to start database in oracle
View 2 Replies
View Related
Mar 23, 2012
I am using oracle 9i database in my project. I am trying to generate an xml from oracle 9i.
I am creating a procedure but i got an error like this.
Debugger connected to database.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 121
ORA-06512: at "SYS.UTL_FILE", line 293
ORA-06512: at "SYS.TEST", line 30
ORA-06512: at line 2
View 1 Replies
View Related
Jan 24, 2011
tell me what software is the best to backup Oracle, MySQL and MSSQL?
View 2 Replies
View Related
Dec 23, 2011
What is the meaning of begin backup/end backup.. and what the effect on database...
View 1 Replies
View Related
Apr 13, 2011
I am new in oracle. I want to restore my database in oracle 10g enterprise. Actually i have a backup file(.bkp file) from oracle 10g xe and now i wanna restore in oracle 10g enterprise.
View 5 Replies
View Related
Oct 29, 2011
How can I catalog a backuppice in oracl9i. in Oracle 10g CATALOG common has BACKUPPICE clause but in ORACLE 9i it doesn't have it.
I don't know how can I catalog and use backupset files that aren't in their original location . Do you know a solution for this issue in oracle9i ?
View 2 Replies
View Related
May 20, 2013
I am the only DBA in my company and Oracle just crashed on me. The data is corrupted as well as the data on my backup! Is there ANY way I can get the information back?
View 2 Replies
View Related
