About downloaded Oracle 10.2 from Internet [message #345397] |
Wed, 03 September 2008 06:59 |
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 #345530 is a reply to message #345399] |
Thu, 04 September 2008 00:28 |
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 #345646 is a reply to message #345530] |
Thu, 04 September 2008 06:25 |
|
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
|
|
|