how do I do a hot backup a database on NT...

[dguywill]

Hi All,
I am trying to back up a database on NT. I already have a the database on Archive log mone. The problem is that I do not have a tape drive on the NT workstation. I will like to backup the database to the hard drive. Is it possible to do that kind of backup? Can someone help me wiht the steps please..
THanks,
Dee..

[marist89]

I would suggest you use RMAN to backup your database. You can read more about it at [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76990/toc.htm[/url]

[sysdba]

Yes, you can.

Basically, you need to put one tablespace a time into
backup mode, copy all datafiles associated with it to
another place, and take the tablespace out of backup mode.

It is better to take look at Oracle Doc, develop
a backup plan, and TEST it!

[Tim Hussar]

1. Copy init.ora to BU dir
2. Place a tablespace in begin BU mode
3. Copy tablespace datafiles to BU dir
4. Place tablespace in end BU mode
5. Repeat steps 3-5 for each tablespace
6. Find current log sequence number, that'll be last redo log of BU
7. Force a log switch so all redo logs are archived
8. Take BU of control file
9. Copy archived logs to BU dir
10. Verify all files have been backed up correctly

---------------------------------
Tim Hussar
Oracle DBA
Timothy.Hussar@bellsouth.com

[Kishore]

First decide to which directory you are taking backup to.
See if the drive can hold all the data files.

Then from SVRMGRL. Issue these commands.

Alter database backup to controlfile to trace;

That will create a readable control file in the udump directory. Move it to your backup directory later.

alter system swith logfile; ensure the present log entries goes to arhive log

alter tablespace <name of tablespace> begin backup;

copy all the datafiles of that tablespace to your backup drive.

alter tablespace <tablespace> end backup
Repeat the above steps until you finish all the tablespaces.

Again issue
alter system switch logfile;

Copy all the archive logfiles.
Copy Init<sid>.ora file.

Remember: You need to test the backup by recovering it, until then don't take it granted that everything went on well.

Good Luck

[denevge]

on NT, use the OCOPY command to copy files during on-line backup.

Regards
Gert

[cravi]

REM ******************************************************
REM * Oracle hot backup script for nt *
REM * Author Ravi 11/20/00 *
REM ******************************************************
connect internal/password@alias;

spool c:\trial2;

select to_char(sysdate,'DD-MON-YY:HH:MI') "Hot Backup Starting Time" from dual;



REM ****** backup system tablespace

alter tablespace system begin backup;
!ocopy73 I:\orant\database\sys.ora d:\bckggg1\sys.ora
alter tablespace system end backup;

REM ****** backup user tablespace

alter tablespace user begin backup;
!ocopy73 I:\orant\database\user.DAT d:\bckggg1\user.DAT
alter tablespace user end backup;

REM ****** backup rollback tablespace
alter tablespace rollback begin backup;
!ocopy73 I:\orant\database\rollback d:\bckggg1\rollback
alter tablespace rollback end backup;

REM ****** backup temp tablespace
alter tablespace temp begin backup;
!ocopy73 I:\orant\database\temp d:\bckggg1\temp
alter tablespace temp end backup;




REM ****** Perform controlfile backup

Alter database backup controlfile to 'H:\orant\bckggg1\ctl1.ora' reuse;
Alter database backup controlfile to 'H:\orant\bckggg1\ctl2.ora' reuse;
alter database backup controlfile to trace;
!ocopy73 I:\orant\bckggg1\ctl1.ora d:\bckggg1\ctl1.ora
!ocopy73 I:\orant\bckggg1\ctl2.ora d:\bckggg1\ctl2.ora


REM ****** Backup online redo-logs

Alter system archive log all;

!ocopy73 I:\orant\database\log1.ora d:\bckggg1\log1.ora
!ocopy73 I:\orant\database\log1a.ora d:\bckggg1\log1a.ora


select to_char(sysdate,'DD-MON-YY:HH:MI') "Hot Backup Ending Time" from dual;

spool off;

[Glenstr]

I wrote a script that you may find handy, its at [url]http://www.teamdba.com[/url] - if you look under NT online backups you will find it there. I also have a formatted version of it in MSword if you like.

email me at stromqgl@alpac.ca if you want the word version.


Glen Stromquist