04-02-2008
I dun support aix but some years I did, back then I remember we did something like this.
I suppose you will have to backup your data to your unix local folder since your aix server dun have a tape drive. use tar or cp or something, if oracle database you have to either export dump file or freeze-cp-unfreeze each tablespace datafile.
alter tablespace abcdef begin backup
!cp -p /u01/data/somedata.dbf /somefolder
alter tablespace abcdef end backup
Then after that from your windows server you write a FTP script and schedule it to automatic logon to unix box to get the files
check man pages for netrc, ftp how you can get some idea
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
I'm trying to come out with a script that uses the 'backup' command to backup large filesystems. Most of the time this data takes two or three DLT tapes to complete. The backup takes too long because operations never sees the message to mount 2nd tape. I have a script that uses sysback and... (1 Reply)
Discussion started by: mvilla0993
1 Replies
2. Shell Programming and Scripting
hi all,
very urgent need backup script on tape using solaris 8, my tape drive is DAT 72 on sun v240.
i need a simple script to backup files from directory /data/log/back/200703/filename.log. the files will backup continue each day on the tape which have 72 GB. the files size only 50MB and... (0 Replies)
Discussion started by: bucci
0 Replies
3. UNIX for Dummies Questions & Answers
Hi there: I'm new here
Can anyone help me:
I have DS15 Alpha server : Unix 5.1B
Now i need to connect a DLVT VS80 1U Rackmount Tape Drive unit.
What is the exact comman to mount the DLTape IV??
How do i make backuo @ copy file to the tape?
Thanx to all (0 Replies)
Discussion started by: ayzeayem
0 Replies
4. AIX
Currently I have a Dell Ultrium LTO 2 Tape Drive. I am going to have a IBM AIX server. Just wonder if it is possibe to connect this tape drive to the aix server? I have Brightstor Arcserver installed on another win 2003 server. Is it possible to install the arcserve agent on the aix and use the... (1 Reply)
Discussion started by: ming413
1 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I performed backup on tape and I want to append more files to my previous backup on the same backup tape. But before I do that I need to know the backup file size of the first backup I performed so that I know the available size on the backup tape. Can someone help me what command I will use... (0 Replies)
Discussion started by: ayhanne
0 Replies
6. AIX
Hi,
Help required!
How to mount internal tape drive of sun machine in AIX 5.3 (0 Replies)
Discussion started by: ashwin.krishna
0 Replies
7. SCO
I am trying to make a full backup of my system using the cpio command. The Tape Unit is a SCSI DDS.
The process started fine but after about 30 minutes, it just stopped and showed the following message:
1755 Signal 31 - Core dumped
Any idea of what is causing this and how to fix it?
... (4 Replies)
Discussion started by: zionpc
4 Replies
8. AIX
Hi,
Can anyone tell how to list files in a AIX 3.2 mksysb backup tape.
Thanks!
Victor Cheung (4 Replies)
Discussion started by: victorcheung
4 Replies
9. AIX
hello,
I am facing this problem when trying to prepare AIX 5.3 for Veritas Backup:
Veritas Software is not able to communicate properly with our tape library
When we tried to run these commands here's the output
# cfgmgr -l fscsi0
# cfgmgr -l fscsi2
# cfgmgr -l fscsi1
cfgmgr:... (3 Replies)
Discussion started by: filosophizer
3 Replies
10. AIX
Hi,
We have backup on LTO-3 tape it was taken from windows via windows backup utility,
now the issue is that we want to list the content of tape in aix 6.1. Kindly help.
Regards
Salman (3 Replies)
Discussion started by: salmanraza
3 Replies
LEARN ABOUT CENTOS
drop_tablespace
DROP
TABLESPACE(7) PostgreSQL 9.2.7 Documentation DROP TABLESPACE(7)
NAME
DROP_TABLESPACE - remove a tablespace
SYNOPSIS
DROP TABLESPACE [ IF EXISTS ] name
DESCRIPTION
DROP TABLESPACE removes a tablespace from the system.
A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it can be
dropped. It is possible that objects in other databases might still reside in the tablespace even if no objects in the current database are
using the tablespace. Also, if the tablespace is listed in the temp_tablespaces setting of any active session, the DROP might fail due to
temporary files residing in the tablespace.
PARAMETERS
IF EXISTS
Do not throw an error if the tablespace does not exist. A notice is issued in this case.
name
The name of a tablespace.
NOTES
DROP TABLESPACE cannot be executed inside a transaction block.
EXAMPLES
To remove tablespace mystuff from the system:
DROP TABLESPACE mystuff;
COMPATIBILITY
DROP TABLESPACE is a PostgreSQL extension.
SEE ALSO
CREATE TABLESPACE (CREATE_TABLESPACE(7)), ALTER TABLESPACE (ALTER_TABLESPACE(7))
PostgreSQL 9.2.7 2014-02-17 DROP TABLESPACE(7)