Page History

Table of Contents

Version

All versions

Unable to perform an online backup.

An online backup has been performed in NO ARCHIVING mode.

An online backup can only be performed in ARCHIVING mode. Otherwise, an error occurs.

Check whether the database is running in ARCHIVING mode with the following command:

Code Block

language	sql

iSQL>select archivelog_mode from v$log;
ARCHIVELOG_MODE
------------------------
NOARCHIVE

<How to change to ARCHIVING mode from NOARCHIVING mode>

1. Shut down the database.

2. Re-start the database.

3. Run the database in the CONTROL phase.

Code Block
SHELL>server stop SHELL>is –silent –sysdba

Note
ERR-910FB : Connected to idle instance isql(sysdba)>startup control

4. Change to ARCHIVING mode using the ALTER DATABASE ARCHIVELOG statement.

Code Block

language	sql

isql(sysdba)>alter database archivelog

<Execute an online backup in ARCHIVING MODE>

1. Run the database in the SERVICE phase.

Code Block

language	sql

isql(sysdba)>startup service

2. Re-start backup.

N/A