| Script for cold Backup [message #347072] |
Wed, 10 September 2008 10:16  |
n.dba
Messages: 6
Registered: September 2008
Location: NJ
|
Junior Member |
|
|
I am searching for the script which include the following
1. Cold backup for the database
2. transfer that cold backup file to remote server.
3. And recreate the database from this cold backup on the remote server.
Please anybody who already practiced this...please let me know
|
|
|
|
| Re: Script for cold Backup [message #347153 is a reply to message #347072] |
Wed, 10 September 2008 21:21  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
If the remote server has identical directory structure, do the following:
1) shutdown immediate source database
2) scp or rcp all necessary files from source system to target system.
3) startup original & cloned DBs each on their own system.
Simply put the cloned/copied files are totally unaware they have been moved & no longer on the original system.
The database was shutdown & later the database was started up again (on 2 different systems). This is NOT rocket science.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
