Thursday, 28 April 2011

restore database , catalog start with option

catalog start with

CATALOG START WITH '/fs1/datafiles/';

connect target /;
startup force nomount;
restore spfile from '${CTL_PIECE}';
shutdown immediate;
startup nomount;
restore controlfile from '${CTL_PIECE}';
shutdown immediate;
startup mount;
catalog start with '${BACKUP_LOC}' noprompt;
restore database;
recover database;
sql 'alter database open resetlogs';
EOF

No comments:

Post a Comment