Home » RDBMS Server » Backup & Recovery » hot backup in noarchivelog mode (Oracle 9i R2, Solaris)
hot backup in noarchivelog mode [message #506365] Mon, 09 May 2011 00:05 Go to next message
reym21
Messages: 210
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.
Re: hot backup in noarchivelog mode [message #506366 is a reply to message #506365] Mon, 09 May 2011 00:09 Go to previous messageGo to next message
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
Re: hot backup in noarchivelog mode [message #506367 is a reply to message #506366] Mon, 09 May 2011 00:13 Go to previous messageGo to next message
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

Re: hot backup in noarchivelog mode [message #506373 is a reply to message #506367] Mon, 09 May 2011 00:53 Go to previous messageGo to next message
reym21
Messages: 210
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.
Re: hot backup in noarchivelog mode [message #506379 is a reply to message #506373] Mon, 09 May 2011 01:10 Go to previous messageGo to next message
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.
Re: hot backup in noarchivelog mode [message #506385 is a reply to message #506373] Mon, 09 May 2011 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 65567
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
Re: hot backup in noarchivelog mode [message #506590 is a reply to message #506385] Tue, 10 May 2011 02:57 Go to previous message
reym21
Messages: 210
Registered: February 2010
Location: Philippines
Senior Member

Sir, many thanks for this confirmation.

That's what all I need to hear!

Regards ...
Previous Topic: Controlfile piece handle lost from Tape
Next Topic: Recovery from 'create tables as'
Goto Forum:
  


Current Time: Fri Jul 20 06:01:23 CDT 2018