Oracle, RMAN

ORA-19602: RMAN Noarchivelog Mode Tips

This is why oracle does not recommend running database in NOARCHIVELOG mode and does not allow full database backups when database is on noarchivelog mode.

Here we will discuss how to workaround the “RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode” error while taking RMAN database backups while running the DB on NOARCHIVELOG mode.

RMAN> backup database;
Starting backup at 25-JUL-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/25/2018 14:47:32
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 25-JUL-18
channel ORA_DISK_1: finished piece 1 at 25-JUL-18
piece handle=/oracle/product/11.2.0.4/db/dbs/0dt8t3o4_1_1 tag=TAG20180725T144732 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/25/2018 14:47:32
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

RMAN>

The following script shuts down the database and start it in mount mode, and then creates a backup of the database:

To overcome “RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode” issue we have to take cold backup of database by following below steps:

steps :

1. Shutdown database
2. Startup database in mount mode
3. Execute backup database command.
4. Check backup taken successfully.
5. Start database open.
Example:

RMAN> run
{
shutdown immediate
startup mount
backup database;

}

Advertisements
Standard
Network, Oracle

Changing Listener Port Number for Database Connection Requests

To change the listener port number for database connection requests to 1522:To change the listener port number for database connection requests to 1522:
Stop the listener.
See “Stopping and Starting the Listener” for instructions.
Open the file listener.ora with a text editor.
Table: Location of the listener.ora File shows the location of this file on each platform.
Location of the listener.ora File
Platform LocationLinux
cd $ORACLE_HOME/network/admin/vi listener.ora
Windows
c:\oracledba\app\oracle\product\10.2.0\server\NETWORK\ADMIN\

Locate the following section of the file:
LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))      (ADDRESS = (PROTOCOL = TCP)(HOST = dberman)(PORT = 1521))    )  )
Note that the line indicated in bold may or may not be present in the file.
Change the text (PORT = 1521) to (PORT = 1522).
Save the modified listener.ora file.
Start the listener.
See “Stopping and Starting the Listener” for instructions.
Start SQL Command Line and connect to the database as user SYSTEM.
See “Connecting Locally with SQL Command Line” for instructions. You must supply the SYSTEM password. You set this password upon installation (Windows) or configuration (Linux) of Oracle Database dba.
Enter the following two commands:
ALTER SYSTEM SET LOCAL_LISTENER = “(ADDRESS=(PROTOCOL=TCP)(HOST=dberman.mydomain.com)(PORT=1522))”;
ALTER SYSTEM REGISTER;
Exit SQL Command Line and run the lsnrctl status command to verify the port number change.
The new port number should be displayed in the Listening Endpoints Summary section of the status report, and the report should include the following lines:
Service “dba” has 1 instance(s).  Instance “dba”, status READY, has 1 handler(s) for this service…

Standard
Oracle

change / move the Oracle Inventory

Hi,

The below steps will help you to change / move the Oracle Inventory to other locations for Linux flavor setups:

Find the current location of the Oracle Inventory (default $ORACLE_BASE/oraInventory):

For example:

[oracle@tto ~]$ cd $ORACLE_BASE

[oracle@tto app]$ pwd
/opt/app

find . -name oraInventory -print

[oracle@tto app]$ find . -name oraInventory -print
find: ./oracle/product/11.2.0/db_1/opmn/conf: Permission denied
find: ./oracle/product/11.2.0/db_1/opmn/logs: Permission denied
find: ./oracle/product/11.2.0/db_1/inventory/ContentsXML/ConfigXML: Permission denied
find: ./oracle/product/11.2.0/db_1/cfgtoollogs/cfgfw: Permission denied
./oraInventory

Open the oraInst.loc file in /etc/ and check the value of inventory_loc

[oracle@tto app]$ cat /etc/oraInst.loc
inventory_loc=/opt/app/oraInventory
inst_group=oinstall

Copy the oraInventory directory to the destination directory

cp -Rp /opt/app/oraInventory /home/oracle/oraInventory

Edit the oraInst.loc file to point to the new location

For example:

vi /etc/oraInst.loc
inventory_loc=/home/oracle/oraInventory inst_group=dba

Note: The oraInst.loc file is simply a pointer to the location of the Oracle Inventory (oraInventory)

Regards, Erman

Standard