Database Backup and Recovery (MOSC)

MOSC Banner

Recovery of database is facing ORA-01152

edited Jan 5, 2012 12:26AM in Database Backup and Recovery (MOSC) 7 commentsAnswered
Dear All,
I had taken a full backup of a database with the below RMAN script:

run{
configure device type disk backup type to compressed backupset parallelism 2;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
sql 'alter system archive log current';
backup full database format '/archive/backup/yearend_full/tmcprod/%d_%s_%t_%c_DBYR' tag="DB_FULL_YEAREND";
sql 'alter system archive log current';
backup archivelog from time 'sysdate -7' format '/archive/backup/yearend_full/tmcprod/%d_%s_%t_%c_ARCHYR' tag="ARCH_FULL_YEAREND";
backup current controlfile format '/archive/backup/yearend_full/tmcprod/%d_%s_%t_CONTROLYR' tag="CONTFL_FULL_YEAREND";

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