OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » automatic backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

automatic backup [message #186093]

Sat, 05 August 2006 13:25

csharat
Messages: 7
Registered: August 2006

Junior Member

hi all,
i used to take hotbackup everyday & coldbackup at saterday night 12pm by shutting down the database..i want to do it automatic where the database will close & copies all datafiles, redofiles,controlfile files, parameter file & then automatic start the database ..please anyone help me ..
thanks

Report message to a moderator

Re: automatic backup [message #186095 is a reply to message #186093]

Sat, 05 August 2006 14:35

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You don't mention what O/S you are using.

Is RMAN an option for you?

Report message to a moderator

Re: automatic backup [message #186179 is a reply to message #186095]

Sun, 06 August 2006 19:38

cuisia
Messages: 21
Registered: July 2005

Junior Member

What strategy you want to use on your backup ? If you can use the OS backup, then you need to copy all of your datafiles,redologs and controlfiles into backup drive.

You can run this to your sql.

connect system/manager
alter tablespace system begin backup;
alter tablespace undotbs begin backup;
alter tablespace drsys begin backup;
alter tablespace indx begin backup;
alter tablespace tools begin backup;
alter tablespace temp begin backup;
alter tablespace users begin backup;
alter tablespace oem_repository begin backup;

HOST C:\BUR\BACKUP_6PM.BAT

alter tablespace system end backup;
alter tablespace undotbs end backup;
alter tablespace drsys end backup;
alter tablespace indx end backup;
alter tablespace tools end backup;
alter tablespace temp end backup;
alter tablespace users end backup;
alter tablespace oem_repository end backup;

Note: Backup_6pm.bat

copy C:\ORACLE\ORA90\FBR\SYSTEM01.DBF e:\backup_6pm
copy C:\ORACLE\ORA90\FBR\UNDOTBS01.DBF e:\backup_6pm
copy C:\ORACLE\ORA90\FBR\DRSYS01.DBF e:\backup_6pm
copy C:\ORACLE\ORA90\FBR\INDX01.DBF e:\backup_6pm
copy C:\ORACLE\ORA90\FBR\TOOLS01.DBF e:\backup_6pm
copy C:\ORACLE\ORA90\FBR\TEMP01.DBF e:\backup_6pm
copy C:\ORACLE\ORA90\FBR\USERS01.DBF e:\backup_6pm
copy C:\ORACLE\ORA90\FBR\OEM_REPOSITORY.DBF e:\backup_6pm
copy C:\ORACLE\ORADATA\FBR\CONTROL01.CTL e:\backup_6pm
copy C:\ORACLE\ORADATA\FBR\CONTROL03.CTL e:\backup_6pm
copy C:\ORACLE\ORADATA\FBR\CONTROL02.CTL e:\backup_6pm
copy C:\ORACLE\ORADATA\FBR\REDO01.LOG e:\backup_6pm
copy C:\ORACLE\ORADATA\FBR\REDO02.LOG e:\backup_6pm
copy C:\ORACLE\ORADATA\FBR\REDO03.LOG e:\backup_6pm
copy c:\oracle\ora90\database\initorcl.ora e:\backup_6pm
copy c:\oracle\ora90\database\pwdorcl.ora e:\backup_6pm
copy c:\oracle\admin\fbr\init.ora e:\backup_6pm

You can set the Batch file in Window scheduler in control panel.

Kind Regards,
Mike Cuisia
Oracle DBA
Philippines

Report message to a moderator

Re: automatic backup [message #186180 is a reply to message #186179]

Sun, 06 August 2006 19:49

ebrian
Messages: 2794
Registered: April 2006

Senior Member

With all due respect, whatever you do, DO NOT use the process listed above to conduct a backup of your database. The process listed above is wrong on many levels, so please DO NOT even think about implementing that process for a backup routine.

First off, the OP asked for a cold backup script and the script above is a half-baked hot backup script.

Again, the important questions are:

What O/S is the OP using and is RMAN an option for the OP?

Report message to a moderator

Re: automatic backup [message #186181 is a reply to message #186180]

Sun, 06 August 2006 20:12

cuisia
Messages: 21
Registered: July 2005

Junior Member

Please try this for cold backup.

connect system/manager
shutdown immediate;
HOST C:\BUR\BACKUP_6PM.BAT
startup mount;
alter database open;

Report message to a moderator

Re: automatic backup [message #186321 is a reply to message #186095]

Mon, 07 August 2006 08:28

csharat
Messages: 7
Registered: August 2006

Junior Member

i am using windows 2003server ..there is no RMAN option but if the solution can be done then i can go for RMAN
thanks please help..

Report message to a moderator

Re: automatic backup [message #186323 is a reply to message #186181]

Mon, 07 August 2006 08:41

csharat
Messages: 7
Registered: August 2006

Junior Member

can i put {
connect system/manager
shutdown immediate;
HOST C:\BUR\BACKUP_6PM.BAT
startup mount;
alter database open
}
these queries into a sql file & run it...
can the server automatic login, shutdown & copies all files & again open the database....sorry i dont need login coz its a 24*7 database .,,please help

Report message to a moderator

Re: automatic backup [message #186327 is a reply to message #186323]

Mon, 07 August 2006 09:06

ebrian
Messages: 2794
Registered: April 2006

Senior Member

OK, need a little bit of clarification. In your initial post you said:

csharat wrote on Sat, 05 August 2006 13:25

i want to do it automatic where the database will close & copies all datafiles, redofiles,controlfile files, parameter file & then automatic start the database

but then you just mentioned:

csharat wrote on Mon, 07 August 2006 08:41

its a 24*7 database

So, are you looking to do a cold backup (shutting Oracle down and then backing up) or a hot backup (Oracle remains up and then you backup)?

Report message to a moderator

Re: automatic backup [message #186484 is a reply to message #186327]

Tue, 08 August 2006 02:30

csharat
Messages: 7
Registered: August 2006

Junior Member

hi ebrian,
... i want a coldbackup..please let me know whether i can do it by using windows utility..
thanks

Report message to a moderator

Re: automatic backup [message #186553 is a reply to message #186484]

Tue, 08 August 2006 08:19

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Here's a sample cold backup script to get ya going. If you are actually in ARCHIVELOG mode, then you'll want to modify the script to backup you archive logs.

This can be scheduled thru the Windows task scheduler.

Report message to a moderator

Re: automatic backup [message #186650 is a reply to message #186553]

Tue, 08 August 2006 20:16

cuisia
Messages: 21
Registered: July 2005

Junior Member

your sample script is the same like I submitted before. try my script above... almost the same ....

Report message to a moderator

Re: automatic backup [message #186651 is a reply to message #186650]

Tue, 08 August 2006 21:39

ebrian
Messages: 2794
Registered: April 2006

Senior Member

cuisia wrote on Tue, 08 August 2006 20:16

your sample script is the same like I submitted before. try my script above... almost the same ....

Well it's quite evident that you did not review the script or are unaware of it's functionality. Your script is COMPLETELY static. Your script offers NOTHING for the OP if a new file is added to the database.

It will be too late if the OP isn't archiving or has removed the necessary archive logs and he's in a recovery scenario when he remembers, "OH YEAH, I forgot to modify my backup script to include the new datafile I added last week...how can I explain this to management ???"

Report message to a moderator

Re: automatic backup [message #186657 is a reply to message #186651]

Tue, 08 August 2006 22:27

cuisia
Messages: 21
Registered: July 2005

Junior Member

ofcourse the DBA should know what datafile was been added, then he can add it to his backup scripts. SIMPLE.

Report message to a moderator

Previous Topic:	cannot register backup on catalog and resync fail
Next Topic:	from which point does recovery start ??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 18:06:02 CDT 2024