Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database refresh Steps

590184Aug 28 2007 — edited Sep 3 2007
Hi,
Can anyone give the procedure for DB Refresh pls?
I couldnot find a clear explanation anywhere.
Bipin

Comments

oradba
What is database refresh? Never heard of it, at least in the Oracle context.


Werner
590184
Sory Werner if im wrong, Does the following forum explain about db refresh or they are just talking about cloning...
1921299
I thought Refreshing the test db with production is termed as "db refresh"..
Is it so? Can u pls explain?
Bipin
594974
i think if you have connectivity between both servers then you can shutdown n copy all datafiles n redo logs from primary server to secondry(clone). this way your database will be refreshed.
or
you may use dataguard. that way primary node will automatically be refreshed automatically.
aps
416047
For those interested here are some thoughts about the refresh process from Doug Burns.

http://oracledoug.com/serendipity/index.php?url=archives/1304-Full-Volume-Database-Refresh-Part-1.html

http://oracledoug.com/serendipity/index.php?/archives/1305-Full-Volume-Database-Refresh-Part-2.html

http://oracledoug.com/serendipity/index.php?/archives/1306-Full-Volume-Database-Refresh-Part-3.html
549698
Well,

At my place when we talk about DB refresh means shutdown the db and start it bck.

1)stop lsnr
2)shutdown db
3)start lsnr
4)start db
590184
Hi All,
Thanks a lot that takes care of my doubt..
Bipin
Maran Viswarayar
1921305

This will give enough insights
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 1 2007
Added on Aug 28 2007
#general-database-discussions
7 comments
1,410 views