Hello folks;
I want to create a database datawarehouse refreshed every morning from the save RMAN/NetBackuP of the production database Oracle 11.2.0.4.
The production database have a size of 2To.
The Netbackup policy is :
-1 full every night at 22:30 PM (ends at 01:00 PM max.)
- every 2hours the archlogs.
My quotidian refreshing plan will be :
0. Initiate this datawarehouse by making a IBM AIX7.1 FlachCopy of the production LPAR during the day for example at 9h00 AM;
0. 1. Change the spfile and orapwd and the dbid (via NID) and the db_unique_name
0. 2. Put the database in noarchivelog mode
1. Crontab a script KSH/RMAN every morning at 3:00 AM with theses instructions:
1. 1. Restart the database in NOMOUNT mode and activate the archivelog mode
1. 2. Run this RMAN script :
rman target=/ catalog=rman/****@REPO_RMAN <<!EOF
RUN{
allocate channel ch1 type 'sbt_tape';
allocate channel ch2 type 'sbt_tape';
allocate channel ch3 type 'sbt_tape';
allocate channel ch4 type 'sbt_tape';
allocate channel ch5 type 'sbt_tape';
allocate channel ch6 type 'sbt_tape';
allocate channel ch7 type 'sbt_tape';
allocate channel ch8 type 'sbt_tape';
set dbid 3242800820; -- dbid of the production database
SET UNTIL TIME 'SYSDATE-2/24'; -- date - 2 hours
RESTORE DATABASE; -- it is really necessary ??
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
}
exit;
!EOF
}
1.3 . With RMAN crosscheck archlog all and delete obsolete archlog from log_destinatation
1.4 . Put the database in NOarchivelog mode.
=> Please give me your feedback about this quotidian refresh plan.
If you need more information I 'm your man .
Regards.
Antoine