Home » RDBMS Server » Backup & Recovery » restore database
restore database [message #135611] Thu, 01 September 2005 09:21 Go to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

Hi All,
I use the following script to perform an RMAN backup.

su - oracle <<EOF
cd /home/oracle
. PRD.ksh
cd /home/oracle/rman_scripts
#correct path to the recovery catalog
rman target system/tommy rcvcat rman/rman@rman

run {
allocate channel c1 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
allocate channel c2 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
backup
incremental level 0
format '/tmp/PRD%s.bak'
(database include current controlfile ) ;
sql 'alter system archive log current';
}
EOF


what command would I use to perform a restore of the database?

many thanks

Alan.
Re: restore database [message #135656 is a reply to message #135611] Thu, 01 September 2005 13:14 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
at rman prompt simple "restore database" will do.

Regds
Girish
Previous Topic: How can I do a BackUp from ORACLE 9i when a datafile is corrupted
Next Topic: rman image copy
Goto Forum:
  


Current Time: Fri Mar 29 04:23:33 CDT 2024