RE: RMAN backup and restore Q?

From: Mercadante, Thomas F <Thomas.Mercadante_at_Labor.State.Ny.Us>
Date: Wed, 16 Jan 2002 05:35:03 -0800
Message-ID: <F001.003F138F.20020116050027@fatcity.com>

Jack,

What is the status of your target database? Try having it in "startup mount" status rather than "startup open".

The other thing you should do is to backup your control file (using Rman) with every database backup. I do this as my last step with every backup so that the latest changes within the control file are also saved.

Hope this helps

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, January 16, 2002 7:25 AM To: Multiple recipients of list ORACLE-L

Hi All,

I'm in the process of figuring out the workings of RMAN and created 2 test databases.
TEST1 = catalog database
TEST2 = target database

I have created the catalogs and registered the database with the catalog.

I than mad a full backup of the database TEST2 (is in Archivelog mode) with the following syntax

**************************BACKUP****************************************

rman <<EOF
connect target rman/rman_at_test2
connect catalog rman/rman_at_test1
run {
allocate channel d1 type disk;
backup full format '/data/oracle/BACKUP/rman_%d_%t_%U.bus'  database;
}
EOF

---

*

which created the database backup OK

When I try the restore however I get ORA 19753 cannot obtain exclusive enqueue for datafile 1.

****************************RESTORE*************************************

rman <<EOF
connect target rman/rman_at_test2
connect catalog rman/rman_at_test1
run {
allocate channel d1 type disk;
restore database;
recover database;
alter database open;
}
EOF

---

**

Checking the database TEST2 showed a shared MR lock in the v$lock view on all tablespaces.

What am I doing wrong here?

TIA Jack

---

De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.

---

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.

---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: nlzanen1_at_EY.NL

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: Thomas.Mercadante_at_Labor.State.Ny.Us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jan 16 2002 - 07:35:03 CST