OraFAQ Forum: Backup & Recovery » creating test database

Home » RDBMS Server » Backup & Recovery » creating test database (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

creating test database [message #420711]

Tue, 01 September 2009 13:53

shadab
Messages: 4
Registered: August 2009
Location: india

Junior Member

i want to create a test database and a test user and import data from production databse through dump files. please help me how to do this.

Report message to a moderator

Re: creating test database [message #420713 is a reply to message #420711]

Tue, 01 September 2009 13:59

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What do you know yet?
Do you know how to create a database?
Do you know how to export a database?
Do you know how to backup a database?
Do you know how to restore a database?
Do you know how to duplicate a database?

Regards
Michel

Report message to a moderator

Re: creating test database [message #420714 is a reply to message #420711]

Tue, 01 September 2009 14:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

All answers can be found a few clicks beyond URL below.

http://www.oracle.com/pls/db92/homepage?remark=tahiti

When all else fails, Read The Fine Manuals

Report message to a moderator

Re: creating test database [message #420729 is a reply to message #420713]

Tue, 01 September 2009 19:05

shadab
Messages: 4
Registered: August 2009
Location: india

Junior Member

Michel

I have just created a database using DBCA. But i want learn creating the same using command lines. I have been assigned a task to create a database for testing and it should be loaded with production data dump. So please tell what i need to learn more.

Regards

shadab

[Updated on: Tue, 01 September 2009 19:06]

Report message to a moderator

Re: creating test database [message #420730 is a reply to message #420711]

Tue, 01 September 2009 19:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>So please tell what i need to learn more.
RMAN

Report message to a moderator

Re: creating test database [message #420736 is a reply to message #420729]

Tue, 01 September 2009 22:56

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

I'd suggest you to use DUPLICATE DATABASE command in RMAN to create clone of your database in any host you want

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#BRADV169

Report message to a moderator

Re: creating test database [message #420737 is a reply to message #420711]

Tue, 01 September 2009 23:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#BRADV169
Providing URL to V10.2 documentation to the OP running V9 may be less than useful for OP who appears to be documentation challenged.

Report message to a moderator

Re: creating test database [message #420738 is a reply to message #420737]

Tue, 01 September 2009 23:17

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

No problem, I can provide 9i documentatoin as well Smile

Here it is:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmdupdb.htm

Report message to a moderator

Previous Topic:	RMAN Not Removing Obsolete Backups
Next Topic:	RMAN-04005: error from target database: ORA-01031: insufficient privileges

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:11:48 CDT 2024