Database Backup and Recovery (MOSC)

MOSC Banner

RMAN recover and restore from non default location

edited Sep 8, 2009 3:08AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
 Hi,


We have implemented RMAN to replace our conventional hot backup process
We are using ASM and disk based backups are getting written to +FRA disk group
We are using IMAGE COPIES backup and retention policy is set to recovery window of 1 day
After the RMAN backup to disk is completed, We are using DBMS_FILE_TRANSFER.cOPY_FILE to copy the RMAN backup to a locally mounted ("/backup")remote network location
While copying the image copy datafiles we are adding .dbf suffix and for the spfile and control file backup peice, we are adding .cfspf
for example, from +FRA, the image copy backup file users.1082.691212123 would be copied to the network location "/backup" as users.1082.691212123.dbf

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center