Another Back up question..: oracle, copy

by: geotigerPosted on 2000-09-11 at 10:49:12ID: 4264503

There should be a "to" in the COPY command. It should be

Host Copy D:\orant\database\usr1orcl.ora d:\backup;

or

! Copy D:\orant\database\usr1orcl.ora d:\backup;

by: merithPosted on 2000-09-11 at 10:53:40ID: 4264538

so ! = host?

Let me test this real quick/.....

by: geotigerPosted on 2000-09-11 at 11:20:56ID: 4264727

They are the same in an unix environment. I am not sure whether "!" works in NT environment.

by: merithPosted on 2000-09-11 at 11:56:12ID: 4265206

Still getting the invalid SQL Statement error when I remove the to, it's erroring on the H in host.

I'm using 8.0.5.0 and I'm running this through the oracle worksheet

by: skandalamPosted on 2000-09-11 at 12:08:24ID: 4265377

Yes you will get an error in worksheet.
So go to the MSDOS mode or command mode, use PLUS33 or PLUS80 login as system and execute these commands.

OR
Once you get into MSDOS mode
use svrmgr30
connect internal
use oracle as password
and issue these commnads
it will work

by: merithPosted on 2000-09-11 at 12:10:48ID: 4265394

Some things I've tried...

in SQL*Plus:
entering line by line to see results, does not copy the file.... Executes the statement but with no result.

Run as script, errors on the alter tablespace, says that the ; is an invalid char, remove that and it says the line was not ended correctly

In SQL Worksheet:
Run line by line,Errors on the word HOST
Run as PL/Sql script, Runs and looks fine, just doesn't do anything. No files copied to destination.

I did set privledges for the destination and am logging in as sys.

The current code snip it I am using is:
Alter Tablespace USER_DATA begin Backup;
Host Copy d:\orant\database\usr1orcl.ora d:\backup;
Alter Tablespace USER_DATA end Backup;

Any suggestions?

by: merithPosted on 2000-09-11 at 12:12:23ID: 4265405

OK, let me give your last suggestion a shot

by: geotigerPosted on 2000-09-11 at 12:18:58ID: 4265495

What would you get if you did a "host dir c:\orant"? Did yo get a list of files in the directory? If yes, then "host" does start operating system commands.

by: merithPosted on 2000-09-11 at 12:19:59ID: 4265506

OK, the Plus80 thing worked.. I am still learning my way around and appriciate the help... By chance, can you tell me how to run the script file so that I don't have to type the 300 lines by hand?

by: merithPosted on 2000-09-11 at 12:24:02ID: 4265590

To Geotiger, ! does not seem to be recognized by NT. And the host command is running working correctly..

Turns out my problem was I was running it from the wrong place...

by: merithPosted on 2000-09-11 at 12:25:11ID: 4265597

Thanks for the help..........

by: geotigerPosted on 2000-09-11 at 12:32:57ID: 4265710

Merith,

You can create a dynamic SQL to generate the codes that you need to run; the run the code to do the backup. I have an unix korn shell script to do hot back up for multiple Oracle instances. Here is the help file for the script:

Usage: ./orabackup [options] [oratab or SID:ORACLE_HOME]

options:
-a <B|H|L> specifies action options: B - both hot and logical backup;
H - hot backup only; L - logical (export) backup only.
The default is "B".
-b <bakdir> specifies backup directory. The default is "/u00/oradata/baks".
-e <expdir> specifies export directory. The default is "/u00/oradata/exps".
-l <logdir> specifies log directory. The default is "/u00/oradata/logs".
-d <device|file> specifies output device: tape or output file. The
default is "/dev/rmt/0n". The option "file" means to backup database
to a tar file under directory "/u00/oradata/baks" with its name associated
to the time when this program is run.
-s <tablespace|table|owners> specifies tablespaces for hot backup,
tables or owners for logical backup. The default is null, which
means all.
-t specifies a test mode. The default is not in test mode("N").
-v whether to echo message onto screen. The default is silent mode
("N").
-z compresses datafiles before they are moved to tapes. The default is
no compression("N").

[all|oratab|SID:ORACLE_HOME:SYSTEM_PWD] specifies Oracle databases to
be backed up.

Notes:
1. This program uses three steps to conduct backup: 1) generate a
list of datafiles for each Oracle database first; 2) It generates
a program to be run in svrmgrl; 3) It uses svrmgrl to put
tablespace in backup mode one by one and UNIX tar command to backup
datafiles to a tar file or a tape device.
2. It provides options: 1) to conduct a logic backup, i.e., using exp
to do a full database export; 2) to compress datafiles before
backed up or compress dump files after they have been exported;
3) to backup partial database (currently not implemented).
3. It provides options to define log, backup and export directories.

Question

Another Back up question..

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

oracle

copy

Oracle Database

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press