Backup & Recovery :: Convert Or Export Oracle 9i To 8i Dump

Nov 28, 2011

Can we convert or export oracle 9i dump to 8i dump ?

View 1 Replies


ADVERTISEMENT

Backup & Recovery :: ORACLE Dump File To Text File

Apr 9, 2011

Oracle10g to Sybase12.5 Migration:- How a Oracle dump file can be converted to any text file/xls file which will be loaded in sybase database later through BCP.

means
1.Exporting objects as dump file from Oracle.
2.Is there any tool/process available that can convert this into csv/txt/xls file.
3.This files can be loaded in sybase.

View 2 Replies View Related

Server Utilities :: What Kind Of Backup By Looking At Export Dump File

Jan 2, 2012

Is there a way to know what kind of Backup (table/tablespace/full/schema) by looking at export dump file ? If yes, can you tell me the command ?

View 1 Replies View Related

Backup & Recovery :: Taking A Dump Of Huge Table

Jul 10, 2012

Is this possible to take the dump of a huge table , say 500gb, into multiple files and then import it in other database? if yes how can we do it?

Note that it is a single table with 500GB of size.

View 1 Replies View Related

Backup & Recovery :: Remap Schema From Dump File To New User?

Jan 18, 2012

I am trying to remap schema from dump file to new user but my import fails and giving me error.

-----------------------------------
Using username "oracle".
Last login: Tue Jan 17 17:41:30 2012 from 192.168.100.11
[oracle@cvs ~]$ dbstart
Processing Database instance "cvsdbm": log file /home/oracle/oracle/product/10.2.0/db_1/startup.log

[code]....

View 1 Replies View Related

Possible To Use Export Dump From Oracle

Sep 5, 2012

I want to know whether it is possible to use export dump from Oracle 11.1.0.6 WIN 2003 SP2 Server to Oracle 11.1.0.6 Windows 7 standalone Machine (Test machine).If yes how to do it as i have tried but it is returning errors.So i tried to do it by pre-creating Tablespaces but even then its failing.

Note : I am Using EXPDP and IMPDP

View 4 Replies View Related

Backup & Recovery :: Tablespace Versus Schema Export

Aug 22, 2012

I have taken the tablespace export it came 2.1gb and for the same user i have taken the schema export it came 5.1gb

why their is a lot of difference in size?

View 3 Replies View Related

Backup & Recovery :: Effect Of Insert On Export (expdp)

Apr 19, 2012

What will be the effect of insert statement on expdp if I am doing full table export?

View 4 Replies View Related

Export/Import/SQL Loader :: How To Export Full Dump And Metadata Of Particular Table

Apr 9, 2013

let us consider mytest schema is having 6 tables

tname tabtype
myt table
myaxpertlog table
abb table
ccc table
ddd table
xxx table

now from this schema i want full dump and also from myaxpertlog table i required metadata only not records.

c:> export mytest/log file=20130409mytest0904pm.dmp tables=(myaxpertlog) rows=n

if i tried i am get only one table but it does have records.

View 6 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 :: 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 :: Why Oracle Generates One More Backup Piece On One Backupset

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

Export/Import/SQL Loader :: Import Dump On Oracle 11g From 10g?

Jan 7, 2013

I have new machine with oracle 11g and i have exported dump from oracle 10g . Now i need to import that dump on oracle 11g.

View 3 Replies View Related

Backup & Recovery :: RMAN Backup Oracle 10g To Be Restored On 11g

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

Backup & Recovery :: Does Oracle Write Any Specify Value To Front Of Every Backup

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

Backup & Recovery :: What %N Determines In Oracle RMAN Backup

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

Backup & Recovery :: Hot Backup Mode - Forgot Put End In Oracle 11g R2?

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

Backup & Recovery :: RMAN Recovery Failing With Incremental Level 0 Backup

Feb 10, 2011

We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?

We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.

View 11 Replies View Related

No Package Bodies In Full Export Dump?

Feb 2, 2011

When exporting a 11g R2 database with expdp using full=y the logfile does not show that package bodies have been exported

(DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC is processed but no DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY)

When importing the dump into an empty database only package specs (besides the other objects) have been imported but all package bodies are missing.

View 5 Replies View Related

Server Utilities :: Export Dump File

Jul 29, 2011

Is it possible to identify what level of export by looking at export dumpfile .. whether it is a schema export,full export,table export,..

If yes.. how ?

View 3 Replies View Related

Server Utilities :: Export Dump Of Large Table

Apr 9, 2010

We have two databases running on 10.2.0.4 and 9.2.0.8. Both are having the same unpartitioned table of size 80G. I am exporting the table on 10g by using parallel=8 and dumpfile with %U option. That took around 4 hours to export the table.

And on 9.2.0.8, i am exporting using below parameters, taking around 5 hours.

buffer=2000000
recordlength=64000

options i can try to speed up the export in both versions.

View 2 Replies View Related

Server Utilities :: Evaluate Export Dump Size

Jan 11, 2012

I want to take a schema level export .The schema size is 115 GB size . Do we require same amount of space to be available in server side (where we are taking a dump) as the schema size or less or more space is required in server side ?

View 6 Replies View Related

Export/Import/SQL Loader :: Importing A Dump Using Parameters

Sep 26, 2012

I'm importing a dump using this parameters:

impdp system schemas=schemaname directory=DIR transform=segment_attributes:n:table dumpfile=FILE.DMP logfile=FILE.logand upon import, i have this error.

Failing sql is:
GRANT SELECT ON "schemaname"."tablename" TO "NAME"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'NAME' does not exist
Failing sql is:

I know that "NAME" was created on the previous instance either role or user where the dump came. My question is, how can i remove this error since this role/user is not needed to the new instance and what parameter should i include to my import script?

View 2 Replies View Related

Backup & Recovery :: ORA-16004 / Backup Database Requires Recovery

Oct 20, 2011

Here is the details

[oracle@localhost dbs]$ export ORACLE_SID=stby
[oracle@localhost dbs]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 20 09:47:34 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> !
[oracle@localhost dbs]$ pwd
/oraeng/app/oracle/product/10.2.0/dbs
[oracle@localhost dbs]$ exit
exit

[code].....

View 1 Replies View Related

Backup & Recovery :: RMAN Backup Deleted Even Within Recovery Window

Oct 18, 2011

I have problem on using "delete obsolete" in RMAN.

First, let describe my backup configuration.

1. Full backup every Monday (17-Oct, 10-Oct, 3-Oct, 26-Sep)
2. Incremental backup for other days
3. Enable autobackup of control file
4. Backup archive log every day
5. RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS
6. Execute "Delete obsolete" every day
7. control file is used instead of catalog

The results observed:
1. Backup of control files older than 30 days will be deleted
2. Backup of archive log files older than 30 days will be deleted.
3. Backup of datafiles older than ~14 days but before 30 days are also DELETED.

In my example, the backup of datafiles created at 26-Sep is deleted at 16-Oct.

I tried "restore database validate until time "sysdate-22"" at 17-Oct. And RMAN reported "datafile xx will be created automatically during restore operation". It seems that RMAN failed to do restoration up to 22 days ago. The retention policy I set seems not effective on datafile backups.

I checked view v$backup_set and the "Keep" is "No" and "Keep until" is empty.

The only thing I can think of, is the settings of "CONTROL_FILE_RECORD_KEEP_TIME". It is marked "7" in the Oracle, which is less than the retention. But I suppose this only causes the backup not deleted, but NOT be deleted earlier.

View 6 Replies View Related

Server Utilities :: How To Export One Table To Few Separated Dump Files

Mar 24, 2010

I have a table with 9 regions. How can I export them in 9 seperated dump file?

View 4 Replies View Related

Server Utilities :: Export / Dump With Expdp For Non-privileged Users?

May 29, 2012

We are DB users (not DBAs) and used always exp/imp bevore application upgrade.

Was googling arround and read something like "Oracle Data Pump - Time to let go of Exp / Imp". It seems exp/imp is obsolete.

Our system doesn't have "expdp" command

> find . -name expdp
>

is this because of too old SQL*Plus?

> sqlplus
SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 29 16:05:28 2012
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter user-name: ^C^C

- does our DBA need to give us privileges to run expdp/impdp?

- is that true that a expdp/impdp dump will be on the Oracle server (not the client machine)?

View 4 Replies View Related

Server Utilities :: Multiple Export / Import Dump Files?

Apr 25, 2011

I am trying to export/import of a schema who's size is around 60 GB.

Export parfile goes like this..
file=expdmp1.dmp, expdmp2.dmp, expdmp3.dmp, expdmp4.dmp, expdmp5.dmp, expdmp6.dmp, expdmp7.dmp
filesize=10240M
log=explog.log
owner=owner1

Import parfile goes like this..

file=impdmp1.dmp, impdmp2.dmp, impdmp3.dmp, impdmp4.dmp, impdmp5.dmp, impdmp6.dmp, impdmp7.dmp
filesize=10240M
log=implog.log
fromuser=owner1
touser=owner2
ignore=y

I am going to run this on production. So want to check it..

View 2 Replies View Related

Export/Import/SQL Loader :: IMP With Multiple Dump Files And Remap_tablespace

Jan 17, 2013

I have 3 dump files: A.dmp, B.dmp, C.dmp . Can I use multiple REMAP_TABLESPACE entries in a par file to remap the table spaces for the above dump file?

Parfile would look something like this:

DIRECTORY=dpump
DUMPFILE=A.dmp,B.dmp,C.dmp
JOB_NAME=import_3_schemas
REMAP_TABLESPACE=A1:D1
REMAP_TABLESPACE=B1:E1
REMAP_TABLESPACE=C1:F1

The first remap entry is only relevant to A.dmp file
The second remap entry is only relevant to B.dmp file
etc.

View 2 Replies View Related

Server Utilities :: Dump - Export Terminated Successfully With Warnings

Dec 6, 2012

When i do run export command through command prompt, its shows below error.

Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp.

C:Documents and SettingsAdministrator>Exp disdeva/disa123@distesta file=D:DAI LY_BACKUPdistesta.dmp log=D:DAILY_BACKUPdistesta.log statistics=none buffer=5 000000 owner=distesta

Export: Release 10.2.0.3.0 - Production on Thu Dec 6 15:06:21 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Release 10.2.0.3.0 - Production Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified users ...

EXP-00010: DISTESTA is not a valid username Export terminated successfully with warnings.

C:Documents and SettingsAdministrator>

When i connect from sqlplus, it doesn't give any erro. What could be the reason?

SQL> conn disdeva/disa123@distesta
Connected.
SQL>

View 8 Replies View Related







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