Home » RDBMS Server » Backup & Recovery » Script for cold Backup (10.2.0.3.0 on linux rel4)
Script for cold Backup [message #347072] Wed, 10 September 2008 10:16 Go to next message
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 Go to previous message
BlackSwan
Messages: 25045
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.
Previous Topic: RMAN Recovery
Next Topic: Increased Archivelog backup with RMAN catalog
Goto Forum:
  


Current Time: Wed Dec 07 18:35:30 CST 2016

Total time taken to generate the page: 0.23122 seconds