Home » RDBMS Server » Backup & Recovery » Rman Backup R & D With Recovery Catalog (Oracle 10g R-2 on Rhel 4)
Rman Backup R & D With Recovery Catalog [message #360713] Sun, 23 November 2008 02:05 Go to next message
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

Re: Rman Backup R & D With Recovery Catalog [message #360735 is a reply to message #360713] Sun, 23 November 2008 17:17 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Please read the Forum Guide on how to format your post.
Previous Topic: Slow Backup
Next Topic: Beginner RMAN question
Goto Forum:
  


Current Time: Wed Dec 07 20:38:05 CST 2016

Total time taken to generate the page: 0.18924 seconds