Sfrgttk

Have the tides ever turned twice on any open problem?

HP P840 HDD RAID 5 many strange drive failures

Why are there no stars visible in cislunar space?

Geography in 3D perspective

A Ri-diddley-iley Riddle

Can a wizard cast a spell during their first turn of combat if they initiated combat by releasing a readied spell?

Should I be concerned about student access to a test bank?

PTIJ What is the inyan of the Konami code in Uncle Moishy's song?

Help prove this basic trig identity please!

Light propagating through a sound wave

Are dual Irish/British citizens bound by the 90/180 day rule when travelling in the EU after Brexit?

How to generate binary array whose elements with values 1 are randomly drawn

What does "mu" mean as an interjection?

Variable completely messes up echoed string

How is the partial sum of a geometric sequence calculated?

Relation between independence and correlation of uniform random variables

Turning a hard to access nut?

In Aliens, how many people were on LV-426 before the Marines arrived​?

Help rendering a complicated sum/product formula

How can an organ that provides biological immortality be unable to regenerate?

What can I do if I am asked to learn different programming languages very frequently?

Why is there so much iron?

Asserting that Atheism and Theism are both faith based positions

Why didn't Héctor fade away after this character died in the movie Coco?

Importing data into Oracle 12

Recover oracle 10g database from old data filesConvert or open Oracle 7.3.x database in Oracle 11is there a DB client which supports oracle editions?Oracle 12C, cannot drop NOT NULL constraint on a DEFAULT ON NULL columnImport Database from Oracle .DBF filesMigrate/Export DB from Oracle 11g Enterprise to Oracle 11g ExpressImporting Oracle12c databaseOracle Database Client 12c Product ComponentsCan not install oracle apex on GNU/Linux (db 12c)Oracle Data Pump for extracting DDL as a set of files – one per object

2

1

I got a set of files from a client which are, as far as I can tell, copies of a database in Oracle 11.

Each folder has the following structure:

- init<DB>.ora

- orapw<DB>

- arch

  - dbf or dbf.gz files

- bkup

  - gz files

How can I import these into Oracle 12? Or should I try installing Oracle 11?

I'm new to Oracle, please excuse me.

oracle oracle-11g-r2 oracle-12c

share|improve this question

asked Aug 28 '14 at 15:14

nsousansousa

1313

bumped to the homepage by Community♦ 7 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  In this case you are not importing, you probably going to restore a db backup using 'rman' (hopefully that is what your client sent you). Lookup 'oracle database restore using RMAN' on Google. You probably need help from a dba, get it if you can. It will save you time.
  
  – Raj
  Aug 28 '14 at 19:52
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, I'll do that. All the dbas are busy with a higher priority project, but I'll try to get some input from them.
  
  – nsousa
  Aug 29 '14 at 9:06
  

  
  
  
  

add a comment | 

2

1

I got a set of files from a client which are, as far as I can tell, copies of a database in Oracle 11.

Each folder has the following structure:

- init<DB>.ora

- orapw<DB>

- arch

  - dbf or dbf.gz files

- bkup

  - gz files

How can I import these into Oracle 12? Or should I try installing Oracle 11?

I'm new to Oracle, please excuse me.

oracle oracle-11g-r2 oracle-12c

share|improve this question

asked Aug 28 '14 at 15:14

nsousansousa

1313

bumped to the homepage by Community♦ 7 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  In this case you are not importing, you probably going to restore a db backup using 'rman' (hopefully that is what your client sent you). Lookup 'oracle database restore using RMAN' on Google. You probably need help from a dba, get it if you can. It will save you time.
  
  – Raj
  Aug 28 '14 at 19:52
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, I'll do that. All the dbas are busy with a higher priority project, but I'll try to get some input from them.
  
  – nsousa
  Aug 29 '14 at 9:06
  

  
  
  
  

add a comment | 

I got a set of files from a client which are, as far as I can tell, copies of a database in Oracle 11.

Each folder has the following structure:

- init<DB>.ora

- orapw<DB>

- arch

  - dbf or dbf.gz files

- bkup

  - gz files

How can I import these into Oracle 12? Or should I try installing Oracle 11?

I'm new to Oracle, please excuse me.

oracle oracle-11g-r2 oracle-12c

share|improve this question

asked Aug 28 '14 at 15:14

nsousansousa

1313

- init<DB>.ora

- orapw<DB>

- arch

  - dbf or dbf.gz files

- bkup

  - gz files

share|improve this question

asked Aug 28 '14 at 15:14

nsousansousa

1313

share|improve this question

asked Aug 28 '14 at 15:14

nsousansousa

1313

asked Aug 28 '14 at 15:14

nsousansousa

1313

asked Aug 28 '14 at 15:14

nsousansousa

1313

1 Answer
1

active

oldest

votes

0

What you're asking here is essentially a crash-course in being a DBA. I'll try to explain this by sequentially explaining how the Oracle Database software comes to life at startup.

An "instance" is the Oracle software running in memory, before it touches any files. It goes away when the power is switched off.

init<DB>.ora is the instance parameter file. (This is a human-readable PFILE, which is one of two kinds of parameter file. The other is a binary SPFILE.) This is what defines the parameters to start the Oracle Database software in memory, such as how much memory to use. Yours may not look like theirs, and it doesn't have to. The most important parameters here are the database name and the location(s) of the controlfile(s).

After the instance starts and allocates memory, it then "mounts" a controlfile. This defines the other files that are available, the state/version level of transactions in the system, and other extremely high-level metadata. Note that we're still not up to the part that considers the user data in the database. Like an SPFILE, a controlfile is stored in a binary format, but also like a PFILE, the controlfile can be backed up "to trace" to generate a human-readable means of recreating it. Note that only the binary version can actually be used.

The parameter file defines the instance, and the controlfile defines the database.

A "database" is the collection of files on the disk. This is where the business data and the logical metadata is stored. After the instance mounts the controlfile, it reads the controlfile and "opens" the database. If it's missing any data files--or they fail consistency checks--it won't open.

The challenging part of answering this properly is that both the instance parameter file and the controlfile(s) will likely need to be recreated on your end if you're going to have any luck accomplishing what you'd like to do.

This is not unlike duplicating a production database to a test environment, detailed here: http://www.dba-oracle.com/oracle_tips_db_copy.htm

share|improve this answer

answered Jun 13 '17 at 18:04

durettedurette

398213

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f75216%2fimporting-data-into-oracle-12%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

What you're asking here is essentially a crash-course in being a DBA. I'll try to explain this by sequentially explaining how the Oracle Database software comes to life at startup.

An "instance" is the Oracle software running in memory, before it touches any files. It goes away when the power is switched off.

init<DB>.ora is the instance parameter file. (This is a human-readable PFILE, which is one of two kinds of parameter file. The other is a binary SPFILE.) This is what defines the parameters to start the Oracle Database software in memory, such as how much memory to use. Yours may not look like theirs, and it doesn't have to. The most important parameters here are the database name and the location(s) of the controlfile(s).

After the instance starts and allocates memory, it then "mounts" a controlfile. This defines the other files that are available, the state/version level of transactions in the system, and other extremely high-level metadata. Note that we're still not up to the part that considers the user data in the database. Like an SPFILE, a controlfile is stored in a binary format, but also like a PFILE, the controlfile can be backed up "to trace" to generate a human-readable means of recreating it. Note that only the binary version can actually be used.

The parameter file defines the instance, and the controlfile defines the database.

A "database" is the collection of files on the disk. This is where the business data and the logical metadata is stored. After the instance mounts the controlfile, it reads the controlfile and "opens" the database. If it's missing any data files--or they fail consistency checks--it won't open.

The challenging part of answering this properly is that both the instance parameter file and the controlfile(s) will likely need to be recreated on your end if you're going to have any luck accomplishing what you'd like to do.

This is not unlike duplicating a production database to a test environment, detailed here: http://www.dba-oracle.com/oracle_tips_db_copy.htm

share|improve this answer

answered Jun 13 '17 at 18:04

durettedurette

398213

add a comment | 

0

What you're asking here is essentially a crash-course in being a DBA. I'll try to explain this by sequentially explaining how the Oracle Database software comes to life at startup.

An "instance" is the Oracle software running in memory, before it touches any files. It goes away when the power is switched off.

init<DB>.ora is the instance parameter file. (This is a human-readable PFILE, which is one of two kinds of parameter file. The other is a binary SPFILE.) This is what defines the parameters to start the Oracle Database software in memory, such as how much memory to use. Yours may not look like theirs, and it doesn't have to. The most important parameters here are the database name and the location(s) of the controlfile(s).

After the instance starts and allocates memory, it then "mounts" a controlfile. This defines the other files that are available, the state/version level of transactions in the system, and other extremely high-level metadata. Note that we're still not up to the part that considers the user data in the database. Like an SPFILE, a controlfile is stored in a binary format, but also like a PFILE, the controlfile can be backed up "to trace" to generate a human-readable means of recreating it. Note that only the binary version can actually be used.

The parameter file defines the instance, and the controlfile defines the database.

A "database" is the collection of files on the disk. This is where the business data and the logical metadata is stored. After the instance mounts the controlfile, it reads the controlfile and "opens" the database. If it's missing any data files--or they fail consistency checks--it won't open.

The challenging part of answering this properly is that both the instance parameter file and the controlfile(s) will likely need to be recreated on your end if you're going to have any luck accomplishing what you'd like to do.

This is not unlike duplicating a production database to a test environment, detailed here: http://www.dba-oracle.com/oracle_tips_db_copy.htm

share|improve this answer

answered Jun 13 '17 at 18:04

durettedurette

398213

add a comment | 

What you're asking here is essentially a crash-course in being a DBA. I'll try to explain this by sequentially explaining how the Oracle Database software comes to life at startup.

An "instance" is the Oracle software running in memory, before it touches any files. It goes away when the power is switched off.

init<DB>.ora is the instance parameter file. (This is a human-readable PFILE, which is one of two kinds of parameter file. The other is a binary SPFILE.) This is what defines the parameters to start the Oracle Database software in memory, such as how much memory to use. Yours may not look like theirs, and it doesn't have to. The most important parameters here are the database name and the location(s) of the controlfile(s).

After the instance starts and allocates memory, it then "mounts" a controlfile. This defines the other files that are available, the state/version level of transactions in the system, and other extremely high-level metadata. Note that we're still not up to the part that considers the user data in the database. Like an SPFILE, a controlfile is stored in a binary format, but also like a PFILE, the controlfile can be backed up "to trace" to generate a human-readable means of recreating it. Note that only the binary version can actually be used.

The parameter file defines the instance, and the controlfile defines the database.

A "database" is the collection of files on the disk. This is where the business data and the logical metadata is stored. After the instance mounts the controlfile, it reads the controlfile and "opens" the database. If it's missing any data files--or they fail consistency checks--it won't open.

The challenging part of answering this properly is that both the instance parameter file and the controlfile(s) will likely need to be recreated on your end if you're going to have any luck accomplishing what you'd like to do.

This is not unlike duplicating a production database to a test environment, detailed here: http://www.dba-oracle.com/oracle_tips_db_copy.htm

share|improve this answer

answered Jun 13 '17 at 18:04

durettedurette

398213

share|improve this answer

answered Jun 13 '17 at 18:04

durettedurette

398213

answered Jun 13 '17 at 18:04

durettedurette

398213

answered Jun 13 '17 at 18:04

durettedurette

398213