Oracle 11g Back up and restore Chalanachithram.com | Topics | Search
Hide Clipart | Log Out | Register | Edit Profile

Last 30 mins | 1 | 2 | 4 hours     Last 1 | 7 Days

Chalanachithram.com DB » TF Industry related » Archive through August 03, 2012 » Oracle 11g Back up and restore « Previous Next »

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Goonda
Megastar
Username: Goonda

Post Number: 20718
Registered: 02-2007
Posted From: 75.66.158.123

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 03, 2012 - 03:10 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

there is a tool out there that refreshes/backsup Oracle Apps DB or oracle DB. its called clontab, the website http://www.clonetab.com/
Sasibabu: If TDP loses next elechens, i will donate 10% of my salary to TDP

Skywalker: Bala chiru type kadu.....narasimha swamy avataram etti posani gadi pegulu medalo esukuntadu
Top of pagePrevious messageNext messageBottom of page Link to this message

Vasista
Junior Artist
Username: Vasista

Post Number: 60
Registered: 05-2012
Posted From: 24.17.132.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 03, 2012 - 02:53 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

11g enterprise (but free version off of oracle site)
Top of pagePrevious messageNext messageBottom of page Link to this message

Dma
Side Hero
Username: Dma

Post Number: 6529
Registered: 11-2009
Posted From: 98.174.228.58

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 03, 2012 - 01:42 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Vasista:

Vasista




What version of Oracle? Enterprise or XE?
Top of pagePrevious messageNext messageBottom of page Link to this message

Vasista
Junior Artist
Username: Vasista

Post Number: 59
Registered: 05-2012
Posted From: 24.17.132.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 03, 2012 - 01:36 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

thanks.. I dont see a step to move data files from old home to newer one.

Purpose is to take a copy of an existing database, and then do an upgrade (not oracle, but application that i am using). So i will have old data base intact while playing with the upgrade.
Top of pagePrevious messageNext messageBottom of page Link to this message

Funny
Side Hero
Username: Funny

Post Number: 4349
Registered: 08-2008
Posted From: 66.25.7.232

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 03, 2012 - 01:17 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

simply moving db instances to new oracle home ayithe follow below steps:

1. install new oracle home
2. move listener.ora file from old to new and change home path in the file for instances.
3. change path in oratab file.
4. copy init.ora files from old to new and change path in init.ora files for instances.
5. set new home environment variables for oracle user.
6. login to oracle export SID and then start the db's.

let me know what errors you see.
Take it easy
Top of pagePrevious messageNext messageBottom of page Link to this message

Funny
Side Hero
Username: Funny

Post Number: 4348
Registered: 08-2008
Posted From: 66.25.7.232

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 03, 2012 - 01:09 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

purpose of creating a new home??

Upgrade or applying patch?
Take it easy
Top of pagePrevious messageNext messageBottom of page Link to this message

Vasista
Junior Artist
Username: Vasista

Post Number: 58
Registered: 05-2012
Posted From: 24.17.132.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 03, 2012 - 11:09 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

Any oracle experts here?

Oracle 11g running on Win 7 at db_home1, this has 4 db instances. All i need to do is to create a new db home db_home2 and copy all the instances to the new db home.

I have SQL Developer installed.

I tried with online scripts and RMan process, but have issues. so step by step would be better.

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x88fa1cc){Movie Clipart}
Show / Hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  


Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: