Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN restore script

RobeenOct 7 2016 — edited Nov 23 2016

Hello,

from the script below

From the script for restore

  1. rman target /
  2. startup nomount
  3. restore controlfile from '/olbackup/rmanbkup/curr.cntl';
  4. alter database mount;
  5. run {
  6. allocate channel c1 device type disk;
  7. allocate channel c2 device type disk;
  8. allocate channel c3 device type disk;
  9. allocate channel c4 device type disk;
  10. set newname for database to new; # if you defined db_file_create_dest
  11. set newname for tempfile 1 to new;
  12. set newname for tempfile 2 to new;
  13. restore database;
  14. switch datafile all;
  15. switch tempfile all;
  16. recover database;
  17. alter database open resetlogs;
  18. release channel c1;
  19. release channel c2;
  20. release channel c3;
  21. release channel c4;
  22. }

line 17, how will RMAN know the location of my backup?

the db_file_create_dest do i need to specify my backup location?

Thanks,

Joe

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2016
Added on Oct 7 2016
13 comments
5,522 views