Backing up the Database

[Former Member]

Hi friends,

During the EHP4 upgrade in a devlopment system, i have run the option as no archive log mode, in the follow up activities in the section backing up the database, it specifies to activate the Archivelog mode and the take a full database offline backup.

My question is in the dev system we use no archive log mode option so in that case is this necessary . We have a offline databse backup every day in the night. So can i ignore this activity.

In the tablespaces i just wanted to confirm from the following tablespaces i would be deleting PSAPSR3700

Tablespace

PSAPSR3

PSAPSR3700

PSAPSR3701

PSAPSR3USR

PSAPTEMP

PSAPUNDO

SYSAUX

SYSTEM

Kindly please reply.

Thanks a lot.

[former_member204746 · Accepted solution]

yes, you drop this tablespace with this command:

brspace -c -u / -f tsdrop -t PSAPSR3700

also, very important, read the following link and pay close attention to step 4: http://wiki.sdn.sap.com/wiki/x/FgQ