I have the following problem. I am trying to backup database and restore it on another server (I need to do this to make a standby instance from master instance). On the standby database I have 1 schema, "MASTER". When I restore this database, the restored one does not contain any schema "MASTER". When I look into "Owned users" using SQL Studio, on restored instance, I only see some mystical user "DBSERVICE". When I look into ALL_TABLES, I don't see anything other than 4 tables owned by SYS.
Here are the details: Source instance (to backup): 7.6.00 (build number I'm not sure - how can I tell? - but it is either 16 or 32), 64-bit version, SUSE (by the way, how can I check the build number and the full version info?) Target instance (to restore): 7.6.00.27, 64-bit version, SUSE I do a full data backup on the source instance to a file using Database Manager wizard as described in Maxdb documentation. I create backup instance with the following parameters: param_startsession param_init param_put MAXUSERTASKS 100 param_put DEFAULT_CODE UNICODE param_put _UNICODE YES param_checkall param_commitsession param_addvolume 1 LOG LOG_001 F 2000 param_addvolume 1 DATA DAT_001 F 10000 db_admin Then I restore it from the backup file and activate: medium_put burvis /opt/sdb/backup/BURVIS_COM FILE DATA recover_start burvis db_activate dba,dba load_systab What is wrong? Eduard
