OraFAQ Forum: Backup & Recovery » Regarding Cold Backup

Home » RDBMS Server » Backup & Recovery » Regarding Cold Backup (9i,10g)

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

Regarding Cold Backup [message #392137]

Mon, 16 March 2009 10:09

asmfloyd
Messages: 2
Registered: March 2009

Junior Member

Hi all,
I am new to DB backups.I have 2 questions which are as follows:

Que1.
If I do a cold backup using RMAN which is as follows:
"backup database"

Under which path by defalut the back up gets saved?Is it under the same path as
C:\Oracle\oradata\dbname
Or is it under some other path?

Que2.I can do a cold back by finding the path of the files:
select * from v$datafile;
select * from v$controlfile;
select * from v$logfile;
Get the path from the above three queries.Go there and copy all the files.In this backup, why I need to shut down the database before copying the files?Why can't I copy the files while the database is running too?

Please let me know.

Thanks,
Floyd

Report message to a moderator

Re: Regarding Cold Backup [message #392140 is a reply to message #392137]

Mon, 16 March 2009 10:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Depends on various parameters set.
You can manually control it inside rman script.

>>I can do a cold back by finding the path of the files:
You dont have to. It is old school. RMAN will just backup everything required for you.
>>Why can't I copy the files while the database is running too?

Because it is 'cold' bakup. You do a consistent backup. otherwise, you need to a hot backup.
if you are doing with rman, just bring the database to mount stage.

Report message to a moderator

Re: Regarding Cold Backup [message #392142 is a reply to message #392140]

Mon, 16 March 2009 10:35

asmfloyd
Messages: 2
Registered: March 2009

Junior Member

Thanks Mahesh for the immediate response.
I)Then can you tell me how I will point the output of "backup database",to a particular folder(Say D:\backup).I did some backup by saying "backup database".But I do not know now under which path it got saved to. (:
II) Ok.So you mean like if I copy the same files while the DB is running(as a hot backup),still the same will work (till the point to which I took the backup)?
Sorry for troubling much

Report message to a moderator

Re: Regarding Cold Backup [message #392144 is a reply to message #392137]

Mon, 16 March 2009 10:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

The following & others can be found at http://tahiti.oracle.com

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/toc.htm

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Regarding Cold Backup [message #392145 is a reply to message #392142]

Mon, 16 March 2009 10:44

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i)use allocate channel or set it in RMAN configuration.
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta4.htm
ii)>>Ok.So you mean like if I copy the same files while the DB is running
I never said that.
I said, you do not copy the files with RMAN (hot or cold).
Copying the files is old school, user managed backups.
With RMAN use

rman> backup database;

if you are doing RMAN hot, use

rman> backup database plus archivelog

And just refer docs. It is all written there.
And please search this forum/google/docs before posting.

Report message to a moderator

Previous Topic:	Database transform with RMAN
Next Topic:	TSPITR via RMAN in a Data Guard Environment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 13:08:36 CST 2024