Steps (1 to 10) to restore database on another server
1. create directory structure
2. add database to /etc/oratab or /var/opt/oracl/oratab
3. copy init.ora file from source
4. edit init.ora – replace controlfile name with diskgroup name such as ORADATA
5. startup nomount
6. start restore using restore shell script
(NOTE : This will restore archive log files too)
7. monitor alert.log and restore log
8. after restore and recover completes
9. edit inot.ora file - replace controlfile parameter with real name
10. startup database; open for business
Sample init.ora file
processes = 500
backup_tape_io_slaves = TRUE
sga_target = 700m
control_files = "+ORADATA001", "+ORAFLASH001"
control_file_record_keep_time= 14
db_block_size = 8192
compatible = 10.2.0.4.0
log_archive_format = %t_%s_%r.arc
log_checkpoint_timeout = 0
db_file_multiblock_read_count= 16
db_create_file_dest = +ORADATA001
db_create_online_log_dest_1= +ORADATA001
db_create_online_log_dest_2= +ORAFLASH001
db_recovery_file_dest = +ORAFLASH001
db_recovery_file_dest_size= 107374182400
fast_start_mttr_target = 900
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 18000
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 10
background_dump_dest = /ora01/oracle/admin/demo/bdump
user_dump_dest = /ora01/oracle/admin/demo/udump
core_dump_dest = /ora01/oracle/admin/demo/cdump
audit_file_dest = /ora01/oracle/admin/demo/adump
db_name = MZXP
open_cursors = 5000
pga_aggregate_target = 524288000
Sample restore command script : rman_restore_db.cmd
# script for restoring from an inconsistent backup, ie archivelog mode database
# change DBID ###
# change NB_ORA_CLASS as appropriate ###
# change set option as appropriate ###
set echo on;
host 'echo Starting restore at $(date).';
#set DBID = DBID;
startup nomount pfile='/ora01/oracle/admin/demo/pfile/initDEMO.ora'; # because there is no controlfile
run {
allocate channel t1 type sbt;
allocate channel t2 type sbt;
set command id to 'rman restore';
# step 1 - restore controlfile from autobackup, faster if give explicit file name from list backup
# restore controlfile from autobackup;
restore controlfile from 'c-49-20110602-02'; # change file name
alter database mount; # start using the restored controlfile
# step 2 - set the recover to time using scn, time, or sequence #
# omitting recovers to current time
# the scn and sequence number can be determined from the list backup output
# set until scn 562449965260;
set until time "to_date('06-02-2011 18:00:00','mm-dd-yyyy hh24:mi:ss')";
# set until sequence nnnn thread 1;
# use set newname commands here if restoring to a different directory structure, for ex
# set newname for datafile '/db/ora01/oracle/admin/ORA_SID/link/system01.dbf'
# to '/ora01/oracle/admin/ORA_SID/link/system01.dbf';
# step 3 - restore the datafiles from the full backup based on set until command
restore database;
# switch datafile all; # if used set newname command, changes the names in the contro
# step 4 - recover applies logs up to set until time. It will restore logs from tape if
recover database;
# step 5 - open the database and recreate the online redo logs
alter database open resetlogs;
}
host 'echo Ending restore at $(date).';
# end of script
Sample restore shell script : restore.sh
. ~/.profile
ORACLE_SID=DEMO;ORAENV_ASK=NO;. oraenv;ORAENV_ASK=YES
cd /ora01/oracle/admin/BACKUP/DEMO
rman nocatalog target / cmdfile rman_restore_db.cmd
status=$?
exit $status
Hope this helps! Rupam
