OraFAQ Forum: Backup & Recovery » how to couple archived redo logs backup and cold backup together

Home » RDBMS Server » Backup & Recovery » how to couple archived redo logs backup and cold backup together

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

how to couple archived redo logs backup and cold backup together [message #154687]

Tue, 10 January 2006 04:00

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

Hi all,
I make cold backup for my database. I have scheduled backups of 11 p.m. every night and your database crashes at 11:30 a.m. in the morning.Because the latest backup I have is only of the previous night. So all the changes to the database from 11 p.m. to 11:30 a.m. will be lost.In order to avoid this, archived redo logs are backed up and they are coupled with the cold backups to provide recovery to the point of failure.

I have a cold backup at 11 p.m.
I have archived redo logs backup after 11 p.m.

But I don't know how to couple archived redo logs backup and cold backup together

Can anybody help me???????
thanks,

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154701 is a reply to message #154687]

Tue, 10 January 2006 04:32

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

Senior Member
Account Moderator

If your database is in archived log mode,
why are you doing a cold backup?

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154708 is a reply to message #154701]

Tue, 10 January 2006 04:45

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

because my database contains a lot of Data. I think that, Hot backup'time more long than cold backup'time.

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154714 is a reply to message #154708]

Tue, 10 January 2006 05:04

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

Senior Member
Account Moderator

>> I think that, Hot backup'time more long than cold backup'time
May be or may not be.
If you can afford to shutdown everyday , backup and bring them up online, you can go for it. But , this is a stone age method.
You are already have database in archived log mode ( That is like half-way through). Use RMAN.
You can incrementally backup along with archivedlogs/controlfile/spfile etc and even manage them easily.

To answer your question, please refer here
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96572/osbackups.htm#13966
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96572/osrestore.htm#28517
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96572/toc.htm

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154833 is a reply to message #154714]

Tue, 10 January 2006 20:37

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

Hi Rajendran,

1,My database'name is TEST.
2,I am using Windows 2000.
3,Can you help me step by step to make cold backup, archivelog backup and couple archived redo logs and cold backup so that recover full database.

Thank you verry much

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154853 is a reply to message #154833]

Wed, 11 January 2006 00:50

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

Senior Member
Account Moderator

Did you even try to read the above mentioned links?
>>Can you help me step by step to make cold backup
How exactly?
All step-by-step information, command line examples, possible scnenarios are given in documenation.

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154879 is a reply to message #154853]

Wed, 11 January 2006 02:10

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

Hi,
I have read and do the same way in this document. When I run.

SQL> SELECT THREAD#,SEQUENCE#,NAME FROM V$ARCHIVED_LOG;
the result: No rows selected

Even if I enable automatic archiving.
Therefore I can't backup arcived relo logs

Can you tell me why?????

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154887 is a reply to message #154879]

Wed, 11 January 2006 02:55

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

Senior Member
Account Moderator

may be you have no archived logs.
Post what you did. Else we have no idea what you are talking about. Login as sys and issue archived log list.
see whether you have archived log enable and automated on ( on contrary to what is shown here.)
Then check you archive destination.

sys@9i > archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/9.2.0/dbs/arch
Oldest online log sequence     68
Current log sequence           70

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154889 is a reply to message #154887]

Wed, 11 January 2006 03:16

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Disabled
Archive destination D:\oracle81\RDBMS
Oldest online log sequence 518
Next log sequence to archive 520
Current log sequence 520

But directory 'D:\oracle81\RDBMS' not contait log file

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154892 is a reply to message #154889]

Wed, 11 January 2006 03:22

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

Senior Member
Account Moderator

>>Automatic archival Disabled
You have to manually archive.
Google for it or refer documentation.

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154894 is a reply to message #154892]

Wed, 11 January 2006 03:27

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

I Perform Manual Archiving by command;
SQL> ALTER SYSTEM ARCHIVE LOG ALL;

But I can't view archived log file

SQL> SELECT THREAD#,SEQUENCE#,NAME FROM V$ARCHIVED_LOG;
the result: No rows selected

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154899 is a reply to message #154894]

Wed, 11 January 2006 03:37

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

Senior Member
Account Moderator

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/archredo.htm#14904

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154901 is a reply to message #154899]

Wed, 11 January 2006 03:41

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

I have read and do same this way in document. But I can't view Archived log file.

Can you help me step by step to sloves this

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #154903 is a reply to message #154901]

Wed, 11 January 2006 03:48

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

Senior Member
Account Moderator

It is step-by-step method.
As stated before, you have to post what you did.
Did you also issue
alter system switch logfile?

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #155235 is a reply to message #154903]

Thu, 12 January 2006 21:13

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

Hi,

My databse name is TEST
My database in Arachvelog mode
I am using ORACLE 8i on Windows 2000;

please tell me there steps:

1. Make cold backup of my database;
2. Manually archive for TEST;
3. Make archiverlog backup;
4. couple archived redo logs backup and cold backup so that recover Database.

Please help me, Can you show once full sample for this

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #155387 is a reply to message #155235]

Sun, 15 January 2006 20:23

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

please help me!!!!!!!!!!!

Report message to a moderator

Re: how to couple archived redo logs backup and cold backup together [message #155477 is a reply to message #155387]

Mon, 16 January 2006 08:08

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Restore the cold backup, and say "RECOVER DATABASE ...". Oracle will prompt you for the archived logs.

Report message to a moderator

Previous Topic:	TSPITR - ORA-1955
Next Topic:	Migration to Oracle 10

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 21:26:59 CDT 2024