| Rman Backup R & D With Recovery Catalog [message #360713] |
Sun, 23 November 2008 02:05  |
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
|
Member |
|
|
Dear friends.
I HAVE JUST INSTALLED ORACLE 10G AND DO DATABASE IN ARCIHVELOG MODE START ARCHIVING ONE ARCHIVE LOG IS GENERATED "1_2_671449779.dbf TO 1_6_671449779.dbf" HERE CURRENT SCN NO IS "504194". NOW I START FIRST RMAN FULL BACKUP WITH ARCHIVELOG. AFTER THAT I CREATED ONE TABLESPACE RAJ WITH USER RAJ AND TABLE NAME IS RAJ AND PUTTED ONE DATA "1" AND COMMIT. AND THEN :ALTER SYSTEM SWITCH LOGFILE" THEN ARCHIVELOG IS "1_7_671449779.dbf MEANS DATA IS IN LATEST ARCHIVELOG. THEN I LOGGING RMAN START FOLLOWING COMMAND.
restore database until logseq=6;
recover database until logseq=6; NOW
SQL> alter database open;
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open NORESETLOGS;
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/oracle/oradata/orcl/system01.dbf'
RMAN>recover datafile 1 until logseq=6;
SQL> alter database open;
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: '/home/oracle/oradata/orcl/undotbs01.dbf'
RMAN>recover datafile 2 until logseq=6;
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/home/oracle/oradata/orcl/sysaux01.dbf'
RMAN>recover datafile 3 until logseq=6;
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: '/home/oracle/oradata/orcl/users01.dbf'
RMAN>recover datafile 4 until logseq=6;
SQL> alter database open;
Database altered.
SQL> connect raj/raj
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RAJ TABLE
SQL> select * from raj;
select * from raj
*
ERROR at line 1:
ORA-00376: file 5 cannot be read at this time
ORA-01110: data file 5: '/home/oracle/oradata/raj.dbf'
SQL> desc raj;
Name Null? Type
----------------------------------------- -------- ---------------------------- ID NUMBER
SQL> ALTER TABLESPACE RAJ ONLINE;
Tablespace altered.
SQL> SELECT * FROM RAJ;
ID
----------
1
RMAN> RESTORE DATABASE UNTIL SCN 548693; ( TILL SCN NUMBER I HAVE CREATE THE TABLESPACE BUT NOT CREATE THE TABLE RAJ, I HAVE CREAETED THE TABLE AFTER THIS SCN)
Starting restore at 23-NOV-08
using channel ORA_DISK_1
creating datafile fno=5 name=/home/oracle/oradata/raj.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/23/2008 13:46:21
ORA-01119: error in creating database file '/home/oracle/oradata/raj.dbf'
ORA-27038: created file already exists
Additional information: 1
RMAN> RECOVER DATABASE UNTIL SCN 548693;
Starting recover at 23-NOV-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/23/2008 14:03:13
RMAN-06556: datafile 1 must be restored from backup older than scn 548693
MY QUESTION IS --
1. TILL ARCHIVE LOG SEQ 1_6 I DID NOT CREATE ANY TABLE AND TABLESPACES AND WHEN I RECOVER TILL 1_6 WHY RAJ TABLE COMES.
2. WHEN I TRIED TO OPEN DATABASE WITHOUT RESET LOGS IT SAYS TO OPEN WITH RESETLOG OR NORESETLOGS, AND WHEN OPENED WITH RESET LOGS IT SAYS MEDIA RECOVERY FOR SYSTEM FILE. WHAT IS HAS DONE AFTER DOING MEDIA RECOVERY ONE BY ONE FILES
3. WHY I AM NOT ABLE TO RESTORE DATABASE FROM GIVEN SCN 548693
WITH RGDS
RAJNISH KUMAR
[Updated on: Sun, 23 November 2008 02:40] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
