miércoles, 23 de julio de 2014

How to restore rman database backup on Oracle 9i

If you have two archives one of controlfiles and another of the database

rman NOCATALOG
CONNECT TARGET user/password@bd
SHUTDOWN IMMEDIATE
STARTUP NOMOUNT

RESTORE CONTROLFILE FROM 'D:\XXX\yyy.bk';
ALTER DATABASE MOUNT

-- execute this query and see where are the backuppieces stored
SELECT * FROM V$BACKUP_PIECE
--copy to that location the archive peice, and send the restore

restore database check readonly;
alter database open resetlogs;

miércoles, 30 de abril de 2014

http://sourceforge.net/projects/symphonic/ alternative for Sony sonic stage

Sony SonicStage 4.3 alternative It work, tested :).
This projects gives the same functionality that Sony SonicStage 4.3
http://sourceforge.net/projects/symphonic/