OraFAQ Forum: Backup & Recovery » hot backup in noarchivelog mode

Home » RDBMS Server » Backup & Recovery » hot backup in noarchivelog mode (Oracle 9i R2, Solaris)

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

hot backup in noarchivelog mode [message #506365]

Mon, 09 May 2011 00:05

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Good day...

I would like to validate with you Sirs
if I could execute the 'ALTER DATABASE BEGIN/END BACKUP'
while in NOARCHIVELOG MODE.

Thanks.

Report message to a moderator

Re: hot backup in noarchivelog mode [message #506366 is a reply to message #506365]

Mon, 09 May 2011 00:09

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Try it Your self first which will give you some good experience.
Good luck
Sriram

Report message to a moderator

Re: hot backup in noarchivelog mode [message #506367 is a reply to message #506366]

Mon, 09 May 2011 00:13

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

ind> select platform_name from v$database;

PLATFORM_NAME
--------------------------------------------------------------------------------
Microsoft Windows IA (32-bit)

1 row selected.

ind> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

1 row selected.

ind> ALTER DATABASE BEGIN/END BACKUP;
ALTER DATABASE BEGIN/END BACKUP
                    *
ERROR at line 1:
ORA-01906: BACKUP keyword expected


ind> ALTER DATABASE BEGIN BACKUP;
ALTER DATABASE BEGIN BACKUP
*
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled

Report message to a moderator

Re: hot backup in noarchivelog mode [message #506373 is a reply to message #506367]

Mon, 09 May 2011 00:53

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Thanks for this...

Btw, I misinformed you of the Oracle version, it should be
Oracle 9i R1 only, sorry for this.

This is what I've got (using individual tablespace backup)
as you advised:

$ sqlplus /nolog

SQL*Plus: Release 9.0.1.0.0 - Production on Mon May 9 13:44:38 2011
(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

SQL> alter database begin backup;
alter database begin backup
*
ERROR at line 1:
ORA-00905: missing keyword

SQL> select file_name from dba_data_files;

FILE_NAME
------------------------------------------
/appl/orcl/oradata/sid1/system01.dbf
/appl/orcl/oradata/sid1/undotbs01.dbf
/appl/orcl/oradata/sid1/cwmlite01.dbf
/appl/orcl/oradata/sid1/drsys01.dbf
/appl/orcl/oradata/sid1/example01.dbf
/appl/orcl/oradata/sid1/indx01.dbf
/appl/orcl/oradata/sid1/tools01.dbf
/appl/orcl/oradata/sid1/users01.dbf
/appl/sid1.dbf

9 rows selected.

SQL> alter tablespace EXAMPLE begin backup;
alter tablespace EXAMPLE begin backup
*
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled

SQL>

Thanks again.

Report message to a moderator

Re: hot backup in noarchivelog mode [message #506379 is a reply to message #506373]

Mon, 09 May 2011 01:10

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Cause: An attempt to start backup of an
on-line tablespace failed because media recovery is not enabled.
Action: Enable media recovery and retry
this operation.

Report message to a moderator

Re: hot backup in noarchivelog mode [message #506385 is a reply to message #506373]

Mon, 09 May 2011 01:30

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You cannot make a hot backup in noarchivelog mode.
You can only make cold backup (that is you have to first close the database).
If you want to do hot backup (that is database open) you must be in archivelog mode.

Regards
Michel

Report message to a moderator

Re: hot backup in noarchivelog mode [message #506590 is a reply to message #506385]

Tue, 10 May 2011 02:57

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Sir, many thanks for this confirmation.

That's what all I need to hear!

Regards ...

Report message to a moderator

Previous Topic:	Controlfile piece handle lost from Tape
Next Topic:	Recovery from 'create tables as'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 01:12:46 CDT 2024