Home » RDBMS Server » Backup & Recovery » Media Recovery
Media Recovery [message #172546] Wed, 17 May 2006 02:59 Go to next message
orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad
Senior Member


suppose, My backup of all physical files of database has been
stolen or copied by someone.

Can he create a new database using these datafile/controlfiles and other files?

If yes, then what does the security mean.

please explain


Thanks

Report message to a moderator

Re: Media Recovery [message #172550 is a reply to message #172546] Wed, 17 May 2006 03:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Nothing much. Because
>> stolen or copied by someone.
Stolen. You are already in deep trouble. Database is the last layer here. If someone can compromise your network security, system security and storage area / backup systems security, hire him.
copied. You cannot avoid it. This 'someone' who must be authorized to do 'something' in the server is either ROOT or ORACLE user, with whom you must trust your services. Once the database is shutdown or data is off the database, oracle has no control.

Report message to a moderator

Re: Media Recovery [message #172559 is a reply to message #172550] Wed, 17 May 2006 03:41 Go to previous messageGo to next message
orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad
Senior Member
Thanks Mahesh,

Just one more doubt.
Can we recover all the data objects including users using
old physical files (backup)

or

where all tables/synonyms/view...etc will be opened?
I mean in which schema in newly created database.

Report message to a moderator

Re: Media Recovery [message #172563 is a reply to message #172559] Wed, 17 May 2006 03:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not sure i understood your question.
>> I mean in which schema in newly created database.
Where ever it was. If SCOTT had some tables before, SCOTT will have the same table again. As long as the 'backup' consists of clean offline copies of traced controlfile,controlfile,logfiles,init.ora and datafiles, you can re-create the database anywhere you want (same OS,version).

Report message to a moderator

Re: Media Recovery [message #172566 is a reply to message #172563] Wed, 17 May 2006 04:07 Go to previous messageGo to next message
orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad
Senior Member
 

Thanks again Mahesh,

What I want to know is:
suppose my old datafile contains data objects from 3 users(Scott,myora,xyz).

In newly created Database using old datafiles and other
required files, will Oracle create new users (myora, xyz)
including their objects?
and newly created scott user will show old tables also.

please let me know...

Report message to a moderator

Re: Media Recovery [message #172568 is a reply to message #172566] Wed, 17 May 2006 04:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
all objects from all schema will be recreated (actually nothing to recreate here in this case of offline backups).
You are just copying the datafiles to a new location and mounting them.

Report message to a moderator

Re: Media Recovery [message #172572 is a reply to message #172568] Wed, 17 May 2006 04:25 Go to previous messageGo to next message
orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad
Senior Member
 

Well Mahesh, 
Thanks for instant response and your precious time.

Actual I have two O/Ss (Linux and Win-Xp) in my system.
XP has Oracle 9iR1
Linux has Oracle 9iR2

Can I use XP's Oracle physical files in Linux's Database
or Vice-versa (as we discussed above on re-using datafiles)

Report message to a moderator

Re: Media Recovery [message #172575 is a reply to message #172572] Wed, 17 May 2006 04:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
NO. You cannot. Datafiles are OS specific.
In case of a different OS, use exp/imp or transportable tablespace to move data.

Report message to a moderator

Re: Media Recovery [message #172580 is a reply to message #172575] Wed, 17 May 2006 04:35 Go to previous messageGo to next message
orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad
Senior Member

Ok,

>>Transportable Tablespace

Tablespaces contains datafiles, are they not O/S specific then?


Anyway Thanks Mahesh for your precious response.

Report message to a moderator

Re: Media Recovery [message #172583 is a reply to message #172580] Wed, 17 May 2006 04:40 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#i1010932

Report message to a moderator

Previous Topic: Size of Rman incremental level 1 backup is higher than level 0
Next Topic: data block corruption
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 10:37:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.