Stash backup and restore

We are using the backup client to back up the File system and the Oracle database.

When I want to restore I will be using another server, do I also have to set up another Oracle schema user, or can I restore to a local database?

4 answers

1 accepted

Accepted Answer
0 votes

answered

0 votes
Timothy Chin Community Champion Jul 08, 2014

You can do either.

Is this with the override settings? How do specify a local DB on the restore server?

##################################

# Restore properties

##################################

# Optional. Enables overriding JDBC settings during the restore so that the restore can target a different database to

# the one that was backed up. Even if the other JDBC properties are defined, if this property is not set to true the

# JDBC settings will be ignored. If this is set to true then ALL of the following JDBC properties must be supplied.

#jdbc.override=true

# Optional. Ignored if jdbc.override is not set to true. Overrides the JDBC driver to use during restore.

#jdbc.driver=

# Optional. Ignored if jdbc.override is not set to true. Overrides the JDBC URL to use during restore.

#jdbc.url=

# Optional. Ignored if jdbc.override is not set to true. Overrides the JDBC user to use during restore.

#jdbc.user=

# Optional. Ignored if jdbc.override is not set to true. Overrides the JDBC password to use during restore.

#jdbc.password=

0 votes

Mike,

Please have a look at the Stash backup client documentation at https://confluence.atlassian.com/display/STASH/Using+the+Stash+Backup+Client. It contains screenshots and examples of how to do backups and restores.

Cheers,

Michael

Is there an example where the JDBC connection is to the builtin database on the restore server, i.e. The Stash built-in database, which runs HSQLDB,

you'd have to set

jdbc.driver=org.hsqldb.jdbcDriver

jdbc.url=jdbc:hsqldb:${stash.home}/data/db;shutdown=true;hsqldb.tx=mvlocks

jdbc.user=SA

jdbc.password=

But please note that this will restore the database to HSQLDB, which is an in-memory database. If you have a lot of data, you may need to increase the memory settings for Stash.

Thanks, that's what I was looking for, I'll test that out.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Featured Groups

Tuesday tips & tricks: What is the Atlassian Community?

It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...

129 views 6 8
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you