on 04-02-2015 11:30 AM
I attempting to backup and restore a copy of a SAP DB with a new name using HANA Studio.
I have have managed to backup successfully but restoring a copy is throwing up a couple of errors –
The following errors are showing on restore:
Could not execute 'IMPORT "DB"."*" AS BINARY FROM '/hana/backup/james' WITH REPLACE threads 10 RENAME ...' in 70 ms 380 µs .
SAP DBTech JDBC: [2]: general error: DB.ETL_S
DB:JDT1_tracking not found in the import directory.
The SQL I used as follows:
for the backup = EXPORT "DB"."*" AS BINARY INTO '/hana/backup/james' WITH REPLACE THREADS 10
for the restore = IMPORT "DB"."*" AS BINARY FROM '/hana/backup/james' WITH REPLACE THREADS 10 RENAME SCHEMA "DB" TO "DBTEST"
All suggestions appreciated!
Kind Regards,
James
Hi James,
Please check SAP Note 2114106 (Delete invalid triggers in SAP HANA if schema import fails because tracking tables cannot be found) It requires an S-user account.BestYou must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi James ,
try this
delete the existing back up & folder and create the same folder with all rights.
use below commands
for export
EXPORT “DB_NAME”.”*” AS BINARY INTO /hana/backup/james' with replace;
to import
Import "DB_Name"."*" as binary from /hana/backup/james' with replace threads 10 rename schema "DB_Name" to "DB_Rename";
--Manish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.