Home » RDBMS Server » Backup & Recovery » About downloaded Oracle 10.2 from Internet
About downloaded Oracle 10.2 from Internet [message #345397] Wed, 03 September 2008 06:59 Go to next message
raj_roshan_009
Messages: 29
Registered: May 2008
Junior Member
Hi all,

I want to know,Is the downloaded Oracle 10.2 version for window platform contains all feature espacially RMAN.

The Problem is:--

i downloaded the oracle 10g from internet and configure rman,create catalog,register database and then take backup as RMAN>backup database;

Now when i write the command--
RMAN>list backup;

RMAN>


it shows nothing,even not giving any error.

Please help me,

Regards
Roshan.


Re: About downloaded Oracle 10.2 from Internet [message #345399 is a reply to message #345397] Wed, 03 September 2008 07:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
I want to know,Is the downloaded Oracle 10.2 version for window platform contains all feature espacially RMAN.

Yes.

Now post all what you did if you want help.
Copy and paste your session.
Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.


Regards
Michel
Re: About downloaded Oracle 10.2 from Internet [message #345530 is a reply to message #345399] Thu, 04 September 2008 00:28 Go to previous messageGo to next message
raj_roshan_009
Messages: 29
Registered: May 2008
Junior Member
Hi,

SQL> create user rman identified by rman
  2  default tablespace rman temporary tablespace temp;

User created.

SQL> grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.

C:\>rman

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Sep 4 10:04:53 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> connect catalog rman/rman

connected to recovery catalog database

RMAN> create catalog tablespace "RMAN";

recovery catalog created

C:\>rman target / catalog rman/rman

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Sep 4 10:07:59 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: PRO (DBID=840151431)
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> run{
2> allocate channel c1 type disk;
3> backup database format 'db_%u_%d_%s';
4> backup format 'log_t%t_s%s_p%p'
5> (archivelog all);
6> }

allocated channel: c1
channel c1: sid=158 devtype=DISK

Starting backup at 04-SEP-08
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRO\SYSTEM01.DBF
input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRO\SYSAUX01.DBF
input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRO\EXAMPLE01.DBF

input datafile fno=00006 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRO\RMAN01.DBF
input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRO\UNDOTBS01.DBF

input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRO\USERS01.DBF
channel c1: starting piece 1 at 04-SEP-08
channel c1: finished piece 1 at 04-SEP-08
piece handle=C:\ORACLE\PRODUCT\10.2.0\DB_3\DATABASE\DB_12JPO40N_PRO_34 tag=TAG20
080904T101238 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:45
Finished backup at 04-SEP-08

Starting backup at 04-SEP-08
current log archived
specification does not match any archive log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 04-SEP-08

Starting Control File and SPFILE Autobackup at 04-SEP-08
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PRO\AUTOBACKUP\2008_09
_04\O1_MF_S_664539210_4CYSVMOZ_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 04-SEP-08
released channel: c1

RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       8       PRO      840151431        PARENT  1          30-AUG-05
1       2       PRO      840151431        CURRENT 534907     28-JAN-09


Problem 1) when we type “list copy of database”, it shows nothing, not even error. The Prompt simply goes to RMAN.

RMAN> list copy of database;

RMAN>

Or,

RMAN> list backup of database;

RMAN>


Problem 2)

RMAN> run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> restore database;
6> recover database;
7> alter database open;
8> }

allocated channel: c1
channel c1: sid=158 devtype=DISK

allocated channel: c2
channel c2: sid=133 devtype=DISK

allocated channel: c3
channel c3: sid=132 devtype=DISK

Starting restore at 04-SEP-08

released channel: c1
released channel: c2
released channel: c3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/04/2008 10:18:00
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore


I don't Know what is the reason behind it,Please help me.

Regards
Roshan.
Re: About downloaded Oracle 10.2 from Internet [message #345561 is a reply to message #345530] Thu, 04 September 2008 03:54 Go to previous messageGo to next message
mmee
Messages: 38
Registered: July 2007
Member

hello

after backup validate your database? post your message.


Re: About downloaded Oracle 10.2 from Internet [message #345646 is a reply to message #345530] Thu, 04 September 2008 06:25 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>input datafile fno=00006 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRO\RMAN01.DBF
Why are you backing RMAN database with RMAN?
How do you expect the restore the catalog database using the same catalog?
Quote:

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 8 PRO 840151431 PARENT 1 30-AUG-05
1 2 PRO 840151431 CURRENT 534907 28-JAN-09

How come your current reset time is in future?
Usually, an RMAN backup will do an implicit resync.
I am not seeing it your post. Seems you did not post
the whole output.

try a resync
followed by
list backup;
Previous Topic: Recover Database - All Files Deleted while DB was running
Next Topic: RMAN CROSS PLATFORM DUPLICATE
Goto Forum:
  


Current Time: Fri Nov 22 12:26:25 CST 2024