Oracle Database 11g Release 2 Real Application Clusters with SLVM/RAW on HP-UX Installation Cookbook, September 2010

ManualsBrandsHP ManualsSoftwareHP Serviceguard Extension for RAC (SGeRAC)

'/dev/vg_rac/rorcl_system_1300m', 0, 'SYSTEM');

dbms_backup_restore.restoreDataFileTo(2,

'/dev/vg_rac/rorcl_sysaux_1300m', 0, 'SYSAUX');

dbms_backup_restore.restoreDataFileTo(3,

'/dev/vg_rac/rorcl_undotbs1_512m', 0, 'UNDOTBS1');

dbms_backup_restore.restoreDataFileTo(4,

'/dev/vg_rac/rorcl_users_128m', 0, 'USERS');

dbms_output.put_line(' Restoring ... ');

dbms_backup_restore.restoreBackupPiece('/var/opt/oracle/rac_r2/

assistants/dbca/templates/Seed_Database.dfb', done);

if done then

bms_output.put_line(' Restore done.');

else

bms_output.put_line(' ORA-XXXX: Restore failed ');

end if;

dbms_backup_restore.deviceDeallocate;

end;

• select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual;

30 Execute following commands to create clone databases.

• SET VERIFY OFF

• connect "SYS"/"&&sysPassword" as SYSDBA

• set echo on

• Create controlfile reuse set database "slvmdb"

MAXINSTANCES 32

MAXLOGHISTORY 1

MAXLOGFILES 192

MAXLOGMEMBERS 3

MAXDATAFILES 1024

Datafile

'/dev/vg_rac/rorcl_system_1300m',

'/dev/vg_rac/rorcl_sysaux_1300m',

'/dev/vg_rac/rorcl_undotbs1_512m',

'/dev/vg_rac/rorcl_users_128m'

LOGFILE GROUP 1 ('/dev/vg_rac/rorcl_redo1_1_128m') SIZE 51200K,

GROUP 2 ('/dev/vg_rac/rorcl_redo1_2_128m') SIZE 51200K RESETLOGS;

• exec dbms_backup_restore.zerodbid(0);

• shutdown immediate;

• startup nomount pfile="/var/opt/oracle/admin/slvmdb/scripts/initslvmdbTemp.ora";